Senior Analytics Engineer - Power BI

The Senior Analytics engineer will serve as a key contributor and subject matter expert within our enterprise analytics program. This role combines advanced BI development, data modeling, Power BI administration and visualization design with strong business acumen. You will partner closely with stakeholders across the departments to turn data into actionable insights. You will be part of the team responsible for migrating its on-prem DWH to databricks on AWS and will be responsible for converting/migrating/recreating existing reports into Power BI dashboard. You will work closely with Technology teams in administering the Power BI environment.

This is a highly visible, high‑impact position responsible for elevating our reporting capabilities and enabling data‑driven decisions across the credit union.

Essential Job Functions/Responsibilities:  

Power BI Development & Reporting

• Design, build, and optimize enterprise‑grade Power BI dashboards, semantic models, and reports that meet business and regulatory needs.

• Develop reusable measures and standardized KPI definitions.

• Implement best‑practice visualization principles (usability, design consistency, performance).

• Develop and maintain Power BI datasets, dataflows, and paginated reports.

• Monitor the performance of BI solutions and implement improvements to enhance speed and efficiency.

• Follow documentation practices.

Data Modeling & Transformation

• Build robust star and snowflake data models aligned to our enterprise data architecture.

• Write & optimize DAX calculations, query performance, and refresh strategies.

• Use Power Query (M) to transform and shape data efficiently.

• Work with data engineers to enhance the data lakehouse, warehouse, and ETL pipelines to support analytics consumption.

Deployment & Lifecycle ownership

• Deployment of pipelines (Dev/Test/Prod promotion).

• Create and perform Version control strategy.

• Perform Semantic model lifecycle management.

• Perform Impact analysis prior to deployment.

Testing & Quality

• Build & implement Validation frameworks.

• Perform regression testing of measures and KPIs and support user testing.

• Develop documentation standards and follow documentation practices.

• Participate in Change management.

Governance & Standards

• Define and enforce Power BI governance, including workspace strategy, RLS/OLS security models, and dataset certification.

• Ensure reports follow compliance and audit standards required for a regulated financial institution.

• Contribute to enterprise documentation, metric dictionaries, and reusable templates.

• Ensure consistency and accuracy of enterprise KPIs.

Stakeholder Engagement

• Partner with business units to understand requirements, translate them into technical specifications, and deliver high‑quality BI products.

• Communicate insights clearly to executives and operational teams.

• Provide mentorship to junior analysts and promote a self‑service analytics culture.

Platform Administration & Optimization

• Perform Power BI Service administration: capacity planning, gateways, refresh schedules, workspace organization.

• Monitor performance, optimize datasets, and troubleshoot issues across the platform and data pipelines.

• Support scheduled refreshes and troubleshoot data issues.

• Establish and maintain connections in Power BI online and Power BI gateway.

• Helps provision and maintain access to Power BI online and its components.

Minimum Job Qualifications:

Required

• Bachelor’s degree in computer science, Information Technology, Data Science, or a related field. Master’s degree is a plus.

• 7 - 10 + years of experience in BI development, with at least 4 to 5+ years in Power BI

• Expert‑level DAX and Power Query/M skills.

• Strong understanding of data warehousing concepts: dimensional modeling, star schemas, ETL/ELT patterns.

• Experience using SQL (SQL Server).

• Proven ability to work with complex, enterprise‑scale datasets.

• Strong communication skills and ability to translate business problems into data solutions.

• Knowledge of Power BI Admin, capacity management, and tenant governance.

Preferred

• Experience in financial services or highly regulated industries.

• Experience in Lakehouse or warehouse architectures (Databricks, Synapse, Fabric, etc.).

• Experience working in Databricks Lakehouse.

• Experience in cloud platforms (AWS) preferred.

• Experience implementing data governance standards, dataset certification, metadata management.

• Familiarity with CI/CD pipelines for Power BI deployments (ALM Toolkit, Azure DevOps, Fabric Git integration).

• Understanding of performance tuning and incremental refresh.

• Experience building paginated or operational reports.