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 ProcessThe 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.
- Excellent communication, documentation, analytical, and stakeholder management skills.
If this position is of interest to you, apply now!
