Key Responsibilities
Design, develop, and lead implementation of complex star-schema data models, including fact, dimension, bridge, and aggregate tables.
Build, optimize, and govern DBT frameworks, models, testing strategies, and reusable development patterns.
Architect, optimize, and troubleshoot large-scale Snowflake data structures, pipelines, and SQL workloads.
Define and enforce enterprise data modeling standards, best practices, and design patterns.
Lead architectural decisions related to dimensional modeling, normalization, denormalization, and analytical data structures.
Partner with Data Engineers, BI Developers, Product Owners, Architects, and business stakeholders to deliver scalable analytical solutions.
Mentor team members, conduct design reviews, and provide technical leadership across analytics engineering initiatives.
Drive data quality, performance, governance, documentation, and continuous improvement of the analytics platform.
Required Qualifications
Expert-level hands-on experience with DBT development, testing, and deployment practices.
Expert-level experience with Snowflake architecture, performance tuning, and SQL optimization.
Proven experience designing and implementing enterprise-scale dimensional data models.
Deep understanding of data warehousing, analytical modeling, and modern analytics engineering principles.
Experience leading technical design decisions and influencing data architecture strategy.
Strong communication and stakeholder management skills with the ability to translate complex technical concepts into business value.
