Lead Finance BI Developer

Summary

Mortenson is currently seeking a Lead Finance BI Developer that will be responsible for Finance’s Reporting BI COE and building a best‑class operating model using Microsoft Fabric with a focus on User Experience and Governance. This position plays a pivotal role in defining, supporting, and managing Finance Data Assets and delivering Self‑Service capabilities / This role will also partake in the broader enterprise Data Strategy and Governance efforts across the Company.

• Ability to work, lead, and facilitate conversation in a cross‑functional, collaborative, team‑based environment
• Dashboard & Report Development
  • Create dynamic, visually appealing dashboards that support leaders and teams
  • Build reports that simplify complex datasets and communicate key insights
  • Maintain design consistency and establish visualization best practices
• Data Modeling & ETL
  • Create and manage data pipelines using Fabric Data Factory, Dataflows Gen2 or other Fabric‑native tools.
  • Develop reusable DAX measures and calculations to support analytical needs
  • Ensure ETL/ELT process deliver timely, accurate and reliable data
• Platform Management & Optimization
  • Administer Finance’s Fabric Data Assets, Power BI Work spaces, refresh schedules and artifacts
  • Support deployment pipelines and CI/CD workflows for dashboards
  • Collaborate with IT and architecture teams to optimize Fabric capacity and overall system performance.
  • Enforce security, compliance, and governance policies
• Collaboration & Support
  • Work closely with teams to understand reporting requirements
  • Provide training, documentation, and guidance to help users leverage data
  • Act as a trusted resource for ongoing reporting and analytics requests
  • Displays advanced analytical and problem‑solving skills with initiative to seek and recommend innovative solutions
• Strategic Initiatives
  • 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
  • Stay up to date with Fabric and Power BI features and industry best practices
• Identify needs and develop processes to consume and consolidate large amounts of data into centralized, sustainable, and repeatable measurements
• Expert knowledge of Microsoft Toolset, best practices and General Data Operations best practices
• Develop and manage Data Quality and Data Governance KPIs for Finance
• Provide leadership, coaching, mentoring for other BI and Data Analysts
• Support business adoption of self‑service analytics by creating documentation, templates and best practices.
• All other duties as assigned

• Bachelor’s Degree and minimum of five (5) years related experience; or, high school diploma or GED and 8+ years related experience
• 5+ Years of professional experience developing reports and dashboards in Power BI
• Strong Command of Power BI Desktop, Power BI Service and related Access and Security (RLS/OLS)
• Advanced Experience with SQL Server, T‑SQL, or database design
• Advanced knowledge of DAX and Power Query (M)
• Proven experience designing data models that are scalable, high performing and designed for self‑service
• Ability to turn business questions into actionable BI solutions
• Large scale deployment experience with Microsoft Fabric, including Data Factory, Dataflows and workspace management
• Solid ETL/ELT development background
• Proven positive and professional attitude and strong customer service skills
• Strong communication skills with the ability to present data clearly
• Ability to assess, determine, and delegate priority of multiple customer needs
• Agile Product delivery, Sprint Planning Experience
• Knowledge of Python or R for analytics and data transformations preferable
• Experience using Git or other version control systems preferable
• Microsoft BI or data engineering Certifications preferable

(for Non‑Craft & Non‑Union Craft working 25+ hours / week)

• Medical and prescription drug plans that includes 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
• N…