Perficient · 6 days ago
Senior Technical Consultant - Snowflake with DBT
Irvine, CA
Full-time
Onsite
Senior Level
$65K/yr - $150K/yr
7+ years expPerficient is a global AI-first consultancy seeking a Senior Technical Consultant - Snowflake with DBT to join their Data & Analytics Team in Irvine, CA. The role involves designing, developing, and maintaining data pipelines and solutions using Snowflake and DBT to enable clients to leverage data for analytics.
ConsultingInformation TechnologyInternetMarketing
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
Qualification
Required
Bachelors or Masters degree in Computer Science Data Engineering or related field
7 years of experience in data engineering with at least 4 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
Ability to communicate effectively via multiple channels (verbal, written, etc.) with technical and non-technical staff
Preferred
Familiarity with AI-enhanced platforms is a plus
Client-facing or consulting experience is highly preferred
Company
Perficient
Perficient is an IT consulting firm that helps companies adapt their systems to third party software products that use internet.
5001-10000 employees
H1B Sponsorship
Perficient has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (154)
2024 (147)
2023 (156)
2022 (196)
2021 (175)
2020 (223)
Funding
Current Stage
Public CompanyTotal Funding
$65.3M2024-05-05Acquired
2024-01-17Post Ipo Equity· $4.44M
2022-10-17Post Ipo Equity· $5.18M
Leadership Team
Ed Hofffman
Senior Vice President, North America Business Operations
Hari Madamalla
Vice President
Recent News
2025-11-10
Dallas Innovates
2025-10-11
Company data provided by crunchbase