> Markdown version of [/jobs/ext/1314395-data-engineer](https://www.wearedevelopers.com/jobs/ext/1314395-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Engineer

- **Company:** Irvine Company
- **Location:** Irvine, United States
- **Experience:** Experienced
- **Salary:** $135,200.0 - $197,600.0
- **Contract:** Temporary contract
- **Skills:** Airflow, BigQuery, Software Quality, Code Review, Data Architecture, Information Engineering, Data Warehousing, Database Queries, Dimensional Modeling, Document-Oriented Databases, Python (Programming Language), SQL Databases, Data Ingestion, Snowflake, Boomi, Git, Information Technology, Data Delivery, Data Pipelines
- **Published:** July 17, 2026
- **Apply:** https://www.dice.com/job-detail/35a57b04-c5b3-420c-8e61-0096a33873d5

## About the Role

* 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

## Description

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.


## Related Videos

- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94)
- [AI Model Management Life Circles: ML Ops For Generative AI Models From Research to Deployment](https://www.wearedevelopers.com/videos/1152-ai-model-management-life-circles-ml-ops-for-generative-ai-models-from-research-to-deployment)
- [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Dev Digest 132 - Binging WADFlix?](https://www.wearedevelopers.com/magazine/473-dev-digest-132-binging-wadflix)
- [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers)
- [How to Turn Community Events Into a Powerful AI GTM Engine: The Daytona Playbook](https://www.wearedevelopers.com/magazine/732-how-to-turn-community-events-into-a-powerful-ai-gtm-engine-the-daytona-playbook)