Lead Data Engineer

Overview In this role you will architect and optimize scalable data pipelines and cloud data platforms to enable analytics, ML, and critical business apps. You will work with cross-functional teams to translate data needs into reliable solutions, uphold governance and security, and mentor engineers. You’ll shape the data infrastructure to support AIR’s growth and data-driven decision making in a collaborative, office-based environment. This is an opportunity to impact how real-time insights drive performance and scale across the organization. Compensation / Benefitscompetitive base salaryannual bonushealth, dental, and vision insurance401(k) with company contributionspaid vacation and holidaystuition assistance ResponsibilitiesDesign, develop, and maintain scalable data pipelines for large and diverse datasetsWrite efficient SQL and/or Python for ingestion, transformation, and integrationOptimize workflows for performance, reliability, security, and cost in cloud environmentsCollaborate with data scientists, analysts, and stakeholders to define data requirementsImplement data governance and security practices across pipelines and assetsMonitor data flows, troubleshoot issues, and ensure data quality and availabilityIntegrate data from internal and external sources into centralized platformsProvide technical leadership and mentor junior engineersEvaluate new tools and architectures and drive improvementsTune performance across ingestion, transformation, and storage layers Key requirementsBachelor’s degree in CS/Engineering or related field or equivalent experience12–14+ years in data or related engineering roles with 8+ years in data engineeringAdvanced SQL and/or Python for data processing and automationHands-on experience building and optimizing data pipelines and integrationsStrong data modeling, performance optimization, and query tuningExperience with cloud platforms and data ecosystemsKnowledge of ETL/ELT concepts, orchestration patterns, and automated workflowsUnderstanding of data governance and data security, handling PIIExperience with version control and CI/CD practicesStrong problem-solving and troubleshooting in complex data environmentsStrong leadership and mentorship abilitiesStrategic thinking aligned with business objectivesEffective communication to non-technical audiencesAdvanced SQL and Python for data processingData pipeline design and optimizationCloud platforms and their data ecosystems