Senior Hands-on Data Modeler SQL Banking Domain Preferred London or North Hampton - Fixed Term Contract
Senior Hands-on Data Modeler SQL Banking Domain Preferred London or North Hampton - Fixed Term Contract
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
This is a Fixed Term Contract Role with WNS for 1 year
Job Summary:
We are seeking a Senior Handson Data Modeler/Data Architect with 10 years of experience in SQLbased data modeling to design and implement robust data solutions. The ideal candidate will have a banking or financial services background ensuring data models align with industry best practices regulatory requirements and business needs.
Key Responsibilities
Lead the design development and maintenance of conceptual logical and physical data models for relational and dimensional databases.
Collaborate with business stakeholders data engineers and analysts to translate business requirements into optimized data structures.
Ensure data integrity consistency scalability and performance optimization in database designs.
Develop and maintain ER diagrams data dictionaries and metadata documentation.
Define data modeling best practices and enforce governance policies across the organization.
Work with ETL/ELT teams to ensure smooth integration of data pipelines with enterprise data models.
Conduct data profiling and analysis to identify inconsistencies redundancies and areas for improvement.
Implement data security and compliance measures in accordance with banking regulatory standards (e.g. BCBS 239 Basel IFRS GDPR).
Support data modernization efforts including cloud migration data lakehouse implementation and MDM initiatives.
Mentor junior data modelers and provide technical leadership in data architecture and design.
Qualifications :
10 years of handson experience in data modeling database architecture or data engineering.
Expertise in SQL including query optimization indexing partitioning and stored procedures.
Deep understanding of relational and dimensional data modeling (normalization denormalization star/snowflake schema).
Proficiency with data modeling tools such as Erwin ER/Studio or equivalent.
Strong knowledge of banking and financial data structures regulatory frameworks and reporting standards.
Experience in data governance metadata management and data lineage tracking.
Familiarity with cloud data platforms (AWS Redshift Azure Synapse Google BigQuery Snowflake).
Experience with ETL/ELT design data integration and data warehousing best practices.
Excellent communication stakeholder management and leadership skills.
Additional Information :
Strong background in banking financial services or fintech industries.
Experience with risk and compliance data models (Basel III IFRS 9/17 AML BCBS 239.
Knowledge of Data Vault modeling and modern data warehouse/lakehouse architectures.
Certifications in data modeling cloud databases or data governance (CDMP AWS/Azure certifications) are a plus.
Remote Work :
No
Employment Type :
Fulltime
Employment Type
Full-time
