Data Engineer II - Apartments.com - Irvine, CA
Core
Design and maintain scalable data infrastructure, pipelines, and dashboards to track site performance, product usage, and consumer behavior for Apartments.com.
Role type
Senior Data Engineer (Cloud & AI)
Builds
Secure data warehouses, data lakehouses, automated ETL pipelines, and KPI dashboards for real estate analytics.
Domain
Real Estate / Commercial & Residential / Cloud Data Engineering
Deliverable
production ML models | dashboards & analysis
Required skills
Python, PySpark, SQL, Cloud Data Platforms (Databricks, Snowflake, BigQuery), AWS, ETL/ELT, Dimensional Modeling, Medallion Architecture, CI/CD (Terraform), Data Governance, LLM integration
Preferred skills
NoSQL (DynamoDB), Event Streaming (Kafka), Container Services, LLMs/Prompt Engineering, Object-Oriented Programming
Technologies
Databricks, Snowflake, BigQuery, AWS, PySpark, Terraform, Kafka, Power BI
Responsibilities
Design and implement dimensional modeling and cloud data platform structures; Develop secure data warehouses and data lakehouses using Medallion Architecture; Build and optimize scalable data pipelines and Spark jobs; Integrate Machine Learning into data pipelines to develop predictive models; Automate data infrastructure deployment via AWS DevOps and CI/CD; Mentor engineers and analysts; Optimize query performance and data quality.
Seniority
Senior, hands-on IC with mentorship responsibilities