Lead Data Engineer

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

About Us

A proud member of the Quanta Services family of companies, Ampacity, LLC (Ampacity) delivers a forward-thinking approach to structural and electrical solutions for clean energy transition projects. From design, kitting, and installation to comprehensive electrical procurement, Ampacity specializes in expert-engineered, field-ready solutions that accelerate project timelines and maximize impact. Made up of more than 350 passionate professionals committed to simplifying complexity across the energy value chain, Ampacity empowers customers to build smarter, faster, and more efficiently - with the most reliable technology in the industry. Headquartered in California, Ampacity maintains facilities in Mississippi, Kentucky, and Iowa, with offices in Florida, Georgia, and Vermont. Since 2014, Ampacity has delivered nearly eight gigawatts of fully engineered clean energy systems across North America.

About this Role

Ampacity is looking for 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,000Hybrid Model: 1-2 days at Georgia Technology Office

What You'll Do

• 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

What You'll Bring

• 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 experience with Python or another scripting language

• A solid understanding of data modeling and historical data tracking - able to design data pipelines that accurately reflect how data changes over time

• 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

• The ability to work independently and as part of a small team

• Strong communication and problem-solving skills

• Experience with ERP systems is a plus - NetSuite is preferred, but SAP, Oracle, or Microsoft Dynamics experience is also helpful

• Experience with Power BI, CI/CD, modern data transformation tools, or managed ingestion tools such as Fivetran, Estuary, or Airbyte is a plus

• Experience leading a greenfield build or major data platform rebuild is strongly preferred

What You'll Get

• Competitive pay and 401k - because your work should be rewarded fairly
• Time off you'll actually use: vacation, sick days, holidays, parental, and bereavement leave
• Full medical, dental, and vision coverage, plus extra support when you need it
• Wellness resources to help you show up as your best self, at work and at home
• Real room to grow - we promote from within and invest in your development

Equal Opportunity Employer

All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, national origin or ancestry, sex (including gender, pregnancy, sexual orientation, and/or gender identity), age, disability, genetic information, veteran status, and/or any other basis protected by applicable federal, state or local law.We are an Equal Opportunity Employer, including disability and protected veteran status. We prohibit all types of discrimination and are committed to providing access and equal opportunity for individuals with disabilities. For additional information or if reasonable accommodation is needed to participate in the job application, interview, or hiring processes or to perform the essential functions of a position, please contact us the Company’s Human Resources department.