
Lead Data Engineer
Air Communities1 day ago
Denver, CO, USAStaff+
Base Salary
$135k - $160k/yr
Responsibilities
- Design, develop, maintain, and optimize scalable data pipelines for ingestion, transformation, integration, and delivery.
- Write reusable SQL and Python for data ingestion, transformation, processing, automation, and integration.
- Optimize data workflows and storage layers for performance, reliability, security, availability, and cost-efficiency in cloud environments.
- Collaborate with data scientists, analysts, application teams, product, engineering, and business stakeholders to understand requirements and deliver technical solutions.
- Implement data governance and security practices across pipeline components and data assets, including handling sensitive or regulated data.
- Monitor data flows, troubleshoot issues, conduct root-cause analysis, and ensure data quality, integrity, and availability.
- 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 systems and processes.
- Conduct performance tuning 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 working 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 handling 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.
- Preferred familiarity with cloud-native functions, workflow orchestration tools, data governance frameworks, metadata management, cataloging solutions, columnar storage, and big-data file formats.
- Preferred knowledge of Parquet, Delta, or Iceberg table formats.
- Strong leadership, mentorship, strategic thinking, communication, collaboration, adaptability, initiative, ownership, and commitment to quality.
Benefits
- Expected base pay 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 contributions, and traditional and dependent-care FSA options.
- Company-paid short- and long-term disability.
- 401(k) with company contributions.
- Paid vacation, 14 paid holidays, and paid sick time.
- Tuition assistance, commuter benefits, and pet insurance.
- Up to 100% reimbursement for job-related professional certification or licensing curricula.
- Paid parental leave of up to 16 weeks following birth or adoption.
- Consumer discounts, 15 hours of paid annual community give-back time, and professional development and career-growth opportunities.
- Position is in-office five days per week at the Denver Tech Center corporate office.
- Initial application deadline is November 30, 2026, with rolling consideration afterward until the position is filled.
- Employment is contingent on reference checks, employment verification, criminal background check, and a four-panel drug screening excluding marijuana.