Virtusa - Data Modeler - Erwin

Description :

A Data Modeler with erwin for Retail Banking is a specialized role responsible for designing, developing, and maintaining complex data models tailored specifically to the unique needs of a retail banking environment, utilizing the erwin Data Modeler tool. This role ensures that data structures support core banking functions, regulatory compliance, and business analytics.

Key Responsibilities :

- Banking-Specific Data Model Design : Design and create conceptual, logical, and physical data models for retail banking systems, including core banking platforms, customer relationship management (CRM), anti-money laundering (AML), loan origination, and credit card processing systems.

- Regulatory & Compliance Modeling : Ensure all data models adhere to stringent banking regulations, such as Basel III, BCBS 239, GDPR, and local financial compliance laws, incorporating necessary fields for risk reporting and auditing.

- Business Requirements Analysis : Collaborate with product teams, risk management, finance departments, and compliance officers to gather and analyze data requirements specific to retail banking operations (e.g., customer accounts, transactions, loan products, mortgage data).

- Metadata Management & Data Lineage : Utilize erwin DM and the erwin Mart to manage the repository of banking data assets. Develop and maintain robust data dictionaries and detailed data lineage from source systems (like teller systems or online banking apps) to target analytics platforms.

- Database Implementation & Optimization : Work with DBAs and data engineers to implement physical models across various platforms (e.g., Oracle, SQL Server, Snowflake), ensuring high performance and data integrity for high-volume transaction processing systems.

- Forward & Reverse Engineering : Employ erwins capabilities to reverse engineer legacy banking systems to ensure proper documentation, and forward engineer new systems to replace outdated structures.

- Data Quality Assurance : Implement data governance frameworks within the models to ensure data accuracy, consistency, and completeness of sensitive financial data.

Required Qualifications and Skills :

- Technical Proficiency with erwin DM : In-depth, hands-on expertise in using erwin Data Modeler for the entire data modeling lifecycle.

- Banking Domain Knowledge (Mandatory) : Extensive experience within the retail banking or financial services industry, understanding core functions, processes, and industry data standards (e.g., BIAN or ISO 20022).

- Data Modeling Methodologies : Strong understanding of dimensional modeling, 3rd Normal Form, and best practices for both OLTP and OLAP environments.

- Regulatory Reporting Knowledge : Familiarity with the data requirements for financial regulatory reporting.

- SQL & Database Expertise : Strong proficiency in SQL and experience with major RDBMS platforms common in banking environments.

- Communication : Excellent interpersonal skills to facilitate modeling sessions with diverse banking stakeholders.

- Education/Experience : A Bachelor's or Master's degree in a relevant field, coupled with significant experience as a data modeler in a financial institution.