We seek a motivated and skilled Data Modeller to join our dynamic team. This role involves designing, developing, and maintaining data models for cloud-based data platforms, primarily on AWS. The Data Modeller will play a critical role in shaping high-quality data structures that drive effective data solutions for business needs.

About the Client:
Our client is a leading IT company in the financial services sector, specialising in delivering innovative technology solutions on a global scale. With a strong focus on AWS, the company leverages cutting-edge cloud technologies to provide scalable, secure, and efficient data-driven solutions.

Key Responsibilities:

• Data Modelling and Standards:
  • Apply data modelling and design standards, tools, and best practices.
  • Collaborate closely with data architects to design customised databases using conceptual and logical models.
  • Develop conceptual, logical, and physical data models; implement RDBMS, operational data stores (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
  • Ensure data models align with business requirements and architecture frameworks.
  • Utilise approved tools to create high-quality data modelling deliverables.
  • Maintain the Enterprise Logical Data Model as a standard to streamline data modelling efforts.
  • Oversee modelling activities to ensure consistency with the Enterprise Data Model (EDM).

• Data Analysis and Mapping:
  • Collaborate with team members to translate business requirements into data requirements.
  • Profile source data to assess data quality, relationships, patterns, and rules.
  • Structure data requirements based on the Enterprise Data Model, including ERD and dimensional models.
  • Identify definitive data sources, analyse data quality, and address gaps.
  • Generate physical data models to enable efficient data structure implementation.

• Data Flow and Standards Compliance:
  • Document data flows across systems and interfaces to facilitate data flow understanding.
  • Implement standards for document naming, security, and data lifecycle management.
  • Identify opportunities for data-driven improvements in business processes.

Behavioural Competencies:

• Stakeholder Engagement: Collaboration, influencing, and effective communication.
• Decision Making: Analytical mindset and strong problem-solving skills.
• Action-Oriented: Results-focused, deadline-driven, with a commitment to excellence.
• Intellectual Curiosity: Continuous learning, adaptability, and innovation.
• Analytical Thinking: Meticulous attention to detail and output quality.
• Team Player: Collaborative, supportive, and a strong communicator.
• Personal Mastery: Lifelong learning and skill enhancement.

Qualifications:

• Bachelor's degree in IT, Engineering, or Business Analysis-related fields.
• AWS Certified Cloud Practitioner or similar certification is advantageous.

Minimum Requirements:

• Proficiency in Data Modelling tools such as Sparx Enterprise Architect, Erwin, SAP Power Designer, ER/Studio, or IBM Data Architect.
• Expertise in Entity Relationship Modelling, Physical Database Design, Data Warehousing, Data Integration, and Data Quality.
• Strong understanding of Master Data Management, Metadata, and database concepts.
• Knowledgeable in conceptual, logical, and physical data modelling principles.
• Familiarity with data models, relational and dimensional modelling, and data normalisation.
• Broad knowledge of Data Management (DMBOK), SDLC, and IT Architecture.

Ideal Experience and Skills:

• Experience with Canonical Data Modelling.
• Background in banking or financial services environments.
• Familiarity with BI tools and database optimisation.
• Strong ability to communicate complex technical ideas to varied audiences.
• Experience with semi-structured databases is a plus.

Experience:

• Minimum of 7+ years of relevant data modelling experience.