linkedin
Senior Data Analyst - Finance
Mortenson
Minneapolis, KSA
Full Time
Senior
4 weeks ago
Power BIMicrosoft FabricSQLDAXPower QueryData Modeling
Free
Job Fit Check
Base Career helps you apply smarter for this job.
?%
Ready to ScanKey skills for this role
Power BIMicrosoft FabricSQL
About the Role
Mortenson is hiring a Senior Data Analyst - Finance to support finance reporting and analytics by engineering trusted datasets and semantic models in Microsoft Fabric/Power BI. The role involves designing dashboards, building semantic models, and collaborating with finance leaders.
Key Skills for This Role
Power BIMicrosoft FabricSQLDAXPower QueryData Modeling
Responsibilities
- Design and build intuitive Power BI reports and dashboards for Finance leaders and teams
- Design, build, and maintain Power BI/Fabric semantic models (star schemas, relationships, calculation groups)
- Engineer reusable DAX measures and KPI definitions; document metric logic
- Build and maintain reliable data shaping pipelines (e.g., SQL, Power Query, Dataflows Gen2)
- Manage and support Fabric/Power BI workspaces, semantic models, and refresh processes
- Monitor and enhance model/report performance, refresh reliability, and scalability
- Implement and maintain appropriate security patterns (e.g., RLS/OLS) and access controls
- Provide training, documentation, and guidance to help users leverage data
- Contribute to long term BI and Data strategy
- Identify automation opportunities and streamline manual reporting processes
Requirements
- Bachelor’s Degree and 3 5 years related experience; or high school diploma and 8+ years experience
- 3 6 years of professional experience delivering Power BI solutions, including semantic modeling and end user reporting
- Strong command of Power BI (Desktop/Service) and Microsoft Fabric concepts
- 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
- Ability to turn business questions into actionable BI solutions
- Superior attention to detail and accuracy
- Strong communication skills
Full Job Posting
Summary
- 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
- 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
- Apply visualization standards (layout, accessibility, consistent KPI definitions) and optimize report performance
- Design, build, and maintain Power BI/Fabric semantic models (star schemas, relationships, calculation groups as applicable)
- Engineer reusable DAX measures and KPI definitions; document metric logic and ensure alignment to Finance definitions
- Build and maintain reliable data shaping pipelines (e.g., SQL, Power Query, Dataflows Gen2) and implement reconciliations/controls
- 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 aligned practices
- Work closely with teams to understand reporting requirements; provide training, documentation, and guidance
Qualifications
- Bachelor’s Degree and 3 5 years related experience; or, high school diploma or GED and 8+ years related experience
- 3 6 years of professional experience 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 turn business questions into actionable BI solutions
- Familiarity with Fabric/Azure data services (e.g., Lakehouse/Warehouse concepts, SQL endpoints, Azure SQL, Data Factory/Synapse as applicable)
- Superior attention to detail and accuracy
- Proven positive and professional attitude and strong customer service skills
- Strong communication skills with the ability to present data clearly
- Ability to assess, prioritize, and manage multiple stakeholder needs while delivering high quality work on time
Benefits
- 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
- No Cost mental health tool and concierge with extensive work life resources
- Tuition reimbursement
- Adoption Assistance
- Gym Membership Discount Program
Compensation
- The base pay range for this role is $96,400 $144,700.
- Actual range is higher for certain office locations (Denver, CO and Chicago, IL – 5%, Seattle, WA, and Portland, OR – 10%, Washington, D.C. – 12.5%).
- Base pay is positioned within the range based on several factors including an individual’s knowledge, skills, and experience, with consideration given to internal equity.
- This position is eligible for Mortenson’s incentive plan.
Other Items To Note
- Visa sponsorship is not offered for this position.
- Our postings are typically open a minimum of 5 days and an average of 44 days.
- Mortenson reserves the right to hire any individual without legal or financial obligation on unwanted solicitations.
- Must be currently legally authorized to work in the U.S. without sponsorship for employment visa status.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career