Business Intelligence (BI) Analyst II

Rockland Trust is a fullservice commercial bank and financial services company committed to helping our neighbors reach their financial goals. Founded in 1907 and headquartered in Massachusetts, we proudly serve individuals, families, and businesses throughout New England with a strong emphasis on personal relationships, local decisionmaking, and community impact.

With a broad range of banking, wealth management, and investment solutions, Rockland Trust combines the resources of a growing financial institution with the personalized service of a community bank. Our longstanding philosophy-Where Each Relationship Matters-guides how we work with our customers, colleagues, and communities every day.

At Rockland Trust, our employees are at the heart of our success. We foster a collaborative, inclusive, and valuesdriven culture that encourages professional growth, innovation, and worklife balance. We are deeply committed to community involvement, financial education, and creating a workplace where individuals can build meaningful, longterm careers.

Position Overview

We are seeking a detail-oriented Business Intelligence (BI) Analyst II to support data-driven decision-making within a growing community bank with approximately $25 billion in assets. This role is ideal for a professional with 2-4 years of experience who thrives in a collaborative environment and is passionate about leveraging data to enhance financial performance, customer experience, and regulatory compliance.

The BI Analyst II will partner with business units such as Retail Banking, Commercial Banking, Finance, Risk, and Operations to deliver insights, reporting, and dashboards that support strategic and operational goals.

Key Responsibilities

Reporting & Dashboard Development

• Develop, enhance, and maintain dashboards and reporting solutions using Power BI (or comparable BI platforms).
• Build and maintain datasets, semantic models, and measures (DAX).
• Design reports that are visually intuitive, scalable, and aligned with business needs.

Data Analysis & Business Insights

• Analyze business performance trends and provide actionable insights.
• Support KPI development, metric definitions, and standard reporting frameworks.
• Assist business partners in interpreting data and validating results.

SQL & Data Validation

• Write, optimize, and maintain SQL queries for extracting and transforming data.
• Perform data validation and reconciliation to ensure reporting accuracy.
• Partner with data engineering teams to resolve data quality issues.

Requirements Gathering & Stakeholder Engagement

• Gather requirements through meetings, interviews, and documentation.
• Translate business questions into technical reporting requirements.
• Manage stakeholder expectations and communicate project progress clearly.

Documentation & Governance

• Create and maintain documentation for reports, data models, definitions, and refresh schedules.
• Support data governance efforts including consistent metric definitions and report certification practices.
• Follow SDLC / change control processes in regulated environments.

Operational Support

• Monitor scheduled report refreshes and resolve refresh failures.
• Provide production support for BI reporting solutions.
• Participate in on-call or incident response rotation if required.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Finance, or a related field (or equivalent experience).
• 3-5 years of experience in business intelligence, reporting, analytics, or data visualization.
• Strong experience with Power BI (dashboards, DAX, Power Query).
• Strong SQL skills with experience working in relational databases (SQL Server preferred).
• Experience working with business stakeholders to gather requirements and deliver solutions.

• Strong attention to detail and ability to validate and reconcile data.

Preferred Qualifications

• Experience in financial services / banking environment.
• Familiarity with data warehouse concepts (star schema, fact/dimension modeling).
• Experience with SSRS, SSIS, Azure Data Factory, Snowflake, dbt, or Azure Synapse.
• Understanding of data governance tools (Collibra, data catalogs, lineage tools).

• Experience working in Agile or hybrid Agile environments (Azure DevOps preferred).

Core Skills & Competencies

• Strong analytical thinking and problem-solving skills
• Excellent written and verbal communication
• Ability to work independently and prioritize multiple deliverables
• Strong customer service mindset and stakeholder management
• Ability to explain technical concepts to non-technical audiences
• Comfortable working with sensitive or regulated data

What Success Looks Like

• Business stakeholders trust the accuracy and usefulness of reports.
• Dashboards are performant, intuitive, and widely adopted.
• Metrics and KPI definitions are consistent across the organization.
• Issues are proactively identified and resolved before impacting leadership reporting.

Benefits & Culture

Our goal is to offer our colleagues the most generous benefits package possible. We provide a comprehensive suite of benefits designed to support your health, financial security, and overall, well being. Benefits include: competitive compensation with performance based incentive awards, health and dental insurance, a 401(k) and DC retirement plan, LTD and life insurance, paid vacation, day care reimbursement, tuition assistance for undergraduate and graduate programs, an award winning wellness program, and much more!

At Rockland Trust, you'll find a respectful and inclusive environment where everyone has the opportunity to succeed. We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Pay Transparency

Compensation for this role will be based on a variety of factors, including skills, experience, education, and internal equity. The salary range posted reflects the company's good faith estimate of the range for this position at the time of posting. Actual compensation may vary. In addition to base salary, certain positions may be eligible for additional compensation, including commissions, incentive awards or stipends.

Accessibility & Accommodations

We are committed to providing reasonable accommodations to enable individuals with disabilities to perform the essential functions of their roles.