Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 1K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Employer? Claim Account for FREE

MUFG Pension & Market Services

Compare

3.7

based on 15 Reviews

50 MUFG Pension & Market Services Jobs

Data Modeller Data Modeller

MUFG Pension Market Services

3.7

based on 15 Reviews

10-15 years

Pune, Greater Noida

1 vacancy

Data Modeller Data Modeller

MUFG Pension & Market Services

posted 3hr ago

Job Role Insights

Flexible timing

Key skills for the job

Data Analytics SQL Automation Testing Schema Metadata JSON

+ 3 more

Job Description

The Data Modeller will contribute to the design, development, and implementation of high-quality data models to support the build of the Data Marketplace Data Domain and Product environment.

This individual contributor role focuses on leveraging Snowflake, industry-standard modelling techniques, DBT, and other applicable modelling tools to ensure scalable, efficient, and maintainable data solutions.

Key Accountabilities and main responsibilities

Strategic Focus

Stay updated with industry trends and advancements in data modelling, Snowflake, and DBT.
Identify opportunities for optimization and improvement using data modelling techniques.
Drive complex technical transformations, decommissions and realising business outcomes through data and analytics.
Drive the onboarding and rollout of technology services according to the pre-defined roadmap.
Actively seek opportunities to develop skills and technical knowledge.

Operational Management

Develop and maintain conceptual, logical, and physical data models using industry-standard modelling techniques.
Design models to meet analytical, operational, and reporting requirements.
Leverage Snowflake for cloud data modelling and architecture design.
Utilize DBT (Data Build Tool) to manage data transformations and pipelines.
Work with other applicable modelling software to enhance data workflows and output quality.
Maintain thorough documentation of data models, data dictionaries, and related processes.
Adhere to and promote best practices in data modelling and design.

People Leadership

Collaborate with data & insight analysts, developers, and stakeholders to translate business requirements into robust data models.

Governance & Risk

Ensure timely completion of activities by adhering with the agreed processes & quality standards.
Individual should adhere to data design best practices.
Adhere to MUFG s standards, policies, and procedures.
Adhere to data privacy and security standards (e.g., GDPR, HIPAA).
Identify and mitigate security risks and ensure IT security design and delivery.

The above list of key accountabilities is not an exhaustive list and may change from time-to-time based on business needs.

Experience & Personal Attributes

Experience

Overall, 10+ years of experience in data engineering and cloud migration in large, complex organisations with min 6+ years into data modelling
Experience with Entity-Relationship (ER) diagrams for designing entities, attributes, and relationships.
Knowledge of Object-Oriented Modelling (e.g., class structures, inheritance).
Familiarity with Dimensional Modelling for analytics (facts and dimensions).
Understanding of Business Process Modelling to link workflows and data entities.
Proficiency in Semantic Modelling for ontology-based data organization.
Ability to translate conceptual models into logical database designs.
Strong skills in defining data flows, dependencies, and relationships.
Proficiency in normalization (1NF, 2NF, 3NF) for reducing redundancy and improving data integrity.
Expertise in designing network and hierarchical models where needed.
Experience translating logical models into database schemas.
Knowledge of indexing, partitioning, and database optimization for performance.
Familiarity with cloud-based database systems (e.g., Snowflake, Redshift).
Proficiency in handling structured, semi-structured, and unstructured data.
Star Schema design for simplified analytics and reporting.
Snowflake Schema experience for storage optimization.
Knowledge of Data Vault for historical tracking and scalability.
Expertise in designing models for BI tools (e.g., Tableau, Power BI, ThoughtSpot).
Experience with Graph Modelling for social networks, fraud detection, or interconnected data.
Proficiency in Document Modelling (e.g., JSON, BSON) for NoSQL databases like MongoDB.
Knowledge of Key-Value or Wide-Column Stores for NoSQL use cases.
Familiarity with Temporal Data Models for handling time-variant or historical data.
Proficiency in SQL for database design and query optimization.
Familiarity with modern data platforms and tools: Erwin, ER/Studio, or similar for traditional modelling.
Familiarity with collaborative design tools like Lucid chart, dbForge, or PowerDesigner.
Experience with automation & cloud data platforms like Snowflake, AWS, Azure, or GCP.
Strong understanding of data governance and metadata management.
Hands-on experience with data integration and ETL/ELT processes.
Ability to design scalable models for both OLTP (transactional systems) and OLAP (analytics systems).

Personal Attributes

A dynamic and exceptional business-mind set with the ability to negotiate and influence senior level management, suppliers and key stakeholders.
Exceptional skills in influencing and driving change across the organisation.
Effective verbal and written communication skills, needed to communicate with global teams/stakeholders.
Practical and simple problem-solving approach.
Effective Team player with collaborative skills, learning and proactive attitude.
Quality orientation with attention to detail.
Commitment to continuous improvement.
Excellent planning and organizational skills.
Collaborate and share knowledge with other members of the team to ensure we are always evolving our collective skills and staying on the cutting-edge.
Strong in developing presentations and the ability to present and capture a wide variety of audiences.
Ability to expresses ideas effectively in individual and group situations; uses and shares information resources effectively.