Data Modeler- Banking Client- In Person Interview

Vallum Associates; Charlotte (NC); Hybrid; USD 110,000 - 140,000; Full time

Job summary

Vallum Associates in Charlotte, NC is seeking an experienced Data Modeler to design and maintain enterprise data models for analytics platforms. You will translate business requirements into robust, scalable data structures and collaborate with data engineers, architects, and product teams.

The role involves developing dimensional models, maintaining data dictionaries, and ensuring governance and security standards across data environments.

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.
• Metadata management and data documentation.
• Proficiency with SQL and major relational databases (Oracle, SQL Server, MySQL, Teradata).
• Experience with cloud data platforms (Snowflake, AWS Redshift, Azure Synapse, Google BigQuery, Databricks).
• Knowledge of data governance, data security, privacy, and regulatory compliance.
• Ability to translate complex business processes into effective data models.
• Excellent communication and stakeholder management.

Responsibilities

• Design and maintain conceptual, logical, and physical data models for enterprise applications and analytics.
• Translate business requirements into scalable, governed data structures.
• Develop dimensional models including star and snowflake schemas.
• Define data entities, attributes, keys, constraints, and data definitions.
• Collaborate with analysts, architects, developers, and product teams.
• Analyze databases to identify data gaps and quality issues.
• Create data dictionaries, metadata repositories, and data lineage documentation.
• Ensure models comply with enterprise architecture, security, and governance standards.
• Support data integration, ETL/ELT, and data migration initiatives.
• Review and optimize database structures for performance and maintainability.

Skills

Data modeling

Dimensional modeling

SQL proficiency

Data warehousing

Data governance

Cloud data platforms

Normalization/denormalization

ETL/ELT understanding

Communication

Education

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field

Tools

Erwin

ER/Studio

IBM InfoSphere Data Architect

SAP PowerDesigner

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:

• 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
• 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.