Data Modeller with a New Zealand based Product Co-Pune

Roles and Responsibilities:

Design, implement, and maintain scalable and modular data models for Snowflake,

incorporating region and country-specific extensions without impacting the global core.

Define, document, and approve changes to the core enterprise data model, embedding

business logic into model structures..

Optimize models for performance, data quality, and governance compliance.

Collaborate with BI teams to ensure semantic consistency and enable self-service

analytics.

Ensure adherence to data security, RBAC, and compliance best practices.

Use DevOps tools such as Git/Bitbucket for version control of data models and related

artefacts.

Maintain documentation, metadata, and data lineage for all models.

Preferred: Leverage tools like Matillion or equivalent ETL/ELT tools for model

integration workflows.

Required Skills & Experience:

5+ years of data modelling experience, with at least 3 years in a senior or lead role.

Proven expertise in designing enterprise-level data models for cloud data platforms,

preferably Snowflake.

Strong understanding of data warehouse design patterns (dimensional, Data Vault, and

other modelling approaches).

Ability to embed business logic into models and translate functional requirements into

technical architecture.

Experience managing and approving changes to the core data model, ensuring scalability,

semantic consistency, and reusability.

Proficiency in SQL with experience in Snowflake-specific features (streams, tasks, dynamic

tables).

Familiarity with ELT/ETL tools such as Matillion, DBT, Talend, or Azure Data Factory.

Experience with DevOps practices, including Git/Bitbucket for version control of modelling

artefacts.

Knowledge of metadata management, data lineage, and data cataloguing tools.

Strong understanding of data privacy, governance, and RBAC best practices.

Excellent communication and stakeholder engagement skills, including leading workshops.