WNS (Holdings) Limited (NYSE: WNS), is a leading Business Process Management (BPM) company. We combine our deep industry knowledge with technology and analytics expertise to co-create innovative, digital-led transformational solutions with clients across 10 industries. We enable businesses in Travel, Insurance, Banking and Financial Services, Manufacturing, Retail and Consumer Packaged Goods, Shipping and Logistics, Healthcare, and Utilities to re-imagine their digital future and transform their outcomes with operational excellence.We deliver an entire spectrum of BPM services in finance and accounting, procurement, customer interaction services and human resources leveraging collaborative models that are tailored to address the unique business challenges of each client. We co-create and execute the future vision of 400+ clients with the help of our 62,000+ employees.

 This is a Fixed Term Contract Role with WNS for 1 year

Job Summary:

We are seeking a Senior Hands-on Data Modeler/Data Architect with 10+ years of experience in SQL-based 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.
 

• 10+ years of hands-on 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.

 

• 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.