Senior Data Analyst - Finance

Job-ID: 24307Category: Data AnalyticsLocation: Minneapolis, MN, United StatesSchedule: Full timePosted: 2026-10-27SUMMARY Mortenson is currently seeking a Senior Data Analyst - Finance that supports 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.RESPONSIBILITIESAbility to work and facilitate conversation in a cross-functional, collaborative, team-based environmentVisualization & Report Development (Power BI)Design and build intuitive Power BI reports and dashboards that enable decision-making for Finance leaders and teamsTranslate requirements into effective visuals, tooltips, drill paths, and narrative elements that communicate key drivers and exceptionsApply 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 reportingEngineer reusable DAX measures and KPI definitions; document metric logic and ensure alignment to Finance definitions and reporting standardsBuild and maintain reliable data shaping pipelines (e.g., SQL, Power Query, Dataflows Gen2) and implement reconciliations/controls to validate completeness and accuracyPlatform Management & OptimizationManage and support Fabric/Power BI workspaces, semantic models, and refresh processes in coordination with BI platform administratorsUse established CI/CD practices (deployment pipelines, version control where available); contribute improvements to release and validation processesMonitor and enhance model/report performance, refresh reliability, and scalability; troubleshoot issues and implement sustainable fixesImplement and maintain appropriate security patterns (e.g., RLS/OLS), access controls, and governance aligned practices for Finance reporting solutionsCollaboration & SupportWork closely with teams to understand reporting requirementsProvide training, documentation, and guidance to help users leverage dataAct as a trusted resource for ongoing reporting and analytics requestsDisplays advanced analytical and problem-solving skills with initiative to seek and continue to learn innovative solutionsStrategic InitiativesContribute to long term BI and Data strategyIdentify automation opportunities and streamline manual reporting processesSupport special analytics projects, data quality initiatives, and modernization effortsStay up to date with Power BI features and industry best practicesIdentify and maintain strong processes to consume and consolidate large amounts of data into centralized, sustainable, and repeatable measurementsReview finance data consistently and partner with cross functional teams to provide corrective action and long-term solutions when necessaryAdvanced knowledge of Microsoft Toolset, best practices and general Data Operations best practicesTrack and report Data Quality and Data Governance KPIs for FinanceProvide peer support and knowledge sharing; may mentor junior analysts informallyIdentify and implement strategic initiatives.All other duties as assignedQUALIFICATIONS3-6 years of professional experience delivering Power BI solutions, including semantic modeling and end-user reportingStrong command of Power BI (Desktop/Service) and Microsoft Fabric concepts (semantic models, workspaces, refresh, security)Advanced Experience with SQL Server, T-SQL, or database designAdvanced knowledge of DAX and Power Query (M)Proven experience with dimensional modeling (star schemas), semantic model design, and performance tuning for self-service analyticsAbility to turn business questions into actionable BI solutionsFamiliarity with Fabric/Azure data services (e.g., Lakehouse/Warehouse concepts, SQL endpoints, Azure SQL, Data Factory/Synapse as applicable)Superior attention to detail and accuracyProven positive and professional attitude and strong customer service skillsStrong communication skills with the ability to present data clearlyAbility to assess, prioritize, and manage multiple stakeholder needs while delivering high-quality work on timeAgile Product delivery, Sprint Planning Experience(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 CertificationsBachelor’s Degree and 3-5 years related experience; or, high school diploma or GED and 8+ years related experienceA few benefits offered include: (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 matchPaid 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 resourcesTuition reimbursement Adoption Assistance Gym Membership Discount Program The base pay range for this role is $96,400 - $144,700. (Actual range is higher for the following 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. #LI-BS1Please make 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. ABOUT MORTENSONAs a top builder, developer, and EPC (Engineering, Procurement, and Construction), our expertise spans markets like sports, renewable energy, data centers, healthcare, and more. We are builders at heart, working to ensure the built environment has a lasting positive impact. Let’s Redefine Possible Equal Employment OpportunityYour uniqueness brings new and creative perspectives to the team. Mortenson is committed to providing equal opportunities of employment (EOE) to all individuals, regardless of your race, religion, gender, national origin, age, veteran status, disability, marital status or any other legally protected category.Other Items to NoteMortenson reserves the right to hire any individual without legal or financial obligation on unwanted solicitations. No agency emails, calls, or solicitations are accepted without a valid agreement.Must be currently legally authorized to work in the U.S. without sponsorship for employment visa status (e.g., H1B status, 0-1, TN, CPT, OPT, etc.). We are unable to sponsor or take over sponsorship of an employment Visa at this time.