Lead Data Engineer

Lead Data EngineerAmpacity 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,000 Hybrid Model: 1-2 days at Georgia Technology OfficeWhat You'll DoLead the rebuild of Ampacity's data platform from design through implementationStabilize and maintain existing Azure Data Factory pipelines while leading their migration into the new Databricks lakehouseDevelop a Databricks lakehouse using Delta Lake, Unity Catalog, and bronze/silver/gold architectureDesign data models that accurately track changes over timeBuild data transformation and integration logic using SQL and PythonSet standards for version control, testing, documentation, and deploymentsPartner with business and technology teams to understand their data needsMonitor data quality and troubleshoot pipeline or performance issuesLead technical projects and mentor junior engineersHelp hire and develop future data team members as the function growsTake on additional responsibilities as the role evolves and new learning and growth opportunities come upWhat You'll Bring5+ years of hands-on data engineering experienceStrong experience designing pipelines in Azure Data FactoryExperience with Databricks, Delta Lake, Unity Catalog, and medallion architectureStrong SQL skills and experience with Python or another scripting languageA solid understanding of data modeling and historical data tracking — able to design data pipelines that accurately reflect how data changes over timeExperience building or moving to a modern lakehouse from ADF, SSIS, Informatica, or a similar ETL toolExperience using Git-based version control for data pipelines or ETL codeExperience leading projects and helping junior engineers growThe ability to work independently and as part of a small teamStrong communication and problem-solving skillsExperience with ERP systems is a plus—NetSuite is preferred, but SAP, Oracle, or Microsoft Dynamics experience is also helpfulExperience with Power BI, CI/CD, modern data transformation tools, or managed ingestion tools such as Fivetran, Estuary, or Airbyte is a plusExperience leading a greenfield build or major data platform rebuild is strongly preferredWhat You'll GetCompetitive pay and 401k — because your work should be rewarded fairlyTime off you'll actually use: vacation, sick days, holidays, parental, and bereavement leaveFull medical, dental, and vision coverage, plus extra support when you need itWellness resources to help you show up as your best self, at work and at homeReal room to grow — we promote from within and invest in your developmentEqual Opportunity EmployerAll 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.