About this opportunity
Vallum Associates lists this Data Modeler- Banking Client- In Person Interview opportunity in charlotte, North Carolina. Review the employer’s description below for duties, qualifications and application requirements.
Job description
Job Title: Data Modeler- Banking Client- In Person Interview
Location: Charlotte, NC (Hybrid 3 days office in a week)
Duration: 12Months+
If the following job requirements and experience match your skills, please ensure you apply promptly.
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 :
Teams interview with the consulting/implementation partner
Teams interview with the financial-services client
Face-to-face interview with the financial-services client
Key Responsibilities
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.
Required Qualifications
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. xhqgsiq
Excellent communication, documentation, analytical, and stakeholder management skills.
Priyanka Sharma
Senior Delivery Consultant
Office:
Email:
Worksite address
charlotte, NC, 28269, US
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.