Senior Databricks Migration Engineer

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Senior Databricks Migration Engineer based in the United States. This is a senior data engineering role focused on modernizing legacy data platforms and migrating SQL-centric workloads to the Databricks Lakehouse. You will lead the technical transformation of legacy SQL Server stored procedures and Azure Data Factory pipelines into scalable, distributed Lakehouse architectures. The role combines data engineering, cloud architecture, performance optimization, security, governance, and technical leadership. You will design reusable ETL/ELT frameworks and optimize data models and SQL workloads to deliver reliable, high-performance analytics through Power BI. A major focus will be establishing secure, cost-efficient, and well-governed Databricks environments using technologies such as Delta Lake and Unity Catalog. You will also guide internal teams through the migration by leading workshops, pair programming, code reviews, documentation, and knowledge transfer. This opportunity is well suited to an experienced data engineer who can bridge traditional data warehousing practices with modern Spark-based Lakehouse engineering. Accountabilities: As a Senior Databricks Migration Engineer, you will serve as a technical authority for the data platform migration, combining hands-on engineering with architecture, optimization, governance, and team enablement. - Lead the migration of legacy SQL Server stored procedures and Azure Data Factory pipelines to Databricks Lakehouse and Delta Lake. - Translate traditional relational data warehouse architectures into scalable Bronze, Silver, and Gold Lakehouse frameworks. - Design reusable ETL/ELT frameworks using PySpark, Delta Live Tables (DLT), and Databricks Workflows. - Architect and optimize Gold Layer dimensional models and star schemas to maximize Power BI performance. - Optimize Databricks SQL Warehouses for high-concurrency, low-latency Power BI workloads across DirectQuery and Import modes. - Implement advanced Delta Lake optimization techniques, including Z-Ordering, data skipping, liquid clustering, and materialized views.

- Define cluster sizing, auto-scaling, and serverless SQL compute standards to balance performance, reliability, and cost. - Build monitoring dashboards to track Databricks Unit (DBU) consumption and identify opportunities for cost optimization. - Establish effective partitioning strategies and file-size management practices within Delta Lake. - Design and implement data security and governance using Unity Catalog. - Enforce row-level and column-level security for Power BI users and internal analysts. - Align Lakehouse security with Microsoft Entra ID and enterprise RBAC standards. - Lead pair-programming sessions, technical workshops, and code reviews to help teams transition from SQL-centric to Spark-centric development. - Produce comprehensive technical documentation, including architecture diagrams, design patterns, and optimization playbooks. - Establish knowledge-transfer practices that enable internal teams to operate and enhance the platform independently after migration. - Communicate technical concepts effectively to both technical and non-technical audiences. - Manage work in an organized and timely manner while maintaining a strong attention to detail. Requirements The role requires strong data engineering fundamentals, hands-on Databricks and cloud experience, and the ability to lead complex technical initiatives while collaborating effectively across teams. - Bachelor’s degree or higher from an accredited college or university in Computer Science, Engineering, or a related technical field. - 5+ years of experience in data engineering, data system development, or related roles. - 5+ years of experience working with cloud platforms such as Azure, AWS, or GCP.