Demo

VDOT Enterprise Data Modeler

Cyber Resource
Richmond, VA Full Time
POSTED ON 3/19/2025
AVAILABLE BEFORE 4/18/2025

Engagement Type

Contract

Short Description

VDOT Enterprise Data Modeler

Complete Description

  • 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, 2025
  • Contractor will be responsible for purchasing parking through VDOT's Parking Management Office or procuring their own parking

Job Description : Enterprise Data Modeler

The Virginia Department of Transportation (VDOT) Information Technology Division 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
  • 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

    Years

    Translate business needs into data models Build logical and physical data models for client hierarchy Document data designs for team.

    Required

    Years

    Present and communicate modeling results and recommendations to internal stakeholders and Development teams and explains features that may affect th

    Required

    Years

    Develop canonical models, Data as a service models and Knowledge of SOA to support integrations.

    Required

    Years

    Perform data profiling / analysis activities that helps to establish, modify and maintain data model

    Required

    Years

    Analyze data-related system integration challenges and propose appropriate solutions with strategic approach.

    Required

    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

    Years

    Implement business rules for data reconciliation and deduplication Enforce data models and naming standards across deliverables.

    Required

    Years

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

    Years

    Establish methods and procedures for tracking data quality, completeness, data redundancy, and improvement.

    Required

    Years

    Conduct data capacity planning, life cycle, duration, usage requirements, feasibility studies, and other tasks.

    Required

    Years

    Questions

    Description

    Question 1

    Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment?

    Question 2

    Please list candidate's email address.

    Question 3

    In what city and state does your candidate PERMANENTLY reside?

    Question 4

    Is your candidate willing to interview ONSITE? This is REQUIRED, NO exceptions.

    Question 5

    Is your candidate willing to work on customer site approximately 2 to 3 days a week? This is REQUIRED, NO exceptions.

    Question 6

    How soon after an offer can your candidate start?

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a VDOT Enterprise Data Modeler?

    Sign up to receive alerts about other jobs on the VDOT Enterprise Data Modeler career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $147,901 - $186,323
    Income Estimation: 
    $89,551 - $118,439
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $124,724 - $161,246
    Income Estimation: 
    $81,769 - $104,543
    Income Estimation: 
    $89,551 - $118,439
    Income Estimation: 
    $103,228 - $139,671
    Income Estimation: 
    $124,724 - $161,246
    Income Estimation: 
    $147,901 - $186,323
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $147,901 - $186,323
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Cyber Resource

    Cyber Resource
    Hired Organization Address Richmond, VA Full Time
    Engagement Type Contract Short Description Replacing 751727 Duration : expected to extend add'l 6mo after April 30 Secur...
    Cyber Resource
    Hired Organization Address Anthony, KS Full Time
    Role : GIS Developer Positions : 1 Location : Richmond VA Work mode : Hybrid Interview : Both Web Cam and In Person Inte...
    Cyber Resource
    Hired Organization Address Richmond, VA Full Time
    Engagement Type Contract Short Description VDOT - Senior Analyst - Microsoft Power Apps and\nAutomate n This requires ca...
    Cyber Resource
    Hired Organization Address Richmond, VA Full Time
    Engagement Type Contract Short Description TAX - AWS Security Architect ON SITE : minimum 3 days a week required Complet...

    Not the job you're looking for? Here are some other VDOT Enterprise Data Modeler jobs in the Richmond, VA area that may be a better fit.

    VDOT Enterprise Data Modeler

    Koios Systems and Technology, Richmond, VA

    VDOT Enterprise Data Modeler

    TMS, Richmond, VA

    AI Assistant is available now!

    Feel free to start your new journey!