Senior Data Analyst - Finance

Mortenson • Minneapolis, MN

8d

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 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, DAX measures, KPI definitions, and data-shaping pipelines; and supports Fabric/Power BI workspaces, models, refresh processes, security, governance, and performance. The role also provides user training and documentation, contributes to BI and data strategy, identifies automation opportunities, supports data quality initiatives and special analytics projects, and shares knowledge with peers. Other duties may be assigned.

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 translate business questions into actionable BI solutions.
• 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.
• Bachelor’s degree and 3–5 years of related experience, or high school diploma or GED and 8+ years of related experience.
• Must be legally authorized to work in the United States without employment visa sponsorship.

Nice To Haves

• Agile product delivery and sprint planning experience.
• Knowledge of Python or R for analytics and data transformations.
• Experience using Git or other version control systems.
• Microsoft BI or data engineering certifications.
• Familiarity with Fabric/Azure data services, such as Lakehouse/Warehouse concepts, SQL endpoints, Azure SQL, and Data Factory/Synapse as applicable.

Responsibilities

• Work and facilitate conversations in a cross-functional, collaborative, team-based environment.
• Design and build intuitive Power BI reports and dashboards that support decision-making 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 reporting with Finance definitions and standards.
• Build and maintain reliable data-shaping pipelines, such as SQL, Power Query, and Dataflows Gen2, and implement reconciliations and controls to validate data 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 practices for Finance reporting solutions.
• Work with teams to understand reporting requirements, provide training and documentation, and guide users in leveraging data.
• Serve as a trusted resource for ongoing reporting and analytics requests, demonstrating analytical problem-solving and initiative to learn innovative solutions.
• 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 current with Power BI features and industry best practices.
• Establish and maintain processes to consume and consolidate large amounts of data into centralized, sustainable, repeatable measurements.
• Review Finance data consistently and partner with cross-functional teams on corrective actions and long-term solutions.
• Track and report Finance Data Quality and Data Governance KPIs.
• Provide peer support and knowledge sharing and may informally mentor junior analysts.
• Identify and implement strategic initiatives.
• Perform other duties as assigned.

Benefits

• Medical and prescription drug plans, including vision coverage at no additional cost.
• 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