Data Analyst - Finance

Mortenson is currently seeking a Data Analyst - Finance who will be responsible for supporting Finance reporting and analytics by building and maintaining Power BI reporting solutions and data processes that enable timely, accurate, business-ready insights. This role partners with Finance stakeholders and data teams to translate questions into well-defined metrics, reliable datasets, and intuitive dashboards. Work is primarily within Power BI, SQL, and the Power Platform, with exposure to finance and construction/project systems (e.g., Oracle Fusion, FDI) as applicable. VISA SPONSORSHIP IS NOT AVAILABLE FOR THIS POSITION RESPONSIBILITIES Ability to work and facilitate conversation in a cross-functional, collaborative, team-based environment Report Development & Data Visualization Design, build and enhance Power BI reports and dashboards that enable decision-making for Finance leaders and teams Support in-app Operational Report development (Oracle Fusion, OTBI, FDI), as needed Translate requirements into effective visuals, tooltips, drill paths, and narrative elements that communicate key drivers and exceptions Apply visualization and support performance improvements Maintain reports through updates, validation, and user feedback SQL & Data Preparation Write and maintain SQL queries to support reporting and analytics Perform data validation and reconciliation to ensure accuracy Partner with stakeholders to understand data sources and definitions Platform Management & Optimization Support existing datasets and reporting models Develop DAX measures and transformations Ensure alignment with Finance definitions and standards Collaborate on Data Governance Initiatives and End User trainings Collaboration & Support Work with teams to gather requirements and deliver reporting solutions Provide user support and documentation Assist with ongoing analytics requests Advanced knowledge of Microsoft Toolset, Finance Report Toolsets, best practices and general Data Operations best practices Identify and implement strategic initiatives. All other duties as assigned QUALIFICATIONS Bachelor's degree in Finance, Accounting, Mathematics, Data/Analytics, or related field 3 years of experience in analytics, finance, or reporting Strong working knowledge of Power BI Working knowledge of SQL Familiarity with Power Query and basic DAX Familiarity of other Operating Systems Reporting Tools (Oracle, Procore, UKG, etc) Strong attention to detail and communication skills (Nice to have) Experience with Power Platform tools (Power Automate, Power Apps) (Nice to have) Exposure to Oracle, Procore, or similar systems (Nice to have) Construction industry 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 $72,900 - $109,400. (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. This position is eligible for Mortenson's incentive plan. #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 Equal Employment Opportunity 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. #J-18808-Ljbffr