Senior Data Analyst - Finance

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.