Business Intelligence (BI) Analyst II

Rockland Trust Company•Plymouth, MA

18h

About The Position

Rockland Trust is a full‑service 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 decision‑making, 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 long‑standing 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 values‑driven culture that encourages professional growth, innovation, and work‑life balance. We are deeply committed to community involvement, financial education, and creating a workplace where individuals can build meaningful, long‑term 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.

Requirements

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.
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

Nice To Haves

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).

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.