Data Modeller

Overview

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.

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, 5+ years of experience in data engineering and cloud migration in large, complex organisations with min 3+ 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).

Knowledge of Relational Database Management System (RDBMS) concepts

Familiarity with Dimensional Modelling for analytics (facts and dimensions).

Understanding of Business Process Modelling to link workflows and data entities.

Proficient with data modelling tools like SqlDBM and Medallion Architecture(Bronze, Silver & Gold data layers) is preferable or with Erwin.

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., Power BI, ThoughtSpot, Tableau).

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.

MUFG Pension & Market Services is a global, digitally enabled business that empowers a brighter future by connecting millions of people with their assets – safely, securely and responsibly.

Through our two businesses MUFG Retirement Solutions and MUFG Corporate Markets, we partner with a diversified portfolio of global clients to provide robust, efficient and scalable services, purpose-built solutions and modern technology platforms that deliver world class outcomes and experiences.

A member of MUFG, a global financial group, we help manage regulatory complexity, improve data management and connect people with their assets, through exceptional user experience that leverages the expertise of our people combined with scalable technology, digital connectivity and data insights.

Our MUFG Retirement Solutions division combines its proprietary technology, process and people to deliver a comprehensive financial data solution to its superannuation clients. We support clients across all superannuation fund sectors including government, industry, retail and corporate.

By accompanying our core member and employer administration with a full range of value-added services, we offer the most comprehensive superannuation administration solution on the market. The scale, adaptability and ease of use of our proprietary systems, in conjunction with our integrated analytics offering, allow us to innovate and grow with the needs of our clients.

MUFG Pension & Market Services is building a dynamic, client focused, caring and inclusive culture that is built on the foundations of an entrepreneurial spirit, effective risk management, empathy and trust, and underpinned by its core values.

We are an inclusive employer whose people work collaboratively. We encourage, support and value the various talents and perspectives of our people and promote a flexible and blended work environment where our people can thrive and their wellbeing is supported. We know that diversity drives better client outcomes, continuous improvement, and growth. Be part of the MUFG Pension & Market Services journey and together we will achieve our full potential.

We treat all individuals fairly and equitably and do not discriminate on the basis of diverse characteristics including, but not limited to gender, gender identity, sexual orientation, age, ethnicity, cultural background, physical abilities/disabilities, religious or political belief, marital or family status or carers responsibilities.

Candidates must have the relevant work rights to be considered for an opportunity at MUFG Pension & Market Services. Successful applicants will be required to complete background screening prior to commencement of employment.