DescriptionSUMMARY
Mortenson is currently seeking a Senior Data Analyst - Finance that will support Finance reporting and analytics by engineering trusted, reusable datasets and semantic models in Microsoft Fabric/Power BI and delivering intuitive, business-ready reporting experiences. This 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.
RESPONSIBILITIES
- Ability to work and facilitate conversation in a cross-functional, collaborative, team-based environment
-
Visualization & Report Development (Power BI)
- Design and build intuitive Power BI reports and dashboards that enable decision-making for Finance leaders and teams
- Translate requirements into effective visuals, tooltips, drill paths, and narrative elements that communicate key drivers and exceptions
- Apply visualization standards (layout, accessibility, consistent KPI definitions) and optimize report performance (model usage, interactions, visuals)
-
Analytics Engineering (Semantic Modeling & Data Shaping)
- Design, build, and maintain Power BI/Fabric semantic models (star schemas, relationships, calculation groups as applicable) that enable consistent, trusted reporting
- Engineer reusable DAX measures and KPI definitions; document metric logic and ensure alignment to Finance definitions and reporting standards
- Build and maintain reliable data shaping pipelines (e.g., SQL, Power Query, Dataflows Gen2) and implement reconciliations/controls to validate completeness and accuracy
-
Platform Management & Optimization
- Manage and support Fabric/Power BI workspaces, semantic models, and refresh processes in coordination with BI platform administrators
- Use established CI/CD practices (deployment pipelines, version control where available); contribute improvements to release and validation processes
- Monitor and enhance model/report performance, refresh reliability, and scalability; troubleshoot issues and implement sustainable fixes
- Implement and maintain appropriate security patterns (e.g., RLS/OLS), access controls, and governance-