Data Modeler

VSG Business Solutions LLC; Charlotte (NC); On-site; USD 120,000 - 170,000; Full time

Job summary

VSG Business Solutions LLC is seeking an experienced Data Modeler to design and maintain enterprise data models for banking and financial services. You will work across regulatory reporting, risk management, analytics, lending and deposits, ensuring consistency with data governance standards.

You will collaborate with architects, analysts and developers to translate requirements into robust models, manage metadata, and support cloud migration and data warehousing initiatives, delivering

Qualifications

• 8+ years of experience in Data Modeling for Banking/Financial Services.
• Deep knowledge of conceptual, logical, and physical data models.
• Proficient with major data modeling tools.
• Experience with data governance and data quality frameworks.

Responsibilities

• Design and develop enterprise data models for banking applications.
• Collaborate with stakeholders to translate business requirements into scalable data models.
• Create and maintain data dictionaries, metadata, data lineage, and data mappings.
• Ensure data models align with enterprise architecture standards and 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 for performance, scalability, and data quality.
• Participate in regulatory reporting initiatives.
• Conduct data modeling reviews and enforce best practices across projects.
• Work with data governance teams to ensure data consistency and quality.

Skills

Data Modeling

Banking domain

SQL

Modeling levels

ETL/ELT

Cloud platforms

Tools

ERwin

ER Studio

SAP PowerDesigner

IBM Data Architect

Job description

Job Overview

We are seeking an experienced Data Modeler with strong expertise in the Banking and Financial Services domain. The ideal candidate will be responsible for designing, developing, and maintaining enterprise data models that support regulatory reporting, risk management, customer analytics, lending, deposits, and other banking initiatives. The candidate should have strong knowledge of data warehousing concepts, data governance, and banking data structures.

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.