[Remote] Senior Data Engineer

Note: The job is a remote job and is open to candidates in USA. Ferguson is a Fortune 500 company providing best-in-class products and services across multiple industries. The Senior Data Engineer is responsible for designing and developing complex semantic models and scalable reporting solutions, ensuring that the delivered solutions meet performance, quality, and maintainability standards while providing technical guidance to other developers.ResponsibilitiesDesign and develop complex Power BI semantic models and scalable reporting solutions leveraging curated Databricks Lakehouse layers (Silver/Gold) and enterprise data sourcesWrite advanced SQL (including Databricks SQL) and DAX to implement complex business logic, standardized calculations, and reusable metricsArchitect and maintain shared semantic models and datasets that enable consistent, scalable, and reusable analytics across reporting solutionsApply advanced modeling techniques including calculation groups and complex dimensional structures aligned to Lakehouse-based data designDiagnose and resolve performance issues across Databricks and Power BI, including query optimization, model efficiency, refresh performance, and data volume managementCollaborate with data engineering teams to define and consume curated Gold-layer datasets, ensuring alignment with reporting and analytics requirementsRefactor existing reports and datasets to transition from isolated imports to governed semantic models built on Databricks-backed data productsImplement and enforce dataset governance practices including certification, documentation, lineage awareness, and metric standardizationDevelop and validate data quality checks across Silver and Gold layers, identifying and addressing upstream data issuesDesign and implement automated analytical workflows integrating Power BI, Python, Databricks, and the Power PlatformBuild forecasting, trend analysis, and statistical models supporting advanced and predictive analytics use casesPerform code reviews and provide technical guidance to Associate developers, ensuring adherence to modeling, DAX, and reporting standardsDesign semantic models optimized for AI-drive querying, ensuring datasets include standardized metrics, well defined relationships & rich metadataSkillsBachelor's degree in Computer Science, Information Systems, Data Analytics, or equivalent experienceAdvanced expertise in SQL & DAX3–6 years of Power BI development experienceExperience working with modern data platforms such as Databricks and querying data using Databricks SQLUnderstanding of Lakehouse architecture concepts, including Bronze, Silver, and Gold data layersExperience integrating Databricks data with Power BI semantic models (Import and DirectQuery)Familiarity with distributed data processing concepts and performance considerations for large-scale datasetsExperience using Python or R for predictive analytics & statistical modelingProven ability to design performant & scalable datasetsExperience tuning DAX, model relationships, & refresh performanceStrong ownership mindset for solution quality & stabilityDesign semantic models optimized for AI-drive querying, ensuring datasets include standardized metrics, well defined relationships & rich metadataBenefitsHealth, dental, vision, paid time off, life insurance and a 401(k) with a company matchMental health coverageGender affirming and family building benefitsPaid parental leaveAssociate discountsCommunity involvement opportunitiesBonus or Incentive Plan eligibleCompany OverviewSince 1953, Ferguson has been a leading source of quality supplies for a variety of industries. It was founded in 1953, and is headquartered in Newport News, Virginia, USA, with a workforce of 10001+ employees. Its website is http://www.ferguson.com/.