SUMMARY:
-
POSITION INFO:
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.
This role offers an exciting opportunity for a skilled Data Modeller to drive impactful data solutions within a leading financial services IT team.
