Lead Data Engineer

• Compensation: USD 135,000 - USD 160,000 - yearly

AIR Communities is a Multifamily Real Estate Operator headquartered in Denver, CO. We are one of the country's largest owners and operators of multifamily housing, managing high-quality properties in most major markets.

At AIR, we value integrity, respect, collaboration, customer focus, and performance. These values are brought to life by our teammates, who are ultimately responsible for our success. When you join our team, you'll work alongside the most dedicated professionals in the industry and open the door to unlimited career opportunities.

AIR is preparing for growth in 2026! We are adding to several departments in our Denver Headquarters with our anticipated growth. Are you ready to take on a new challenge?

Our corporate office is located in the Denver Tech Center
. Our office spans the top two floors of the building and features expansive views of the mountains and the downtown skyline.

AIR values relationships and the benefits from working side by side with teammates, therefore this position will be in-office 5 days a week to support operations.

We are seeking a highly skilled Lead Data Engineer to join our dynamic data team. The ideal candidate has extensive experience designing, building, and optimizing modern data pipelines and cloud-based data platforms. In this role, you will help shape scalable data infrastructure that supports analytics, machine learning, and business‑critical applications across the organization.

• Design, develop, and maintain scalable data pipelines to ingest, transform, and deliver large and diverse datasets.
• Write efficient, reusable SQL and/or Python for data ingestion, transformation, and integration.
• Optimize data workflows for performance, reliability, security, and cost‑efficiency in cloud environments.
• Collaborate with data scientists, analysts, application teams, and business stakeholders to understand data requirements and deliver technical solutions.
• Implement data governance and security practices across pipeline components and data assets.
• Monitor data flows, troubleshoot issues, and ensure data quality, availability, and integrity.
• Integrate data from various internal and external sources into centralized data platforms.
• Provide technical leadership, mentor junior engineers, and support knowledge‑sharing within the team.
• Evaluate emerging tools and architectures, recommending improvements to existing systems and processes.
• Conduct performance tuning and optimization across ingestion, transformation, and storage layers.

• Bachelor’s degree in Computer Science, Engineering, or related field, or equivalent experience.
• 12–14+ years of experience in data or related engineering roles, with 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 ecosystem.
• Knowledge of ETL/ELT concepts, orchestration patterns, and automated data workflows.
• Understanding of data governance, data security, and handling sensitive or regulated data (e.g., PII).
• Experience with version control and CI/CD practices.
• Strong problem‑solving abilities with experience in complex or unstructured data environments.
• Strong analytical and troubleshooting skills, including root‑cause analysis.

• Experience with distributed data processing or declarative pipeline frameworks.
• Familiarity with cloud‑native functions and workflow orchestration tools.
• Experience with data governance frameworks, metadata management, or cataloging solutions.
• Knowledge of columnar storage and big‑data file formats.
• Familiarity with modern table formats such as Parquet, Delta, or Iceberg.

• Strong leadership and mentorship abilities, with a focus on elevating team capability and fostering knowledge sharing.
• Strategic thinking and the ability to align engineering work with…