Senior Banking Data Modeler

About PKC Advisory :

PKC Advisory (www.pkcadvisory.com ) offers a wide range of business advisory services to a large number of clients in the GCC and wider MENA region. We are the partner of choice to many of our clients delivering a sustainable value proposition through our strong multi-disciplinary team, wide spectrum of expertise, flexible engagement model placing Client First’, optimal blend of on-site presence and off-shore project execution and an emphasis on strong ethical values.

About the Job:

We are seeking is building a strategic Data, Governance & Analytics function to lead the bank's data transformation over the coming decade. As the Senior Banking Data Model Developer, you will be instrumental in designing and evolving the bank's common data model, addressing critical regulatory requirements, and supporting a phased, enterprise-wide data strategy. This journey begins with the initial implementation of Moody's Analytics for BASEL and will expand over several years to cover Finance, Risk, Treasury, and Operations, culminating in the operationalization of a comprehensive enterprise data platform. You will collaborate closely with business stakeholders, IT, and external vendors to create scalable, robust, and future-proof data models.

Duties and Responsibilities:

• Strategic Data Model Development: Design and maintain conceptual, logical, and physical data models for the bank's common data layer, with an initial focus on regulatory reporting and Moody's Analytics implementation.
• Source-to-Target Mapping: Lead the creation of source-to-target data mappings, defining transformation logic and data quality rules in partnership with business and technical teams.
• Datamart Design & Optimization: Build and optimize dimensional models (star/snowflake schemas) for Finance datamart and future datamarts, ensuring scalability and performance for analytical and reporting needs.
• Regulatory & Compliance Enablement: Translate complex regulatory requirements (including IFRS9, FINREP, AnaCredit, and future ECB IReF) and Moody's data structures into robust and auditable data models.
• Data Governance & Quality: Collaborate on defining reconciliation logic, derived attributes, and adjustment models with support for auditing and versioning. Promote best practices in metadata management and data governance.
• Roadmap Execution: Play a critical role in executing the long-term data transformation roadmap, including supporting the Moody's implementation, achieving regulatory compliance milestones (SREP), and scaling the data platform to other business areas.
• Cross-Functional Collaboration: Serve as a subject matter expert for data flows and usage, bridging communication between business stakeholders in Finance, Risk, and Operations and the technical teams.
• Documentation & Innovation: Maintain comprehensive data architecture and model documentation, including lineage and business definitions. Leverage modern tooling and generative AI to accelerate development, documentation, and knowledge acquisition.
• Internal Compliance: Stay adjourned and adhere to the latest AML/CFT policies and procedures.

Qualifications and skills:

• Education: Bachelor's degree in Computer Science, Data Management, or a related quantitative field.
• Experience: 7–10 years hands-on data modelling experience with at least 5 years in financial services sector.
• Financial Expertise: Strong understanding of financial instruments, accounting flows, banking, finance, and risk data models.
• Comfortable using generative AI tools (e.g., ChatGPT, Gemini, Copilot, etc.) to bridge knowledge gaps, create documentation templates, and accelerate learning and execution.
• Agile Approach: Experience working within an Agile framework is a plus.
• Technical Skills: Expert proficiency in conceptual, logical, and physical data modeling. Hands-on experience with dimensional modeling (star, snowflake), data warehousing concepts, and advanced SCD strategies.
• Tooling: Skilled with professional data modeling tools such as Erwin or PowerDesigner.
• Soft Skills: Strong analytical mindset, excellent communication skills, and a collaborative approach to integrate diverse stakeholder needs.
• Regulatory Knowledge: Familiarity with key financial reporting and regulatory requirements such as IFRS9, BASEL, etc. is a plus.
• Tooling: Knowledge and experience of ETL tools is a plus