Mortenson is seeking a Lead Finance BI Developer to build a best-in-class operating model using Microsoft Fabric with a focus on User Experience and Governance, defining, supporting, and managing Finance Data Assets and delivering Self-Service capabilities
Requirements
- 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
- Large scale deployment experience with Microsoft Fabric, including Data Factory, Dataflows and workspace management
- Solid ETL/ELT development background
Responsibilities
- Create dynamic, visually appealing dashboards that support leaders and teams
- Build reports that simplify complex datasets and communicate key insights
- 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
- Administer Finance’s Fabric Data Assets, Power BI Workspaces, 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
Other
- Bachelor’s Degree and minimum of five (5) years related experience; or, high school diploma or GED and 8+ years related experience
- Ability to assess, determine, and delegate priority of multiple customer needs
- Strong communication skills with the ability to present data clearly
- Ability to work, lead, and facilitate conversation in a cross-functional, collaborative, team-based environment
- Must be currently legally authorized to work in the U.S. without sponsorship for employment visa status
