Senior Data Modeler: Banking Data Warehouse & Modeling

Vallum Associates; Charlotte (NC); Hybride; USD 110 000 - 140 000; Plein temps

Résumé du poste

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.

Responsabilités

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

Connaissances

Data modeling

Dimensional modeling

SQL proficiency

Data warehousing

Data governance

Cloud data platforms

Normalization/denormalization

ETL/ELT understanding

Communication

Formation

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

Outils

Erwin

ER/Studio

IBM InfoSphere Data Architect

SAP PowerDesigner

Description du poste

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.