Sr. Data Engineer/BI Modeler

Must Haves:Strong enterprise Power BI semantic modeling experienceStrong dimensional data modeling skills, including star schemas, fact/dimension design, conformed dimensions, relationships, cardinality, and appropriate data grainStrong SQL skills for data transformation, analysis, validation, and data product developmentStrong hands-on experience with Azure Synapse and/or Microsoft Fabric, ideally exposure to both (can flex on no Fabric experience)Hands-on data engineering experience across data ingestion, transformation, pipelines, and curated analytical datasetsExperience designing and building Lakehouse and/or Warehouse structures supporting analytics and BIStrong DAX and Power Query experienceUnderstanding of data quality, profiling, cleansing, validation, and reconciliationAbility to translate business requirements into scalable technical data solutionsStrong communication skills and ability to work directly with business stakeholders, Data Engineers, Architects, Analysts, and BI teamsNice to Haves:Hands-on Microsoft Fabric experience, particularly Fabric Data Factory/pipelines, Lakehouse, Warehouse, and notebooksExperience migrating or modernizing Azure Synapse workloads into Microsoft FabricPython and/or PySparkDelta/Parquet experienceCI/CD and source control experience for data/analytics solutionsPower BI performance tuning and optimizationExperience with Power BI/Power Platform Centers of ExcellenceFinancial services, automotive finance, lending, claims, or related financial data experienceExperience building Power BI reports/dashboards when neededTeam / Project Overview:The team supports both internal and external data and analytics needs across areas including Sales, Finance, Claims, external data exchange, and dealer-facing reporting. The team currently operates across three pods and is evolving its data platform from Azure Synapse toward Microsoft Fabric.This role sits between traditional BI modeling and Data Engineering. The primary focus is building governed, reusable data products and enterprise semantic models, but the individual will also be expected to work hands-on across the data lifecycle, including ingestion, transformation, pipelines, Lakehouse/Warehouse structures, and data quality. The expectation is approximately 40–50% hands-on data engineering, with the remaining focus primarily on semantic modeling, BI, and data product development.The ideal candidate has successfully worked across both sides of the stack rather than being exclusively a Power BI developer or exclusively a Data Engineer.Responsibilities:Design, develop, and optimize enterprise semantic models and governed data products supporting reporting, analytics, and self-service use casesPartner with business stakeholders to understand requirements and translate them into scalable data and analytics solutionsDesign dimensional models using appropriate facts, dimensions, relationships, granularity, and reusable business logicBuild and optimize Power BI semantic models, DAX measures, and supporting data structuresPerform hands-on data engineering, including ingestion, transformation, pipelines, notebooks, and preparation of data for analytical consumptionCreate curated Lakehouse/Warehouse structures and reusable datasets supporting semantic models and downstream consumersProfile, cleanse, aggregate, normalize, and validate data to ensure trusted and accurate data productsImplement data-quality checks and troubleshoot data anomalies and performance issuesSupport the organization's transition from Azure Synapse toward Microsoft FabricParticipate in deployment, source control, CI/CD, monitoring, and ongoing support of analytics data productsBuild or support Power BI reports and dashboards as needed; dashboard development is not the primary focus of the roleCollaborate across Data Engineering, Architecture, Analytics, BI, and business teams in an Agile delivery environment