Website Irvine Company

Position Summary:
This is a contract/temporary position. Associate selected will be payrolled (W-2) through a staffing agency.
Develops dimensional models following medallion architecture patterns, ensures data quality, and guarantees reliable data delivery for analytics on a Snowflake platform. This involves building and maintaining dbt transformation pipelines, orchestrating with Dagster, and implementing various data ingestion methods, including Fivetran, Boomi, and custom Python pipelines for unique source systems.
Key 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.
Minimum Qualifications / Other Expectations:
- 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
Compensation:
Base Pay Start Rate: $65 – 95/hour
The Company also offers competitive benefits for full time employees including paid time off, matching 401(k), and health benefits.

About Us:
Irvine Company is a privately held real estate investment company and master-planner committed to creating and sustaining communities that thrive for generations.
Irvine Company is respected for its master planning and environmental stewardship of the Irvine Ranch in Orange County, including diversified operations throughout coastal California. Irvine Company brings to life neighborhoods and sustainable communities with a full range of housing, jobs, retail centers, schools, parks and open space.
We take as much pride in our employee community as we do the communities we create. It’s an environment populated with talented and experienced people, a collaborative spirit and abundant opportunities.
Apply today to join our employee community, and learn more about Irvine Company, our legacy and our guiding principles.
Irvine Company is committed to providing equal opportunity in all of our employment practices, including selection, hiring, promotion, transfer, compensation, termination, and training, without regard to race, religion, color, sex, sexual orientation, gender, gender identity, national origin, ancestry, citizenship status, marital status, pregnancy, age, medical condition, genetic information, military and veteran status, disability, or any other basis protected by federal, state, and local law. Reasonable accommodation is available for qualified individuals with disabilities, upon request.
#LI-Onsite
What this job looks like in the OC market
Pay check. This job lists about $166,400 a year (the midpoint of its posted range). That's above the $146,000 median for Technology & IT jobs posted in Orange County right now. See the full Technology & IT salary guide.
About Irvine. About 48,905 OCEAN professionals live or work in Irvine. 46.5% are VP level or above, and the biggest industry is medical devices. There are 1,839 open jobs in Irvine on the board today. See all Irvine jobs.
More at Irvine Company. Irvine Company has 45 open jobs in Orange County, #42 of 402 employers on the board. Other openings: Guest Services, Concierge · Preventative Maintenance Tech · HR Administrator – Contract · Assistant Service Manager – On-Site Living Required. See Irvine Company's hiring profile.
Meet people who hire here. A lot of OC hires still start with an introduction. OCEAN's monthly networking mixers and its free OCEAN Connect introductions put you in the room with people at companies like this one.
OCEAN Job Board data, updated daily from live postings. Member figures come from OCEAN's State of OC Business Networking 2026 report and are city-level totals only. How our data works.
Apply for this Job
This employer takes applications on their own website. The button opens it in a new tab.
Apply on Irvine Company's Site →Similar Jobs
Similar Jobs
Get Jobs Like This by Email
Working in Irvine
Irvine runs on a few big job clusters. The Irvine Business Complex next to John Wayne Airport is packed with finance, accounting, insurance, and law offices. The Irvine Spectrum area is home to tech, gaming, and automotive companies, including Blizzard Entertainment, Kia America, and Mazda North American Operations. Medical device makers like Edwards Lifesciences and Masimo are here too, and UC Irvine is one of the largest employers in the county.
Before You Apply
Apply through the button above, and keep your resume tailored to the keywords in the posting. Check the posted pay range against similar Orange County roles, and look up the drive time at rush hour before you commit. Want an edge? OCEAN has been connecting Orange County professionals since 2007, and a conversation at an OCEAN mixer can put you in front of the people who hire.
Keep looking: All jobs in Irvine · Tech & IT Jobs in Irvine, CA · Tech & IT Jobs in Orange County · Career advice