Apply on Employer Site

Mortenson · 2 weeks ago

Lead Finance BI Developer

700 Meadow Lane N, Minneapolis, MN, 55422, US

Full-time

Onsite

Senior Level, Lead/Staff

$85K/yr - $128K/yr

5+ years exp

Mortenson is currently seeking a Lead Finance BI Developer that will be responsible for Finance’s Reporting BI COE and building a best-in-class operating model using Microsoft Fabric with a focus on User Experience and Governance. This position plays a pivotal role in defining, supporting, and managing Finance Data Assets and delivering Self-Service capabilities.

Commercial Real EstateConstructionReal Estate

Growth Opportunities

No H1B

U.S. Citizen Only

Responsibilities

Ability to work, lead, and facilitate conversation in a cross-functional, collaborative, team-based environment

Dashboard & Report Development

Create dynamic, visually appealing dashboards that support leaders and teams

Build reports that simplify complex datasets and communicate key insights

Maintain design consistency and establish visualization best practices

Data Modeling & ETL

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

Ensure ETL/ELT process deliver timely, accurate and reliable data

Platform Management & Optimization

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

Enforce security, compliance, and governance policies

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 recommend 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 Fabric and Power BI features and industry best practices

Identify needs and develop processes to consume and consolidate large amounts of data into centralized, sustainable, and repeatable measurements

Expert knowledge of Microsoft Toolset, best practices and General Data Operations best practices

Develop and manage Data Quality and Data Governance KPIs for Finance

Provide leadership, coaching, mentoring for other BI and Data Analysts

Support business adoption of self-service analytics by creating documentation, templates and best practices

All other duties as assigned

Qualification

Power BIMicrosoft FabricSQL ServerDAXETL/ELT DevelopmentData ModelingAgile Product DeliveryPythonRGitCustomer ServiceCommunication Skills

Required

Bachelor's Degree and minimum of five (5) years related experience; or, high school diploma or GED and 8+ years related experience

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

Ability to turn business questions into actionable BI solutions

Large scale deployment experience with Microsoft Fabric, including Data Factory, Dataflows and workspace management

Solid ETL/ELT development background

Proven positive and professional attitude and strong customer service skills

Strong communication skills with the ability to present data clearly

Ability to assess, determine, and delegate priority of multiple customer needs

Agile Product delivery, Sprint Planning Experience

Preferred

Knowledge of Python or R for analytics and data transformations preferable

Experience using Git or other version control systems preferable

Microsoft BI or data engineering Certifications preferable

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

Company

Mortenson

Glassdoor4.4

Mortenson is a U.S.-based, top-25 builder, developer and provider of energy and engineering services committed to helping organizations move their strategies forward.

Founded in 1954

Minneapolis, Minnesota, USA

5001-10000 employees