Senior Data Analyst - Finance

Mortenson • Robbinsdale, MN

7h • $96,400 - $144,700

About The Position

Mortenson is seeking a Senior Data Analyst - Finance to support Finance reporting and analytics by engineering trusted, reusable datasets and semantic models in Microsoft Fabric and Power BI, and by delivering intuitive, business-ready reporting experiences. The role partners with Finance leaders, data consumers, and cross-functional data teams to translate business questions into governed metrics, performant models, and self-service visuals.

The analyst designs and builds Power BI reports and dashboards; develops semantic models, reusable DAX measures, and data-shaping pipelines; and supports platform management, security, performance, and refresh reliability. The position also provides user training and documentation, supports reporting requests and strategic analytics initiatives, contributes to BI and data strategy, and helps track Finance data quality and governance KPIs. The role may provide informal mentorship to junior analysts.

Requirements

• 3–6 years of professional experience delivering Power BI solutions, including semantic modeling and end-user reporting.
• Strong command of Power BI Desktop and Service and Microsoft Fabric concepts, including semantic models, workspaces, refresh, and security.
• Advanced experience with SQL Server, T-SQL, or database design.
• Advanced knowledge of DAX and Power Query (M).
• Proven experience with dimensional modeling, including 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, and Data Factory/Synapse as applicable.
• Superior attention to detail and accuracy.
• Positive and professional attitude and strong customer service skills.
• Strong communication skills and 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.
• Bachelor’s degree and 3–5 years of related experience, or high school diploma/GED and 8+ years of related experience.
• Must be legally authorized to work in the U.S. without employment visa sponsorship.

Nice To Haves

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

Responsibilities

• Work and facilitate conversations in a cross-functional, collaborative, team-based environment.
• Design and build intuitive Power BI reports and dashboards for Finance leaders and teams.
• Translate reporting requirements into effective visuals, tooltips, drill paths, and narrative elements that communicate key drivers and exceptions.
• Apply visualization standards, including layout, accessibility, and consistent KPI definitions, and optimize report performance.
• Design, build, and maintain Power BI/Fabric semantic models, including star schemas, relationships, and calculation groups as applicable.
• Engineer reusable DAX measures and KPI definitions; document metric logic and align it with Finance definitions and reporting standards.
• Build and maintain reliable data-shaping pipelines, such as SQL, Power Query, and Dataflows Gen2, and implement 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, including deployment pipelines and version control where available, and contribute improvements to release and validation processes.
• Monitor and improve model and report performance, refresh reliability, and scalability; troubleshoot issues and implement sustainable fixes.
• Implement and maintain appropriate security patterns, access controls, and governance-aligned practices for Finance reporting solutions.
• Work with teams to understand reporting requirements; provide training, documentation, and guidance to help users leverage data; and support ongoing reporting and analytics requests.
• Contribute to long-term BI and data strategy; identify automation opportunities and streamline manual reporting processes.
• Support special analytics projects, data quality initiatives, and modernization efforts, and stay up to date with Power BI features and industry best practices.
• Identify and maintain strong processes for consuming and consolidating large amounts of data into centralized, sustainable, and repeatable measurements.
• Review Finance data consistently and partner with cross-functional teams on corrective actions and long-term solutions when necessary.
• Apply advanced knowledge of Microsoft tools and data operations best practices.
• Track and report Finance data quality and data governance KPIs.
• Provide peer support and knowledge sharing; may informally mentor junior analysts.
• Identify and implement strategic initiatives.
• Perform other duties as assigned.

Benefits

• Medical and prescription drug plans, including no-additional-cost vision coverage, for eligible employees.
• Dental plan.
• 401(k) retirement plan with a 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 work-life resources.
• Tuition reimbursement.
• Adoption assistance.
• Gym membership discount program.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior