Senior Data Analyst - Finance

HQ Business Support-GROUP; Minneapolis (MN); On-site; USD 96,000 - 145,000; Full time

Benefits offered by this job

Medical and prescription drug plans

Dental plan

401k retirement plan with companymatch

Paid time off and holidays

Life/AD&D and disability insurance

Mental health resources

Tuition reimbursement

Adoption assistance

Gym membership discount

Job summary

HQ Business Support-GROUP in Minneapolis, MN seeks an experienced BI Engineer to design and build Power BI reports, semantic models, and Fabric-based data structures for Finance analytics.

You will implement DAX measures, SQL data pipelines, and CI/CD practices, collaborating with stakeholders to deliver secure, scalable dashboards that enable confident decision-making.

Qualifications

• 3-6 years of professional experience delivering Power BI solutions with semantic modeling.
• Experience with Fabric, Power BI workspaces, and refresh architectures.

Responsibilities

• Design and build intuitive Power BI reports and dashboards for Finance decisions.
• Translate reporting requirements into visuals, tooltips, drill paths, and narratives.
• Apply visualization standards for layout, accessibility, and KPI definitions.
• Engineer trusted, reusable semantic models in Power BI/Fabric.
• Develop DAX measures and KPI definitions; document metric logic.
• Build data shaping pipelines using SQL, Power Query, Dataflows Gen2.
• Manage Fabric/Power BI workspaces, semantic models, and refresh processes.
• Use CI/CD practices for deployments and version control.
• Monitor and optimize model/report performance and reliability.
• Implement security and governance patterns like RLS/OLS.
• Collaborate with teams, provide training and documentation.
• Identify automation to streamline reporting and analytics.

Skills

Power BI

Semantic modeling

DAX

Power Query

SQL/T-SQL

Fabric/Azure data services

CI/CD

Git

Python/R (nice to have)

Agile/Sprint Planning

Education

Bachelor’s Degree

Tools

SQL Server

Dataflows Gen2

Azure SQL

Synapse

Lakehouse/Warehouse concepts

Job description

Join HQ Business Support-GROUP in Minneapolis, MN to support Finance reporting and analytics with trusted, reusable data foundations. You will build and refine Microsoft Fabric and Power BI semantic models and reporting experiences that help Finance leaders make decisions with confidence. This onsite role offers a competitive base pay range, comprehensive benefits, and support for ongoing learning.

What you’ll work on

• Design and build intuitive Power BI reports and dashboards to enable Finance decision-making.
• Translate reporting requirements into visuals, tooltips, drill paths, and narrative elements that highlight key drivers and exceptions.
• Apply visualization standards including layout, accessibility, and consistent KPI definitions, while optimizing report performance through model usage, interactions, and visuals.
• Engineer trusted, reusable semantic models in Power BI/Fabric (including star schemas, relationships, and calculation groups as applicable).
• Develop reusable DAX measures and KPI definitions, document metric logic, and align with Finance definitions and reporting standards.
• Build and maintain reliable data shaping pipelines (for example SQL, Power Query, Dataflows Gen2) and implement reconciliations/controls to validate completeness and accuracy.
• Manage and support Fabric/Power BI workspaces, semantic models, and refresh processes in coordination with BI platform administrators.
• Use established CI/CD practices such as deployment pipelines and version control where available; contribute to improvements in release and validation processes.
• Monitor and enhance model/report performance, refresh reliability, and scalability; troubleshoot issues and implement sustainable fixes.
• Implement security and governance aligned patterns such as RLS/OLS and access controls for Finance reporting solutions.
• Partner with teams to understand reporting needs, provide training and documentation, and act as a trusted resource for ongoing analytics requests.
• Identify automation opportunities to streamline manual reporting and support special analytics projects, data quality initiatives, and modernization efforts.

What you bring

• 3-6 years of professional experience delivering Power BI solutions, including semantic modeling and end-user reporting.
• Strong command of Power BI (Desktop/Service) and Microsoft Fabric concepts (semantic models, workspaces, refresh, security).
• Advanced experience with SQL Server and T-SQL, including database design.
• Advanced knowledge of DAX and Power Query (M).
• Proven experience with dimensional modeling (star schemas), semantic model design, and performance tuning for self-service analytics.
• Ability to turn business questions into actionable BI solutions.
• Familiarity with Fabric/Azure data services such as Lakehouse/Warehouse concepts, SQL endpoints, Azure SQL, Data Factory/Synapse as applicable.
• Superior attention to detail, strong communication skills, and a professional, customer-service focused attitude.
• Ability to assess, prioritize, and manage multiple stakeholder needs while delivering high-quality work on time.
• Agile Product delivery and Sprint Planning experience.
• Nice to have: Knowledge of Python or R; experience with Git or other version control; Microsoft BI or data engineering certifications.
• Education: Bachelor’s Degree. (Or, high school diploma or GED and 8+ years related experience.)

Tools you’ll use

Microsoft Fabric, Power BI, DAX, Power Query, M, SQL, Dataflows Gen2, SQL Server, T-SQL, CI/CD, CI/CD deployment pipelines, Git, Python, R, RLS, OLS, Azure SQL, Azure Data Factory, Synapse, Lakehouse/Warehouse concepts, Power BI Desktop, Power BI Service.

Compensation

The base pay range for this role is $96,400 - $144,700 per year. Actual range is higher for certain office locations: Denver, CO and Chicago, IL (+5%); Seattle, WA and Portland, OR (+10%); Washington, D.C. (+12.5%).

Benefits

• Medical and prescription drug plans that includes no additional cost vision coverage
• Dental plan
• 401k retirement plan with a generous Mortenson match
• Paid time off, holidays, and other paid leaves
• Employer paid Life, AD&D, and disability insurance
• No-Cost mental health tool and concierge with extensive work-life resources
• Tuition reimbursement
• Adoption Assistance
• Gym Membership Discount Program

Additional details

• Visa sponsorship is not offered for this position.
• Postings are typically open a minimum of 5 days and an average of 44 days.
• Must be currently legally authorized to work in the U.S. without sponsorship for employment visa status (examples include H1B, 0-1, TN, CPT, OPT). The company is unable to sponsor or take over sponsorship at this time.