Lead Data Engineer – Azure Databricks Lakehouse

Quanta Services, Inc.; Atlanta (GA); Hybrid; USD 120,000 - 130,000; Full time

Benefits offered by this job

Medical, dental, vision coverage

401k

Wellness resources

Growth opportunities

Job summary

Ampacity is seeking a Lead Data Engineer to lead the rebuild of our data platform using Azure and Databricks to support reporting, analytics, and growth. This hands-on role reports to the Senior Director of Technology and will help hire and mentor the data team as it expands.

Pay range is $120,000–$130,000 with a hybrid work model requiring 1-2 days at the Georgia Technology Office in Georgia.

Qualifications

• 5+ years hands-on data engineering experience.
• Experience designing pipelines in Azure Data Factory.
• Experience with Databricks, Delta Lake, Unity Catalog, and medallion architecture.
• Strong SQL and Python skills.
• Experience with modern lakehouse architecture and ETL tooling.
• Experience leading projects and mentoring engineers.
• Familiarity with Git-based version control.
• Experience with ERP systems such as NetSuite, SAP, Oracle, or Microsoft Dynamics.
• Power BI, CI/CD, and managed ingestion tools a plus.

Responsibilities

• Lead the rebuild of Ampacity’s data platform from design through implementation.
• Stabilize and maintain Azure Data Factory pipelines and migrate to the Databricks lakehouse.
• Develop a Databricks lakehouse using Delta Lake, Unity Catalog, and bronze/silver/gold architecture.
• Design data models that 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 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.
• Take on additional responsibilities as the role evolves and new learning opportunities arise.

Skills

Azure Data Factory

Databricks

Delta Lake

Unity Catalog

SQL

Python

Data modeling

ETL pipelines

Git

CI/CD

Power BI

ERP systems

Communication

Tools

Fivetran

Estuary

Airbyte

NetSuite

Job description

Ampacity is seeking a Lead Data Engineer to lead the rebuild of our data platform using Azure and Databricks to support reporting, analytics, and growth. This hands-on role reports to the Senior Director of Technology and will help hire and mentor the data team as it expands.

Pay range is $120,000–$130,000 with a hybrid work model requiring 1-2 days at the Georgia Technology Office in Georgia.