Senior Snowflake dbt Data Engineer

Overview

Senior Snowflake dbt Data Engineer ($ - $) at Irvine Company

Position Summary:

This role focuses on building and maintaining robust, scalable, and automated data pipelines, optimizing our data infrastructure, and enabling efficient data delivery. As the organization enhances its cloud data platform (Snowflake), this role will implement and manage CI/CD processes, infrastructure as code (Terraform), and data transformation workflows (dbt).

• Design, build, and maintain scalable and resilient CI/CD pipelines for data applications and infrastructure, with a focus on Snowflake, dbt, and related data tools.
• Implement and manage Snowflake dbt projects for data transformation, including developing dbt models, tests, and documentation, and integrating dbt into CI/CD workflows.
• Develop and manage infrastructure as code (IaC) using Terraform to provision and configure cloud resources for data storage, processing, and analytics on GCP.
• Automate the deployment, monitoring, and management of Snowflake data warehouse environments, ensuring optimal performance, security, and cost-effectiveness.
• Collaborate with data engineers and data scientists to understand requirements and provide automated solutions for data ingestion, processing, and delivery.
• Implement and manage monitoring, logging, and alerting systems for data pipelines and infrastructure to ensure high availability and proactive issue resolution.
• Develop and maintain automation scripts/tools using Python (and Bash for system tasks) to streamline operational tasks and data pipelines.
• Ensure security best practices across data infrastructure and pipelines.
• Troubleshoot and resolve issues related to data infrastructure, pipelines, and deployments in a timely manner.
• Participate in code reviews for infrastructure code, dbt models, and automation scripts.
• Document system architectures, configurations, and operational procedures.
• Stay current with emerging Dev Ops technologies, data engineering tools, and cloud best practices related to Snowflake, dbt, and Terraform.
• Optimize data pipelines for performance, scalability, and cost.
• Support and contribute to data governance and data quality initiatives from an operational perspective.

• Bachelor's degree in Computer Science, Engineering, or a related technical field (or equivalent).
• 5+ years in a Dev Ops, SRE, or infrastructure engineering role.
• 3+ years automating and managing data infrastructure and pipelines.

• Strong experience with Infrastructure as Code tools, particularly Terraform.
• Background in Dev Ops principles and practices, with hands-on experience in BI solutions.
• Automation, problem-solving skills, and proficiency in cloud technologies.
• Ability to collaborate with data engineers, analysts, and stakeholders to ensure reliability and performance of the data ecosystem.
• Proven experience with dbt for data transformation in production.
• Hands-on experience managing and optimizing Snowflake data warehouses.
• Knowledge of data modeling (ODS, dimensional models, semantic models) for analytics.
• Strong Python skills for automation and data tasks;
  Bash scripting.
• Understanding of CI/CD principles and tools (Bitbucket Runners, Jenkins, Git Lab CI, Git Hub Actions, Azure Dev Ops).
• Experience with cloud platforms (GCP preferred; AWS or Azure also acceptable) and their data services.
• Experience with containerization (Docker, Kubernetes) is a plus.
• Knowledge of data integration tools and ETL/ELT concepts.
• Familiarity with monitoring and logging tools.
• Strong SQL skills.
• Ability to work independently and in an agile, collaborative environment.
• Strong communication skills to explain complex technical concepts.

Base Pay Range: $ - $. Actual placement within this range may vary based on experience, tenure, internal peers’ salaries, performance, business sector, and location.

The company also offers competitive benefits for full-time employees including paid time off, matching 401(k), and health benefits.

Irvine Company is a privately held real estate investment company and master-planner committed to creating and sustaining communities that thrive for generations. We are known for master planning and environmental stewardship of the Irvine Ranch in Orange County, with diversified operations throughout coastal California.

We take pride in our employee community, a collaborative environment, and abundant opportunities. Apply today to join our team and learn more about Irvine Company, our legacy, and our guiding principles.

Irvine Company is an equal opportunity employer. We provide equal opportunity in all employment practices without regard to race, religion, color, sex, sexual orientation, 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 law. Reasonable accommodations are available upon request.