Lead Data Engineer, Databricks Lakehouse

ShyftLabs; United States; Remote; USD 140,000 - 200,000; Full time

Benefits offered by this job

Insurance package

Learning & development resources

Job summary

ShyftLabs is seeking a Data Engineer to design and scale ETL/ELT pipelines on the Databricks Lakehouse. You will ingest and export data via REST APIs, build with PySpark and SQL, and implement robust data models using Delta Lake and Medallion Architecture.

You will optimize Spark performance, schedule Databricks Jobs, and collaborate across teams to deliver reliable data solutions for Fortune 500 clients. This is a senior, hands-on role with emphasis on scalability and quality.

Qualifications

• Strong expertise in Python, PySpark, and Advanced SQL.
• Hands-on experience with the Databricks Lakehouse Platform.
• Good understanding of Unity Catalog, Delta Lake, Databricks Workflows/Jobs, Clusters, Notebooks, Repos, and Medallion Architecture.
• Experience integrating with REST APIs for data ingestion and data export.
• Strong knowledge of ETL/ELT development, batch processing, incremental loading, and data transformation.
• Experience with data modeling (Star Schema, Snowflake Schema, Fact & Dimension tables, SCD concepts).
• Understanding of data warehousing concepts and best practices.
• Experience working with structured and semi-structured data (CSV, JSON, Parquet, Delta).
• Knowledge of partitioning, file optimization, Spark performance tuning, and query optimization.
• Experience with Git and CI/CD best practices

Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines using Databricks, PySpark, and SQL.
• Integrate data from multiple sources, including databases, S3, files, and REST APIs.
• Build data pipelines with Databricks Unity Catalog.
• Implement business logic, data transformations, and dimensional models.
• Create, schedule, monitor, and optimize Databricks Jobs and Workflows.
• Design and manage Delta Lake tables using Medallion Architecture (Bronze, Silver, Gold).
• Ensure data quality through validations, error handling, logging, and monitoring.
• Optimize Spark workloads for performance, scalability, and reliability.
• Collaborate with cross-functional teams to deliver production-ready data solutions.

Skills

Python

PySpark

SQL

Databricks

REST API integration

ETL/ELT

Data modeling

Data warehousing

Git & CI/CD

Spark performance tuning

Tools

Databricks

Apache Spark

SQL

Git

Airflow

Kafka

dbt

Unity Catalog

Delta Lake

Job description

ShyftLabs is seeking a Data Engineer to design and scale ETL/ELT pipelines on the Databricks Lakehouse. You will ingest and export data via REST APIs, build with PySpark and SQL, and implement robust data models using Delta Lake and Medallion Architecture.

You will optimize Spark performance, schedule Databricks Jobs, and collaborate across teams to deliver reliable data solutions for Fortune 500 clients. This is a senior, hands-on role with emphasis on scalability and quality.