Snowflake Data Engineer with DBT exp

Perficient • Irvine, CA

12h

About The Position

Perficient is a global AI-first consultancy. Our team of strategists, designers, technologists, and engineers partners with the world’s most innovative enterprises and admired brands to deliver real business results through the transformative power of AI. As part of our AI-First strategy, we empower every employee to build AI fluency and actively engage with AI tools to drive innovation and efficiency. We break boundaries, obsess over outcomes, and shape the future for our clients. Join a company where bold ideas and brilliant minds converge to redefine what’s possible - while building a career filled with growth, balance, and purpose. We currently have a career opportunity for a Technical Consultant with Snowflake and DBT to join our Data & Analytics Team in Irvine, CA The Technical Consultant with Snowflake and DBT will be responsible for designing, developing, and maintaining data pipelines and solutions to enable our client to harness the power of the data for further analytics. The engineer will work with modern data technologies, emphasizing Snowflake and dbt (Data Build Tool) to automate, build, test, and maintain the data infrastructure. Additionally, it is expected that people participate actively in all aspects of the data lifecycle and provide recommendations aligned with best practices within the process. Job Overview: As a Technical Consultant, you will participate in all aspects of the software development lifecycle, which includes estimating, technical design, implementation, documentation, testing, deployment, and support of applications developed for our clients. As a member working in a team environment, you will work with solution architects and developers on the interpretation/translation of wireframes and creative designs into functional requirements, and subsequently into technical design. Perficient is always looking for the best and brightest talent, and we need you! We’re a quickly growing, global digital consulting leader, and we’re transforming the world’s largest enterprises and biggest brands. You’ll work with the latest technologies, expand your skills, and become a part of our global community of talented, diverse, and knowledgeable colleagues.

Requirements

• Bachelors or Masters degree in Computer Science Data Engineering or related field
• 7 years of experience in data engineering with at least 2 years focused on Snowflake and DBT
• Strong proficiency in SQL and Python
• Experience with cloud platforms AWS GCP or Azure
• Familiarity with Git CICD and Infrastructure as Code tools Terraform CloudFormation
• Knowledge of data modeling star schema normalization and ELT best practices
• Demonstrated ability to leverage AI tools to enhance productivity, streamline workflows, and support data-informed task execution.
• A solid understanding of AI capabilities and limitations including ethical considerations is expected
• Team oriented, interpersonal, highly motivated, passionate, and creative team-player with the ability to develop and maintain collaborative relationships with all levels within and external to the organization
• Ability to communicate effectively via multiple channels (verbal, written, etc.) with technical and non-technical staff.

Nice To Haves

• Familiarity with AI-enhanced platforms is a plus.
• Client-facing or consulting experience is highly preferred.

Responsibilities

• Design develop and maintain ELT pipelines using Snowflake and DBT
• Build and optimize data models in Snowflake to support analytics and reporting
• Implement modular testable SQL transformations using DBT
• Integrate DBT workflows into CICD pipelines and manage infrastructure as code using Terraform
• Collaborate with data scientists analysts and business stakeholders to translate requirements into technical solutions
• Optimize Snowflake performance through clustering partitioning indexing and materialized views
• Automate data ingestion and transformation workflows using Airflow or similar orchestration tools
• Ensure data quality governance and security across pipelines
• Troubleshoot and resolve performance bottlenecks and data issues
• Maintain documentation for data architecture pipelines and operational procedures

Benefits

• Perficient, Inc. proudly provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a protected veteran in accordance with applicable federal, state and local laws.
• Perficient, Inc. complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
• Perficient, Inc. expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orientation, national origin, age, genetic information, disability, or covered veterans.
• Disability Accommodations: Perficient is committed to providing a barrier-free employment process with reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures.
• Applications will be accepted until the position is filled or the posting is removed.
• Information regarding the benefits available for this position are in our benefits overview .

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees