Lead Data Engineer
Air Communities5 months ago
Denver, CO, USAStaff+
Base Salary
$135k - $160k/yr
Responsibilities
- Design, develop, and maintain scalable data pipelines for data ingestion, transformation, integration, and delivery.
- Write reusable SQL and/or Python for data processing, transformation, and automation.
- Optimize data workflows and storage layers for performance, reliability, security, and cost efficiency in cloud environments.
- Collaborate with data scientists, analysts, application teams, and business stakeholders to deliver technical data solutions.
- Implement data governance and security practices across pipelines and data assets, including handling sensitive or regulated data.
- Monitor data flows, troubleshoot issues, and ensure data quality, availability, and integrity.
- Integrate internal and external data sources into centralized data platforms.
- Provide technical leadership, mentor junior engineers, and support team knowledge sharing.
- Evaluate emerging tools and architectures and recommend improvements to existing systems and processes.
- Conduct performance tuning and query optimization across ingestion, transformation, and storage layers.
Requirements
- Bachelor’s degree in Computer Science, Engineering, or a related field, or equivalent experience.
- 12–14+ years of experience in data or related engineering roles, including 8+ years focused on data engineering.
- Advanced proficiency in SQL and/or Python for data processing, transformation, and automation.
- Hands-on experience building and optimizing data pipelines and integration workflows.
- Strong understanding of data modeling, performance optimization, and query tuning.
- Experience with cloud platforms and their data ecosystems.
- Knowledge of ETL/ELT concepts, orchestration patterns, and automated data workflows.
- Understanding of data governance, data security, and sensitive or regulated data such as PII.
- Experience with version control and CI/CD practices.
- Strong problem-solving, analytical, troubleshooting, and root-cause analysis skills in complex or unstructured data environments.
- Preferred experience with distributed data processing or declarative pipeline frameworks, cloud-native functions, workflow orchestration tools, data governance frameworks, metadata management, cataloging solutions, columnar storage, and big-data file formats.
- Preferred familiarity with modern table formats such as Parquet, Delta, or Iceberg.
- Strong leadership, mentorship, strategic thinking, communication, collaboration, adaptability, initiative, ownership, and commitment to quality.
Benefits
- Expected base salary is $135,000–$160,000 plus an annual bonus.
- 25% discounted rent at AIR communities, subject to exclusions and application requirements.
- Medical, dental, vision, life insurance, HSA with company-sponsored contributions, and traditional and dependent-care FSA options.
- Company-paid short- and long-term disability coverage.
- 401(k) with company contributions.
- Paid vacation, 14 paid holidays, and paid sick time.
- Tuition assistance, commuter benefits, pet insurance, and professional certification or licensing reimbursement of up to 100%.
- Paid parental leave of up to 16 weeks following birth or adoption.
- Consumer discounts, professional development opportunities, leadership training, and performance improvement courses.
- The position is in-office five days per week at the Denver Tech Center corporate office.
- The initial application deadline is June 9, 2026, with rolling consideration afterward until the position is filled.
- Offers are subject to reference checks, employment verification, criminal background checks, and a four-panel drug screening excluding marijuana testing.