Enterprise Data Modeler

Overview

On Site
USD 1-1
Full Time
Part Time
Accepts corp to corp applications
Contract - W2
Contract - Independent

Skills

Enterprise Data Modeler
Data Modeling
Conceptual Data Models
Logical Data Models
Physical Data Models
Data Assets
Data Flows
Data Governance
Metadata Management
Canonical Models
Data as a Service
SOA
Data Profiling
Data Analysis
Master Data Management (MDM)
Data Reconciliation
Data Deduplication
Naming Standards
Data Quality
Data Completeness
Data Redundancy
Data Lifecycle Management
Data Capacity Planning
Data Security
Data Backup
Disaster Recovery
Business Continuity
Data Archiving
Data Privacy
SQL
Python
R
Scala
Azure Synapse
SQL Server
Snowflake
Databricks
Cloud Data Management
System Integration
Variance Analysis
Data Optimization
Metadata Accuracy
Regulatory Compliance
Stakeholder Communication
Presentation Skills
Richmond VA
Onsite Requirement
VDOT IT
Senior Data Modeler.

Job Details

Enterprise Data Modeler


The Client is seeking a senior Data modeler to develop Data models for Data Assets and implementation of a cloud-based data management platform that will support the agency.

Enterprise data modeler provides expert support across the enterprise information framework, analyze and translate business needs into long-term solution data models by evaluating existing systems and working with a business and data architect to create conceptual data models , data flows . Develop best practices for Data Asset development, ensure consistency within the system and review modifications of existing cross-compatibility systems. Optimize data systems and evaluate implemented systems for variance discrepancies and efficiency. Maintain logical and physical data models along with accurate metadata.

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 explains 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 helps 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, life cycle, 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

*local Richmond, VA candidates required

*candidate will be required to interview ONSITE, NO exceptions

*candidate will be required to work ONSITE 2-3 days/wk

*the contract may be extended annually beyond June 30, 2026

*Contractor will be responsible for purchasing parking through VDOT's Parking Management Office or procuring their own parking

Required/Desired Skills

Skill Required/Desired Amount of Experience
Create conceptual data model to identify key business entities and visualize their relationships, define concepts and rules. Required 10 Years
Translate business needs into data models Build logical and physical data models for client hierarchy Document data designs for team. Required 10 Years
Present and communicate modeling results and recommendations to internal stakeholders and Development teams and explains features that may affect th Required 10 Years
Develop canonical models, Data as a service models and Knowledge of SOA to support integrations. Required 10 Years
Perform data profiling/analysis activities that helps to establish, modify and maintain data model Required 10 Years
Analyze data-related system integration challenges and propose appropriate solutions with strategic approach. Required 10 Years
Perform data profiling and analysis for maintaining data models Develop and support the usage of MDM toolkit Integrate source systems into the MDM sol Required 10 Years
Implement business rules for data reconciliation and deduplication Enforce data models and naming standards across deliverables. Required 10 Years
Establish processes for governing the identification, collection, and use of corporate metadata; take steps to assure metadata accuracy and validity Required 10 Years
Establish methods and procedures for tracking data quality, completeness, data redundancy, and improvement. Required 10 Years
Conduct data capacity planning, life cycle, duration, usage requirements, feasibility studies, and other tasks. Required 10 Years
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About OP Consulting Group LLC