Data Modeler

Job Title: Data Modeler

Location: Charlotte, NC

Work Arrangement: Hybrid—3 days per week onsite

Duration: Long-Term Contract on W2

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.