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)