Irvine Company · 14 hours ago
Data Engineer - Contract ($65 - $95)
Irvine, CA
Full-time, 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 data for analytics on a Snowflake platform.
Commercial Real EstateReal EstateReal Estate Investment
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
The Irvine Company is a real-estate investment company.
1001-5000 employees
H1B Sponsorship
Irvine Company has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2022 (2)
2021 (1)
2020 (5)
Funding
Current Stage
Late StageLeadership Team
Abe Wong
Chief Technology Officer
Marc Ley
Executive Vice President and Chief Investment Officer
Recent News
The Real Deal
2025-11-05
San Diego Union-Tribune
2025-11-01
Company data provided by crunchbase