Data Modeller - SQL

About The Opportunity :

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)