Explore 1M+ Live Opportunities.
Direct applications, high-package MNC listings, and exclusive insider referrals updated daily across 50+ niches worldwide.
Live Jobs|Remote & Onsite|Apply in 1 Click
Join Our WhatsApp Job ChannelDirect applications, high-package MNC listings, and exclusive insider referrals updated daily across 50+ niches worldwide.
Vallum Associates · Charlotte, North Carolina
Job Title: Data Modeler- Banking Client- In Person Interview
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
Teams interview with the consulting/implementation partner
Teams interview with the financial-services client
Face-to-face interview with the financial-services client
Key
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
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.
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
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.
Priyanka Sharma
Senior Delivery Consultant
Office: 020 4514 3823
Email: psharma@vallumassociates.com
Details
| Company | Vallum Associates |
| Location | Charlotte, North Carolina |
| Type | FULL TIME |
| Niche | Database designers and administrators |