Data Modeler- Banking Client- In Person Interview
Vallum Associates · Charlotte, North Carolina, United States
FULL TIME
Job Description
Job Title: Data Modeler- Banking Client- In Person InterviewLocation: 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 ProcessThe interview process will consist of 3 stages:Teams interview with the consulting/implementation partnerTeams interview with the financial-services clientFace-to-face interview with the financial-services clientKey ResponsibilitiesDesign 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 QualificationsBachelor’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 modelingRelational and dimensional modelingData warehouse and data mart designData normalization and denormalizationMetadata management and data documentationProficiency with SQL and relational databases such as:OracleSQL ServerPostgreSQLMySQLTeradata or equivalentExperience 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. xzbcwsv Excellent communication, documentation, analytical, and stakeholder management skills.
Priyanka SharmaSenior Delivery ConsultantOffice: Email:
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 ProcessThe interview process will consist of 3 stages:Teams interview with the consulting/implementation partnerTeams interview with the financial-services clientFace-to-face interview with the financial-services clientKey ResponsibilitiesDesign 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 QualificationsBachelor’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 modelingRelational and dimensional modelingData warehouse and data mart designData normalization and denormalizationMetadata management and data documentationProficiency with SQL and relational databases such as:OracleSQL ServerPostgreSQLMySQLTeradata or equivalentExperience 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. xzbcwsv Excellent communication, documentation, analytical, and stakeholder management skills.
Priyanka SharmaSenior Delivery ConsultantOffice: Email:
Details
| Company | Vallum Associates |
| Location | Charlotte, North Carolina, United States |
| Type | FULL TIME |
| Niche | finance |
Similar Jobs