Associate Principal - Architecture

Job Summary

Seeking an Associate Principal with 12 to 16 years of experience specializing in Data Architecture Snowflake and Dimensional Data Modeling to lead and architect scalable data warehouse solutions

Job Description

Lead the design and implementation of enterpriselevel data architectures leveraging Snowflake platform Develop and optimize dimensional data models including star and snowflake schemas to support complex business intelligence and analytics needs Architect scalable and highperformance Snowflake data warehouse solutions ensuring data integrity and consistency Collaborate with business stakeholders and technical teams to translate business requirements into robust data models and architecture Drive best practices in data modeling data integration and data governance across projects Stay abreast of emerging technologies and trends in Snowflake architecture and data modeling to continuously innovate and improve solutions Provide technical leadership and mentorship to data architects engineers and modelers within the team

Roles and Responsibilities

Own endtoend data architecture design and implementation for Snowflakebased data warehousing projects

Develop and maintain dimensional data models to support analytical and reporting requirements

Guide and review complex Snowflake SQL queries stored procedures and performance tuning

Lead requirement gathering sessions and provide expert insights on data modeling and Snowflake architecture

Ensure data quality validation and consistency through rigorous testing and governance