Data Modeller - SQL

About The Opportunity :
Operating at the forefront of the consulting and technology services sector, our client delivers transformative data management and business analytics solutions to a global clientele. Specializing in innovative approaches to data architecture and information management, they empower organizations to make data-driven decisions. We are seeking a seasoned professional to drive the evolution of our data infrastructure.This is an exciting chance to join a high-caliber team that values precision, efficiency, and strategic vision in a fully remote setting from anywhere in India.Role & Responsibilities :
As a key member of our team, you will be instrumental in shaping our data landscape.

Your responsibilities will include :
- Designing, developing, and maintaining comprehensive logical and physical data models that meet stringent business and regulatory requirements.- Collaborating with cross-functional teams including data engineers, analysts, and business stakeholders to align data architecture with evolving business needs.- Translating complex business requirements into robust and scalable data models, ensuring optimal performance and data integrity.- Optimizing and refining existing data structures and frameworks to enhance data access, reporting, and analytics capabilities.- Driving governance and data quality initiatives by establishing best practices and documentation standards for data modeling.- Mentoring and guiding junior team members, fostering a culture of continuous improvement and technical excellence.Skills & Qualifications :
Must-Have :
- Experience : 6+ years of experience in data modeling and related disciplines.- Data Modeling : Extensive expertise in conceptual, logical, and physical models, including Star/Snowflake schema design, Normalization, and Denormalization techniques.- Snowflake : Proven experience with Snowflake schema design, Performance tuning, Time Travel, Streams & Tasks, and Secure & Materialized Views.- SQL & Scripting : Advanced proficiency in SQL (including CTEs and Window Functions), with a strong focus on automation and optimization.Key Skills :
- Data Modeling (conceptual, logical, physical)- Schema Design (Star Schema, Snowflake Schema)- Optimization & Performance Tuning- Snowflake (Schema design, Time Travel, Streams and Tasks, Secure Views, Materialized Views)- Advanced SQL (CTEs, Window Functions)- Normalization & Denormalization- Automation- NoSQL (preferred, but not mandatory)