Irvine Company Chicago · 17 hours ago
Data Engineer - Contract ($65 - $95)
Irvine, CA
Contract
Onsite
Mid Level
$65/hr - $95/hr
3+ years expIrvine Company is a privately held real estate investment company committed to creating and sustaining thriving communities. They are seeking a Data Engineer to develop dimensional models, ensure data quality, and deliver reliable analytics on a Snowflake platform.
Real Estate
Responsibilities
Design and develop dbt models following the medallion architecture (bronze > silver > gold layers)
Build dimensional models, including fact and dimension tables, for analytics consumption
Implement and maintain data quality tests using dbt’s testing framework
Optimize SQL transformations within dbt for performance in Snowflake
Write and maintain schema documentation with model and column descriptions, and apply dbt best practices (refs, sources, macros, tags)
Configure and maintain Dagster assets to orchestrate dbt model execution, including implementing schedules and sensors
Monitor pipeline health through the Dagster UI and resolve execution failures
Build and maintain bespoke Python-based ingestion pipelines for source systems without native connector support
Participate in code reviews for dbt models and Dagster configurations, and use tools like sqlfluff for code quality
Collaborate with analysts and data consumers, and document data models, transformation logic, and operational procedures
Qualification
Required
Strong SQL skills with ability to write and optimize analytical queries
Python proficiency for building data ingestion pipelines and scripting
Bachelor's degree in Computer Science, Engineering, or a related technical field, or equivalent practical experience
Experience with dbt or willingness to learn quickly (we use dbt extensively)
Familiarity with data warehousing concepts on Snowflake, BigQuery, or similar
Comfort with Git-based development workflows
Experience with dbt in a production environment
Familiarity with dimensional modeling (fact and dimension tables)
Experience with layered data architectures (staging, intermediate, mart patterns)
Exposure to workflow orchestration tools (Dagster, Airflow, Prefect)
Understanding of data quality testing approaches
Preferred
3 - 5 years in analytics engineering or data engineering
Benefits
Paid time off
Matching 401(k)
Health benefits
Company
Irvine Company Chicago
We create places that bring people together to succeed.
1001-5000 employees
Funding
Current Stage
Late StageCompany data provided by crunchbase