Senior Snowflake dbt Data Engineer ($132,200.00 - $169,400.00)

Position Summary :

This role has a specialized focus on building and maintaining robust, scalable, and automated data pipelines and plays a key role in optimizing our data infrastructure and enabling efficient data delivery across the organization. As the organization enhances its cloud data platform (Snowflake), this role will be instrumental in implementing and managing CI / CD processes, infrastructure as code (Terraform), and data transformation workflows (dbt).

Job Duties :

• 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 their requirements and provide robust, 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 robust automation scripts and tools, primarily using Python, to streamline operational tasks, manage data pipelines, and improve efficiency; Bash scripting for system-level tasks is also required.
• Ensure security best practices are implemented and maintained across the 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 DevOps technologies, data engineering tools, and cloud best practices, particularly 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.

Minimum Qualifications / Other Expectations :

Education & Experience :

Other :

Compensation :

Base Pay Range : $132,200.00 - $169,400.00

Actual placement within this range may vary based upon, but not limited to, relevant experience, time in role, base salary of internal peers, prior performance, business sector, and geographic location.

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