Data & BI Analyst jobs

Senior Data Analyst - Finance

MortensonMinneapolis, MNPosted 26 days ago

$96k–$145k/yr listed by the employer

Key facts

Schedule
25+ hours a week
Experience
3+ years
Degree
Bachelor's degree
US visa
No US visa sponsorship

Strong: looks real and checked open today.

On Mortenson’s own careers site (Oracle Recruiting).

  • Checked: On the company's own careers siteOracle Recruiting board
  • Checked: Checked open todayOracle Recruiting board
  • Checked: Pay listedJob posting
  • Checked: No reposts foundOracle Recruiting board
  • Trust score 100 / 100 · Strong
See all 5 checksShow fewer
How we check

What you’ll do

  • Design and build Power BI reports, dashboards, semantic models, reusable DAX measures, and Finance KPI definitions.
  • Build and maintain data-shaping pipelines, reconciliations, and controls to validate data completeness and accuracy.
  • Manage and optimize Fabric/Power BI workspaces, refresh processes, security, model performance, and release practices.
  • Partner with Finance and cross-functional teams to clarify reporting needs, resolve data issues, and deliver governed metrics and self-service analytics.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Licenses and certifications

  • Microsoft BI or data engineering certifications (preferred)

Experience

  • 3–6 years of professional experience delivering Power BI solutions, including semantic modeling and end-user reporting
  • Proven experience with dimensional modeling (star schemas), semantic model design, and performance tuning for self-service analytics
  • Agile product delivery and sprint planning experience
  • Experience using Git or other version control systems (preferred)

Education

  • Bachelor’s degree and 3–5 years of related experience, or high school diploma/GED and 8+ years of related experience

Skills

  • Strong command of Power BI Desktop/Service and Microsoft Fabric concepts, including semantic models, workspaces, refresh, and security
  • Advanced experience with SQL Server, T-SQL, or database design
  • Advanced knowledge of DAX and Power Query (M)
  • Familiarity with Fabric/Azure data services, such as Lakehouse/Warehouse concepts, SQL endpoints, Azure SQL, and Data Factory/Synapse
  • Ability to turn business questions into actionable BI solutions
  • Knowledge of Python or R for analytics and data transformations (preferred)

Other requirements

  • Currently legally authorized to work in the U.S. without employment visa sponsorship
  • Ability to assess, prioritize, and manage multiple stakeholder needs while delivering high-quality work on time
  • Positive, professional attitude and strong customer service skills

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Benefits

Health insurance
Medical and prescription drug plans
Dental & vision
Vision coverage at no additional cost; dental plan
Retirement plan
401(k) retirement plan with a Mortenson match
Paid time off
Paid time off, holidays, and other paid leaves
Learning & tuition
Tuition reimbursement
Wellness & mental health
No-cost mental health tool and concierge with work-life resources, Gym membership discount program
Life & disability insurance
Employer-paid life, AD&D, and disability insurance
Family & fertility support
Adoption assistance

Full job description

From Mortenson’s careers site

SUMMARY

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.

RESPONSIBILITIES

  • Ability to work and facilitate conversation in a cross-functional, collaborative, team-based environment
  • Visualization & Report Development (Power BI)
Show full descriptionShow less
  • 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 aligned practices for Finance reporting solutions
  • 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 continue to learn 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 Power BI features and industry best practices
  • Identify and maintain strong processes to consume and consolidate large amounts of data into centralized, sustainable, and repeatable measurements
  • Review finance data consistently and partner with cross functional teams to provide corrective action and long-term solutions when necessary
  • Advanced knowledge of Microsoft Toolset, best practices and general Data Operations best practices
  • Track and report Data Quality and Data Governance KPIs for Finance
  • Provide peer support and knowledge sharing; may mentor junior analysts informally
  • Identify and implement strategic initiatives.
  • All other duties as assigned

QUALIFICATIONS

  • 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
  • Agile 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 Certifications
  • Bachelor’s Degree and 3-5 years related experience; or, high school diploma or GED and 8+ years related experience

A 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 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

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-BS1

Please 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 MORTENSON

As 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®

Your 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 Note

  • Mortenson 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.

Equal Employment Opportunity

Something wrong with this job? Report it

Similar jobs nearby

Data Analyst

RVO Health · Charlotte, NC +2 places

$70k–$95k/yrHybrid

StrongChecked open todayPosted 26 days ago

Data Analyst

Inspire11 · Dallas, TX +1 place

$10,000/moOn-site

Looks goodOpen 8 monthsChecked open todayPosted 8 months ago

Data & BI Specialist

Amplifon · Minneapolis, MN

$80k–$100k/yrFull-timeHybrid

StrongOpen 4 monthsChecked open todayPosted 4 months ago

See more like this