Snowflake+ DBT- Senior Technical Architect

PerficientBengaluru, KarnatakaOn-siteFull-timeSenior, 5–8 yearsListed 41 minutes ago

Apply now

About this role

We currently have a career opportunity for a Senior Technical Architect, Snowflake+ DBT, to join our team located in Bangalore, Chennai .

As a Senior Technical Architect, you will provide best-fit architectural solutions for one or more projects; you will assist in defining scope and sizing of work; and anchor Proof of Concept developments. You will provide solution architecture for the business problem, platform integration with third party services, designing and developing complex features for clients' business needs.

The Senior Technical Architect will provide technology direction, ensures project implementation compliance, and utilizes technology research to innovate, integrate, and manage technology solutions. You will collaborate with some of the best talent in the industry to create and implement innovative high quality solutions, participate in Sales and various pursuits focused on our clients' business needs. This role is considered part of the Business Unit Leadership team and may mentor Junior Architects and /or development team members.

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.

Demonstrated ability to leverage AI tools to enhance productivity, streamline workflows, and support data-informed task execution.
Familiarity with AI-enhanced platforms is a plus. A solid understanding of AI capabilities and limitations including ethical considerations is expected.

Required Skills

- Snowflake: Deep expertise in architecture, performance optimization, security, data sharing, and cost management.
- Data Architecture: Strong experience designing data warehouses, lakehouses, and modern data platforms.
- Architecture Modeling: Proficiency in conceptual, logical, and physical modeling (Kimball, Inmon, Data Vault 2.0) using tools such as ER/Studio, ERwin, or equivalent.
- Data Governance: Hands-on experience with governance, metadata management, lineage, data quality, and access control.
- SQL: Expert-level SQL, including complex transformations, query tuning, and analytical functions.
- AWS: Solid working knowledge of the AWS data ecosystem, including S3, IAM, Glue, Lambda, and networking and security fundamentals.
- dbt: Hands-on experience architecting and scaling dbt projects (Core or Cloud) on Snowflake, including testing, macros, and CI/CD.
- AI: Working knowledge of Snowflake Cortex and Snowpark, with practical experience supporting ML or GenAI use cases on enterprise data platforms.

Preferred Skills

- SnowPro Advanced: Architect certification (or SnowPro Core with a plan to certify)
- AWS certification (Solutions Architect or Data Analytics specialty)