Senior Data Engineer

A premier legal services provider is undergoing a massive data modernization effort, transitioning from legacy on-premises systems to cutting-edge cloud architectures. This innovative organization is building a unified Microsoft Fabric Lakehouse ecosystem to rescue a significant data backlog, implement rigorous data governance, and prepare for advanced AI integrations.The Role Lead the transition from legacy on-premises databases to a unified Microsoft Fabric Lakehouse architecture. Take full ownership of replacing fragmented, legacy ETL pipelines with a modern, unified lakehouse ecosystem. Write and execute Python and SQL notebooks to transform, validate, and securely move critical firm data. Design and maintain robust semantic models that power enterprise-level analytics and Power BI dashboards. Mentor junior and mid-level developers, providing architectural guidance and streamlining data requests. Partner with cross-functional stakeholders to ensure data integrity, governance, and readiness for future AI deployments.What You'll Need Extensive background in backend data engineering, including migrating legacy on-premises SQL Server databases to modern cloud architectures. Deep architectural expertise in Microsoft Fabric, including OneLake, Lakehouse, and semantic modeling. Advanced proficiency in building scalable ETL and ELT pipelines using Python, PySpark, and complex SQL queries. Previous experience working within a law firm, court system, or legal technology environment. Ability to work strict EST core hours (9:00 AM to 6:00 PM). Willingness to travel to the Southeast US for strategic planning sessions 2-3 times per year.What's On Offer Opportunity to lead a massive data modernization effort and build a new enterprise ecosystem. Highly competitive compensation package. Comprehensive medical, dental, and vision coverage. Chance to mentor junior developers and set data governance standards for AI integrations.Apply via Haystack today!