Enterprise Data Modeler

Richmond, United States Posted on 08 / 01 / 2024

Are you the right applicant for this opportunity Find out by reading through the role overview below.

Job Location : Available to work Hybrid, Richmond, VA. (3 days On-site)

Job Description : Responsibilities :

Responsibilities :

• Create conceptual data model to identify key business entities and visualize their relationships, define concepts and rules.
• Translate business needs into data models, build logical and physical data models for client hierarchy, document data designs for team.
• Present and communicate modeling results and recommendations to internal stakeholders and development teams and explain features that may affect the physical data model.
• Ensure and enforce a governance process to oversee implementation activities and ensure alignment to the defined architecture.
• Perform data profiling / analysis activities that help to establish, modify and maintain data model.
• Develop canonical models, Data as a Service models and knowledge of SOA to support integrations.
• Analyze data-related system integration challenges and propose appropriate solutions with strategic approach.
• Perform data profiling and analysis for maintaining data models, develop and support the usage of MDM toolkit, integrate source systems into the MDM solution, implement business rules for data reconciliation and deduplication, enforce data models and naming standards across deliverables.
• Establish processes for governing the identification, collection, and use of corporate metadata; take steps to assure metadata accuracy and validity.
• Establish methods and procedures for tracking data quality, completeness, data redundancy, and improvement.
• Conduct data capacity planning, lifecycle, duration, usage requirements, feasibility studies, and other tasks.
• Create strategies and plans for data security, backup, disaster recovery, business continuity, and archiving. Ensure that data strategies and architectures are in regulatory compliance.
• Good knowledge of applicable data privacy practices and laws.
• Strong written and oral communication skills, strong presentation and interpersonal skills, and ability to present ideas in user-friendly language.
• Experience in writing queries (SQL, Python, R, Scala) as needed and experience with various data technologies such as Azure Synapse or SQL Server, Snowflake, Databricks.

Requirements

Skills Set :

Skill : Create conceptual data model to identify key business entities and visualize their relationships, define concepts and rules.

Required / Desired : Required

Skill : Translate business needs into data models, build logical and physical data models for client hierarchy, document data designs for team.

Required / Desired : Required

Skill : Present and communicate modeling results and recommendations to internal stakeholders and development teams and explain features that may affect the physical data model.

Required / Desired : Required

• Skill : Develop canonical models, Data as a Service models and knowledge of SOA to support integrations. Required / Desired : Required
• Skill : Perform data profiling / analysis activities that help to establish, modify and maintain data model. Required / Desired : Required
• Skill : Analyze data-related system integration challenges and propose appropriate solutions with strategic approach. Required / Desired : Required
• Skill : Perform data profiling and analysis for maintaining data models, develop and support the usage of MDM toolkit, integrate source systems into the MDM solution.

Required / Desired : Required

Skill : Implement business rules for data reconciliation and deduplication, enforce data models and naming standards across deliverables.

Required / Desired : Required

Skill : Establish processes for governing the identification, collection, and use of corporate metadata; take steps to assure metadata accuracy and validity.

Required / Desired : Required

• Skill : Establish methods and procedures for tracking data quality, completeness, data redundancy, and improvement. Required / Desired : Required
• Skill : Conduct data capacity planning, lifecycle, duration, usage requirements, feasibility studies, and other tasks.

Required / Desired : Required

J-18808-Ljbffr