Senior Data Analyst - Finance

Responsibilities

• Facilitate cross-functional conversations in a collaborative, team-based setting to capture reporting needs.
• Design and develop intuitive Power BI reports and dashboards that empower Finance leadership and teams to make informed decisions.
• Translate requirements into effective visuals, tooltips, drill paths, and narrative elements that highlight key drivers and exceptions.
• Apply visualization standards for layout and KPI definitions, and optimize report performance through model usage and visuals tuning.
• Design, build, and maintain Fabric/Power BI semantic models (star schemas, relationships, calculation groups) to enable consistent, trusted reporting.
• Engineer reusable DAX measures and KPI definitions; document metric logic to align with Finance definitions and standards.
• Develop reliable data shaping pipelines (SQL, Power Query, Dataflows Gen2) with reconciliations to validate completeness and accuracy.
• Manage Fabric/Power BI workspaces, semantic models, and refresh processes in coordination with BI platform administrators.
• Adopt CI/CD practices, contribute to release and validation processes, and pursue improvements to deployment workflows.
• Monitor model and report performance, refresh reliability, and scalability; troubleshoot issues with durable, sustainable fixes.
• Implement security patterns (RLS/OLS), access controls, and governance-aligned practices for Finance reporting solutions.
• Collaborate with stakeholders to understand reporting requirements and provide training, documentation, and guidance.
• Serve as a trusted resource for ongoing reporting and analytics requests, applying advanced analysis and problem-solving skills.
• Contribute to long-term BI and data strategy; identify automation opportunities and support modernization efforts.
• Maintain processes to consolidate large data volumes into centralized, repeatable measurements; review finance data and propose corrective actions as needed.
• Stay current with Microsoft tooling and data operations best practices; track Data Quality and Data Governance KPIs for Finance.
• Provide peer support and informal mentoring; identify and pursue strategic initiatives.

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).
• Excellent attention to detail with a professional, customer-service oriented mindset.
• Strong communication skills and the ability to present data clearly.
• Ability to assess, prioritize, and manage multiple stakeholder needs while delivering high-quality work on time.
• Experience with Agile product delivery and sprint planning.
• Nice-to-have: knowledge of Python or R for analytics and data transformations.
• Nice-to-have: experience using Git or other version control systems.
• 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
• 401(k) 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 resources and work-life concierge services
• Tuition reimbursement
• Adoption assistance
• Gym membership discount program

Compensation

Salary range: USD 96,400 - 144,700 per year.

Other items to note

• Mortenson reserves the right to hire any individual without reliance on solicitations; no agency emails, calls, or solicitations are accepted without a valid agreement.
• Candidates must be legally authorized to work in the United States without sponsorship for employment visa status at this time.