HamburgerMenu
hirist

Perficient - Snowflake/DBT Architect - Manufacturing Domain

Perficient
11 - 13 Years
Multiple Locations

Posted on: 21/11/2026

Job Description

Employment Type: Full-time

Work Mode: Hybrid (3 days working from client office)

Notice Period: Immediate to 15 Days Preferred

About the Role:

We are looking for a seasoned Snowflake + DBT Architect with deep manufacturing domain expertise to define and drive the architecture of enterprise cloud data platforms. The candidate will be responsible for designing scalable data architectures, establishing technical standards and leading architecture decisions across manufacturing, ERP and supply chain data ecosystems.

Key Responsibilities:

- Define end-to-end data architecture and solution design using Snowflake, DBT and AWS.

- Architect scalable and high-performance data pipelines for manufacturing, ERP, SAP, MES and IoT data.

- Design enterprise data models covering production, inventory, quality, supply chain, OEE, yield and downtime.

- Establish architecture standards for data modelling, data governance, security and data quality.

- Drive Snowflake performance optimisation, warehouse sizing and cost management.

- Define best practices for DBT Cloud, SQL development, Git, CI/CD and deployment processes.

- Design integration frameworks using AWS S3, IAM, Glue and Lambda.

- Lead architecture reviews, technical discussions and solution validation.

- Guide technical teams, review implementation designs and ensure architectural consistency.

- Engage with business stakeholders and clients to understand requirements and recommend technical solutions.

Mandatory Skills:

- 5+ years of hands-on experience with Snowflake.

- 3+ years of experience with DBT / DBT Cloud.

- 8+ years of experience with SQL and advanced performance tuning.

- Strong AWS expertise including S3, IAM, Glue and Lambda.

- Strong Python programming and data engineering knowledge.

- 3+ years of manufacturing domain experience.

- Expertise in Kimball dimensional modelling and enterprise data architecture.

- Experience with Git, CI/CD, Agile and data governance practices.

- Snowflake SnowPro Core / Advanced certification.

- Proven experience in solution architecture, technical design and client-facing engagements.

- Excellent communication and stakeholder management skills.

Good to Have:

- Snowflake Cortex / Cortex Code.

- Snowpark and GenAI/ML architecture.

- Airflow, Fivetran or Matillion

info-icon

Did you find something suspicious?

Similar jobs that you might be interested in

Loading chat...