Senior Data Analyst - Finance

In this onsite role in Minneapolis, MN, you will support Finance reporting and analytics by building trusted datasets and semantic models in Microsoft Fabric and Power BI, then delivering clear, business-ready reporting experiences for Finance stakeholders.

Key Responsibilities

• Collaborate in a cross-functional, team-based environment and facilitate conversations across stakeholders.
• Design and build Power BI reports and dashboards that enable Finance leaders and teams to make decisions.
• Translate requirements into effective visuals, tooltips, drill paths, and narrative elements that highlight key drivers and exceptions.
• Apply visualization standards including layout, accessibility, and consistent KPI definitions.
• Optimize report performance through model usage, interactions, and visual optimization.
• Design, build, and maintain Power BI/Fabric semantic models using approaches such as star schemas, relationships, and calculation groups as applicable.
• Create reusable DAX measures and KPI definitions; document metric logic and align reporting outputs to Finance definitions and standards.
• Build and maintain reliable data shaping pipelines using tools such as SQL, Power Query, and Dataflows Gen2, including reconciliations and 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, and contribute to improvements in release and validation.
• Monitor and enhance model and report performance, refresh reliability, and scalability; troubleshoot issues and implement sustainable fixes.
• Implement security patterns such as RLS/OLS, access controls, and governance aligned practices for Finance reporting solutions.
• Provide training, documentation, and guidance to help users leverage data effectively.
• Serve as a trusted resource for ongoing reporting and analytics requests, including peer support and informal mentoring.
• Identify automation opportunities and streamline manual reporting processes.
• Support special analytics projects, data quality initiatives, and modernization efforts.
• Stay up to date on Power BI features and industry best practices, including processes to consume and consolidate large datasets into centralized, repeatable measurements.
• Review Finance data consistently, partner with cross-functional teams, and drive corrective action and long-term solutions when needed.
• Track and report Data Quality and Data Governance KPIs for Finance.
• Contribute to long-term BI and Data strategy and identify strategic initiatives.
• Perform all other duties as assigned.

Required Qualifications

• Minimum 3 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 such as semantic models, workspaces, refresh, and 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 convert business questions into actionable BI solutions.
• Familiarity with Fabric/Azure data services (for example, Lakehouse/Warehouse concepts, SQL endpoints, Azure SQL, Data Factory/Synapse as applicable).
• Superior attention to detail and accuracy.
• Proven positive, professional attitude with strong customer service skills.
• Strong communication skills with the ability to present data clearly.
• Ability to assess, prioritize, and manage multiple stakeholder needs while delivering high-quality work on time.
• Agile product delivery and sprint planning experience.
• Education: Bachelor’s Degree.

Preferred Qualifications

• Knowledge of Python or R for analytics and data transformations.
• Experience using Git or other version control systems.
• Microsoft BI or data engineering certifications.

Technologies

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

Compensation

• Base pay range: USD 96,400 - 144,700 per year.
• The 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 with 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 note: for Non-Craft & Non-Union Craft working 25+ hours/week.

Additional Information

• Visa sponsorship is not offered for this position.
• Postings are typically open a minimum of 5 days and an average of 44 days.
• Mortenson reserves the right to hire any individual without legal or financial obligation on unwanted solicitations. No agency emails, calls, or solicitations are accepted without a valid agreement.
• Must be currently legally authorized to work in the U.S. without sponsorship (for example, H1B, 0-1, TN, CPT, OPT). The company is unable to sponsor or take over sponsorship of an employment visa at this time.