Lead Data Engineer - Azure Databricks Lakehouse (Hybrid)

Ampacity; Atlanta (GA); Hybrid; USD 120,000 - 130,000; Full time

Benefits offered by this job

401k

Medical/Dental/Vision

Paid time off

Wellness resources

Growth opportunities

Job summary

Ampacity is seeking a Lead Data Engineer to lead the rebuild and modernization of our data platform. This hands-on role will design and implement a scalable Azure and Databricks-based lakehouse that supports reporting, analytics, and business growth.

Reporting to the Senior Director of Technology, this person will own the platform’s technical direction and help hire and mentor future data team members as the function grows.

Pay Range: $120,000 - $130,000

Qualifications

• 5+ years of hands-on data engineering experience.
• Strong experience designing pipelines in Azure Data Factory.
• Experience with Databricks, Delta Lake, Unity Catalog, and medallion architecture.
• Strong SQL skills and Python or another scripting language.
• Experience with modern lakehouse migrations from ADF/ETL tools.
• Experience with Git-based version control for data pipelines.
• Experience leading projects and mentoring junior engineers.
• Excellent communication and problem-solving skills.

Responsibilities

• Lead the rebuild of Ampacity’s data platform from design through implementation.
• Stabilize and maintain existing Azure Data Factory pipelines while leading their migration into the new Databricks lakehouse.
• Develop a Databricks lakehouse using Delta Lake, Unity Catalog, and bronze/silver/gold architecture.
• Design data models that accurately track changes over time.
• Build data transformation and integration logic using SQL and Python.
• Set standards for version control, testing, documentation, and deployments.
• Partner with business and technology teams to understand their data needs.
• Monitor data quality and troubleshoot pipeline or performance issues.
• Lead technical projects and mentor junior engineers.
• Help hire and develop future data team members as the function grows.
• Take on additional responsibilities as the role evolves and new learning and growth opportunities come up.

Skills

Azure Data Factory

Databricks

Delta Lake

Unity Catalog

SQL

Python

Data modeling

ETL pipelines

Git version control

Leadership

Communication

Tools

Fivetran

Estuary

Airbyte

NetSuite

Power BI

Job description

Ampacity is seeking a Lead Data Engineer to lead the rebuild and modernization of our data platform. This hands-on role will design and implement a scalable Azure and Databricks-based lakehouse that supports reporting, analytics, and business growth.

Reporting to the Senior Director of Technology, this person will own the platform’s technical direction and help hire and mentor future data team members as the function grows.

Pay Range: $120,000 - $130,000