Data Engineer - Contract ($65 - $95)

Irvine Company; Irvine (CA); Hybrid; USD 90,000 - 131,000; Full time

Benefits offered by this job

Benefits package

401(k) match

Health benefits

Job summary

Irvine Company is seeking an Analytics Engineer to design dimensional models on Snowflake, build dbt pipelines, and orchestrate with Dagster. You will develop Python-based ingestion for non-standard sources and ensure data quality for analytics.

You will collaborate with analysts, participate in code reviews, and document data models and transformation logic. This contract/temporary role is paid through a staffing arrangement and offers a path to strong data engineering experience in a real

Qualifications

• Bachelor's degree or equivalent practical experience in a technical field.
• Strong SQL and Python for analytics engineering.
• Experience with dbt or willingness to learn quickly.
• Familiarity with data warehousing concepts on Snowflake or similar.
• Experience with dbt in production environments.
• Understanding of dimensional modeling and layered data architectures.
• Exposure to workflow orchestration tools like Dagster or Airflow.

Responsibilities

• Design and develop dbt models following medallion architecture (bronze to gold).
• Build dimensional models, including fact and dimension tables for analytics.
• Implement and maintain data quality tests using dbt.
• Optimize SQL transformations within dbt for Snowflake performance.
• Document data models, transformation logic, and operational procedures.
• Configure and maintain Dagster assets to orchestrate dbt execution and schedules.
• Monitor pipeline health and resolve execution failures.
• Create Python-based ingestion pipelines for sources without native connectors.
• Participate in code reviews for dbt models and orchestration configurations.

Skills

Strong SQL

Python

dbt

Data warehousing concepts

Snowflake

Dagster

Airflow

Education

Bachelor's degree in Computer Science, Engineering, or related field

Tools

Dagster

Airflow

Git-based workflows

sqlfluff

Job description

Select how often (in days) to receive an alert:

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.

• 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.

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.