Senior Data Analyst - Finance

M. A. Mortenson Company offers a hybrid work arrangement in Minneapolis, MN, with a competitive compensation range and comprehensive benefits. This Senior Data Analyst - Finance role focuses on engineering trusted datasets and semantic models in Microsoft Fabric and Power BI to deliver intuitive, business-ready reporting experiences. You will partner with Finance leaders, data consumers, and cross-functional data teams to translate business questions into governed metrics, performant models, and self-service visuals.

Responsibilities

• Participate in cross-functional, collaborative, team-based discussions to align on needs and solutions
• Visualization and report development with Power BI: design and build intuitive reports and dashboards that support finance decision-making
• Translate requirements into effective visuals, tooltips, drill paths, and narrative elements that highlight key drivers and exceptions
• Apply visualization standards for layout, accessibility, and KPI definitions; optimize report performance
• Analytics engineering and semantic modeling: design, build, and maintain Power BI and Fabric semantic models that support consistent, trusted reporting
• Develop reusable DAX measures and KPI definitions; document metric logic and ensure alignment with Finance definitions
• Build and maintain reliable data shaping pipelines (SQL, Power Query, Dataflows Gen2) with reconciliations to validate completeness and accuracy
• Platform management and optimization: manage Fabric/Power BI workspaces, semantic models, and refresh processes in coordination with BI platform administrators
• Leverage CI/CD practices where available; contribute to release and validation processes
• Monitor model and report performance, refresh reliability, and scalability; troubleshoot and implement sustainable fixes
• Implement and maintain appropriate security patterns (eg, RLS/OLS), access controls, and governance-aligned practices for Finance reporting
• Collaborate with teams to understand reporting requirements and provide training, documentation, and guidance to users
• Serve as a trusted resource for ongoing reporting and analytics requests; demonstrate advanced analytical and problem-solving skills
• Contribute to long-term BI and data strategy; identify automation opportunities to streamline manual reporting
• Support special analytics projects, data quality initiatives, and modernization efforts; stay current with Power BI features and best practices
• Develop processes to consume and consolidate large data sets into centralized, sustainable measurements
• Review finance data and partner with cross-functional teams to implement corrective actions and long-term solutions
• Apply advanced knowledge of Microsoft toolset, data operations practices, and governance
• Track and report data quality and data governance KPIs for Finance; provide peer support and informal mentoring as needed
• Identify and implement strategic initiatives to enhance analytics capabilities

Requirements

• Bachelor’s Degree with 3–5 years of related experience; or a high school diploma/GED with 8+ years of related experience
• 3–6 years 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, T-SQL, or 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 translate business questions into actionable BI solutions
• Familiarity with Fabric/Azure data services (Lakehouse/Warehouse concepts, SQL endpoints, Azure SQL, Data Factory/Synapse as applicable)
• Superior attention to detail and accuracy
• Professional demeanor with strong customer service and communication skills; ability to present data clearly
• Ability to manage multiple stakeholder needs while delivering high-quality work on time
• Experience with Agile product delivery and sprint planning
• Nice to have: Python or R for analytics and data transformations
• Nice to have: Git or other version control experience
• Nice to have: Microsoft BI or data engineering certifications

Technologies

• Microsoft Fabric
• Power BI
• DAX
• Power Query (M)
• SQL Server
• T-SQL
• Dataflows Gen2
• Git
• Python
• R
• Lakehouse/Warehouse concepts, SQL endpoints, Azure SQL, Data Factory, Synapse

Benefits

• Medical and prescription drug plans with no additional cost vision coverage
• Dental plan
• 401k 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 tools and work-life resources
• Tuition reimbursement
• Adoption assistance
• Gym membership discount program

Other items to note

• 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 legally authorized to work in the United States without sponsorship for employment visa status. Mortenson cannot sponsor or take over sponsorship for an employment visa at this time.