Senior Data Engineer
Job Description
AIR Communities is hiring a Senior Data Engineer in Denver, CO (onsite) to design, build, and optimize modern data pipelines and cloud-based data platforms. The role supports analytics, machine learning, and business applications while maintaining data governance, security, and quality.
Responsibilities
- Design, develop, and maintain scalable data pipelines for ingesting, transforming, and delivering large and diverse datasets.
- Write efficient, reusable SQL and/or Python code for data ingestion, transformation, automation, 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 needs and deliver 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 a wide range of internal and external sources into centralized data platforms.
- Contribute to knowledge sharing and guide less-experienced engineers when needed.
- Stay informed on emerging tools and architectures and contribute ideas for continuous improvement.
- Perform performance tuning and optimization across ingestion, transformation, and storage layers.
Required Qualifications
- Bachelor’s degree in Computer Science, Engineering, or related field (or equivalent experience).
- 8+ years of experience in data or related engineering roles, including 5+ 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, security, and handling sensitive or regulated data (including PII).
- Experience with version control and CI/CD practices.
- Strong problem-solving skills and the ability to work with complex or unstructured datasets.
- Strong analytical and troubleshooting abilities, including root-cause analysis.
Preferred
- 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.
Technical Focus
Primary technologies include SQL and Python.
Soft Skills
- Strong communication skills, with the ability to explain technical concepts clearly.
- Collaborative mindset and experience working across cross-functional teams.
- Adaptability and resilience when navigating ambiguity or shifting priorities.
- Proactive problem-solving, including identifying opportunities and driving solutions.
- Strong sense of ownership and commitment to delivering high-quality engineering work.
- Growth mindset with ongoing curiosity and continuous improvement of tools and processes.
Compensation and Benefits
- Expected annual pay rate of $125,000 - $145,000 plus an annual bonus.
- 25% discounted rent at AIR communities (certain exclusions apply, and an application is required).
- Medical, dental, vision, and life insurance options.
- HSA with company sponsored contributions, plus FSA (traditional and dependent care FSA).
- Short and long-term disability paid by the company.
- 401(K) plus company contributions.
- Paid Vacation, 14 Paid Holidays, and Paid Sick Time.
- Tuition Assistance Program.
- Commuter Benefits and Pet-Insurance.
- Up to 100% reimbursement on professional certification/licensing for job-related curriculums.
- Paid parental leave of up to 16 weeks following the birth or adoption of a child.
- 15 hours of paid time annually to give back to the community.
- Professional development and career growth opportunities, including realistic job previews, in-person and virtual leadership training, and performance improvement courses.
- Consumer discounts from various products and services including travel planning, wireless phones, health and fitness, home appliances, and more.
Application Deadline and Screening
- Application Deadline: 11/30/2026 (initial deadline).
- Pre-employment screening for candidates who receive an offer may include reference checks, a four-panel drug screening that excludes marijuana testing, employment verification, and a criminal background check.