Data Solutions Senior EngineerData Solutions Senior Engineer

Summary Mortenson is currently seeking a hands‑on Senior Engineer – Data Solutions responsible for designing, building, and optimizing enterprise‑scale, domain‑aligned data products and pipelines in Microsoft Fabric using Medallion architecture. The role focuses on implementing Bronze → Silver → Gold data solutions, ensuring performance, scalability, and adherence to enterprise data standards. This is a fully hands‑on individual contributor role focused on design, development, and optimization of data solutions rather than people or project management. Responsibilities Design and build complex data pipelines across multiple domains using Medallion architecture. Implement Data Mesh aligned data products for domain‑based consumption. Implementing repeatable Data Mesh ingestion, transformation, and Bronze à Silver à Gold‑layer delivery patterns. Apply cross‑domain standards for data quality, metadata, lineage, and governance with assigned solutions. Contribute expertise in Data Mesh principles and Medallion architecture to ensure consistent implementation. Apply enterprise standards for data product ownership, documentation, quality, and observability. Optimize Bronze/Silver/Gold pipelines for performance and cost efficiency. Implement integration of non‑Fabric and transitional data sources. Collaborate with stakeholders, data stewards, and data owners to deliver high‑quality Gold‑layer datasets. Apply governance, security, and compliance requirements across all solutions. Qualifications Bachelor’s degree in business or computer science or equivalent combination of education, experience and area of expertise. 5+ years in platform/data engineering with enterprise experience. Advanced expertise in Microsoft Fabric, Medallion architecture, and Data Mesh principles. Strong experience in ETL/ELT tools (ADF, SSIS, Fivetran), SQL, and data modeling. Proven experience delivering complex cross‑domain data engineering solutions in Medallion and Data Mesh environments. Experience with hybrid source systems (on‑prem/cloud/SaaS). Experience with OneLake or enterprise data lake architecture. Experience with enterprise semantic models (SSAS, Tabular, or OLAP). Advanced Power BI, DAX, and Power Query expertise. Experience with Power Automate and Power Apps. Agile/Scrum experience working in cross‑domain data platforms teams. A Few Benefits Offered Medical and prescription drug plans that include no additional cost vision coverage. Dental plan. 401(k) 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. Base pay range: $114,500 – $171,800. (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 an individual’s knowledge, skills, and experience, with consideration given to internal equity. This position is eligible for Mortenson’s incentive plan. Visa sponsorship is not offered for this position. Equal Employment Opportunity Your uniqueness brings new and creative perspectives to the team. Mortenson is committed to providing equal opportunities for 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. #J-18808-Ljbffr