Data Modeler

Project overview

Job Title: Data Modeler - Banking Client- In Person Interview

Project details

Charlotte, NC (Hybrid 3 days office in a week)

12Months+

GC, EAD and US Citizens Only (Local Candidates based in NC only)

Note: Looking for candidate who are willing to go for In person Interview.

Interview Process

The interview process will consist of 3 stages:

Key Responsibilities

Required Qualifications

If this position is of interest to you, apply now!

• Teams interview with the consulting/implementation partner
• Teams interview with the financial-services client
• Face-to-face interview with the financial-services client
• Design and maintain conceptual, logical, and physical data models for enterprise applications, data warehouses, data lakes, and analytical platforms.
• Translate business requirements into robust, scalable, and governed data structures.
• Develop dimensional models, including star and snowflake schemas, fact tables, dimension tables, and slowly changing dimensions.
• Define data entities, attributes, relationships, keys, constraints, business rules, and data definitions.
• Collaborate with business analysts, data architects, solution architects, developers, data engineers, and product teams.
• Analyze existing databases and applications to identify data gaps, redundancies, quality issues, and opportunities for optimization.
• Create and maintain data dictionaries, metadata repositories, source-to-target mappings, and data lineage documentation.
• Ensure data models comply with enterprise architecture, security, privacy, regulatory, and data governance standards.
• Support data integration, ETL/ELT, master data management, and reporting requirements.
• Review and optimize database structures for performance, scalability, maintainability, and usability.
• Participate in data migration, modernization, and cloud transformation initiatives.
• Work with database administrators and engineering teams on schema design, indexing, partitioning, normalization, and denormalization strategies.
• Establish and promote data modeling standards, naming conventions, templates, and best practices.
• Conduct design reviews and provide guidance and mentoring to junior data modelers and data professionals.
• Support impact analysis and change management for data model and schema changes.
• Troubleshoot data-related issues and assist teams in resolving data inconsistencies and integration challenges.
• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
• 8+ years of experience in data modeling, database design, data architecture, or a related discipline.
• Strong experience in:
• Conceptual, logical, and physical data modeling
• Relational and dimensional modeling
• Data warehouse and data mart design
• Data normalization and denormalization
• Metadata management and data documentation
• Proficiency with SQL and relational databases such as:
• Oracle
• SQL Server
• PostgreSQL
• MySQL
• Teradata or equivalent
• Experience with data modeling tools such as Erwin, ER/Studio, IBM InfoSphere Data Architect, SAP PowerDesigner, or similar tools.
• Strong understanding of database architecture, data integration, ETL/ELT processes, and data quality concepts.
• Experience working with cloud data platforms such as Snowflake, AWS Redshift, Azure Synapse, Google BigQuery, or Databricks.
• Knowledge of data governance, data security, privacy, master data management, and regulatory compliance.
• Ability to understand complex business processes and convert them into effective data models.
• Excellent communication, documentation, analytical, and stakeholder management skills.
• Start: flexible
• Remote: hybrid
• Location: Charlotte, GB