Data Modeler- Banking Client- In Person Interview

Job Description

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

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

Duration: 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 :

\n
1. Teams interview with the consulting/implementation partner
\n
2. Teams interview with the financial-services client
\n
3. Face-to-face interview with the financial-services client
\n

Key Responsibilities

\n
• Design and maintain conceptual, logical, and physical data models for enterprise applications, data warehouses, data lakes, and analytical platforms.
\n
• Translate business requirements into robust, scalable, and governed data structures.
\n
• Develop dimensional models , including star and snowflake schemas, fact tables, dimension tables, and slowly changing dimensions.
\n
• Define data entities, attributes, relationships, keys, constraints, business rules, and data definitions.
\n
• Collaborate with business analysts, data architects, solution architects, developers, data engineers, and product teams.
\n
• Analyze existing databases and applications to identify data gaps, redundancies, quality issues, and opportunities for optimization.
\n
• Create and maintain data dictionaries, metadata repositories, source-to-target mappings, and data lineage documentation .
\n
• Ensure data models comply with enterprise architecture, security, privacy, regulatory, and data governance standards.
\n
• Support data integration, ETL/ELT, master data management, and reporting requirements.
\n
• Review and optimize database structures for performance, scalability, maintainability, and usability.
\n
• Participate in data migration, modernization, and cloud transformation initiatives.
\n
• Work with database administrators and engineering teams on schema design, indexing, partitioning, normalization, and denormalization strategies.
\n
• Establish and promote data modeling standards, naming conventions, templates, and best practices.
\n
• Conduct design reviews and provide guidance and mentoring to junior data modelers and data professionals.
\n
• Support impact analysis and change management for data model and schema changes.
\n
• Troubleshoot data-related issues and assist teams in resolving data inconsistencies and integration challenges.
\n

Required Qualifications

\n
• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
\n
• 8+ years of experience in data modeling, database design, data architecture, or a related discipline.
\n
• Strong experience in:
\n
• Conceptual, logical, and physical data modeling
\n
• Relational and dimensional modeling
\n
• Data warehouse and data mart design
\n
• Data normalization and denormalization
\n
• Metadata management and data documentation
\n
• Proficiency with SQL and relational databases such as:
\n
• Oracle
\n
• SQL Server
\n
• PostgreSQL
\n
• MySQL
\n
• Teradata or equivalent
\n
• Experience with data modeling tools such as Erwin, ER/Studio, IBM InfoSphere Data Architect, SAP PowerDesigner, or similar tools .
\n
• Strong understanding of database architecture, data integration, ETL/ELT processes, and data quality concepts.
\n
• Experience working with cloud data platforms such as Snowflake, AWS Redshift, Azure Synapse, Google BigQuery, or Databricks .
\n
• Knowledge of data governance, data security, privacy, master data management, and regulatory compliance.
\n
• Ability to understand complex business processes and convert them into effective data models.
\n
• Excellent communication, documentation, analytical, and stakeholder management skills.
\n

Priyanka Sharma

Senior Delivery Consultant

Office: 020 4514 3823

Email: View email address on ziprecruiter.com