Description

Key Responsibilities

• Design and develop conceptual, logical, and physical data models for enterprise banking applications.
• Collaborate with business stakeholders, data architects, analysts, and development teams to translate business requirements into scalable data models.
• Create and maintain data dictionaries, metadata, data lineage, and data mapping documentation.
• Ensure data models align with enterprise architecture standards and data governance policies.
• Support data integration, data warehousing, and cloud migration initiatives.
• Analyze source systems and define data transformation rules for ETL/ELT processes.
• Optimize database structures to improve performance, scalability, and data quality.
• Participate in regulatory and compliance reporting initiatives.
• Conduct data modeling reviews and enforce best practices across projects.
• Work closely with data governance teams to ensure data consistency and quality.

Required Skills

• 8+ years of experience in Data Modeling within the Banking or Financial Services industry.
• Strong expertise in Conceptual, Logical, and Physical Data Modeling.
• Hands-on experience with data modeling tools such as ERwin, ER Studio, SAP PowerDesigner, or IBM Data Architect.
• Strong SQL skills and experience with relational databases such as Oracle, SQL Server, PostgreSQL, or Teradata.
• Experience with Data Warehousing, ETL/ELT processes, and dimensional modeling (Star/Snowflake Schema).
• Knowledge of Banking data domains such as:
  • Loans & Mortgages
  • Deposits
  • Customer Information Management
  • Payments & Transactions
  • Risk & Compliance
  • Regulatory Reporting
• Experience with cloud platforms such as AWS, Azure, or GCP.
• Strong understanding of data governance, metadata management, and data quality frameworks.

Preferred Skills

• Experience with regulatory reporting frameworks such as FR Y-14, Basel III, CCAR, CECL, AML, or BCBS 239.
• Knowledge of Big Data technologies (Spark, Hadoop) and Cloud Data Warehousing solutions.
• Familiarity with Informatica, Collibra, Alation, or other governance tools.
• Banking modernization, data migration, or digital transformation experience.
• Excellent communication and stakeholder management skills

Key Skills

Education

Bachelor's degree