Note: The job is a remote job and is open to candidates in USA. Ampacity is seeking a Lead Data Engineer to rebuild and modernize its data platform. The role will lead the design and implementation of a scalable Azure and Databricks lakehouse, set technical direction, and help grow the data team through hiring and mentorship.

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

• 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

Benefits

• 401k
• 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
• Hybrid model: 1–2 days at Georgia Technology Office (or remote)

Company Overview