Lead Data Engineer — Azure Databricks Lakehouse (Hybrid)

Summit Line Construction; Atlanta (GA); Hybrid; USD 120,000 - 130,000; Full time

Benefits offered by this job

Competitive pay and 401k

Vacation, sick days, holidays, and par

Medical, dental, and vision coverage

Wellness resources

Growth and internal advancement

Job summary

Ampacity, a Quanta Services company, seeks a Lead Data Engineer to rebuild and modernize our data platform. You will design and implement a scalable Azure and Databricks-based lakehouse to support reporting, analytics, and business growth.

Reporting to the Senior Director of Technology, you will own the platform’s direction and mentor future data engineers. The role is hybrid (1–2 days at the Georgia Technology Office) with a pay range of $120,000–$130,000.

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 skills and Python or another scripting language.
• Solid understanding of data modeling and historical data tracking.
• Experience building or moving to a modern lakehouse from ADF, SSIS, Informatica, or a similar ETL tool.
• Experience using Git-based version control for data pipelines or ETL code.
• Experience leading projects and helping junior engineers grow.
• Strong communication and problem-solving skills.
• Experience with ERP systems is a plus (NetSuite preferred; SAP/Oracle/MS Dynamics also helpful).
• Experience with Power BI, CI/CD, modern data transformation tools, or managed ingestion tools (Fivetran, Estuary, Airbyte) is a plus.
• Experience leading a greenfield build or major data platform rebuild is strongly preferred.

Responsibilities

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

Skills

Azure Data Factory

Databricks

Delta Lake

SQL

Python

Data modeling

Git version control

Project leadership

Communication

Mentoring

Tools

Databricks

Delta Lake

Unity Catalog

Power BI

Git

CI/CD

Fivetran/Estuary/Airbyte

Job description

Ampacity, a Quanta Services company, seeks a Lead Data Engineer to rebuild and modernize our data platform. You will design and implement a scalable Azure and Databricks-based lakehouse to support reporting, analytics, and business growth.

Reporting to the Senior Director of Technology, you will own the platform’s direction and mentor future data engineers. The role is hybrid (1–2 days at the Georgia Technology Office) with a pay range of $120,000–$130,000.