VDOT Enterprise Data Modeler

VDOT Enterprise Data Modeler
VENDOR MAXIMUM SUBMITTAL RATE $$$/hr.


*local Richmond VA candidates required
*candidate will be required to interview ONSITE NO exceptions
*candidate will be required to work ONSITE 23 days/wk
*the contract may be extended annually beyond June 30 2024
*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 cloudbased 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 longterm 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 crosscompatibility 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 datarelated 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 userfriendly 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
SkillRequired /DesiredAmountof ExperienceCreate conceptual data model to identify key business entities and visualize their relationships define concepts and rules.Required10YearsTranslate business needs into data models Build logical and physical data models for client hierarchy Document data designs for team.Required10YearsPresent and communicate modeling results and recommendations to internal stakeholders and Development teams and explains features that may affect thRequired10YearsDevelop canonical models Data as a service models and Knowledge of SOA to support integrations. Required10YearsPerform data profiling/analysis activities that helps to establish modify and maintain data modelRequired10YearsAnalyze datarelated system integration challenges and propose appropriate solutions with strategic approach.Required10YearsPerform data profiling and analysis for maintaining data models Develop and support the usage of MDM toolkit Integrate source systems into the MDM solRequired10YearsImplement business rules for data reconciliation and deduplication Enforce data models and naming standards across deliverables.Required10Years Establish processes for governing the identification collection and use of corporate metadata; take steps to assure metadata accuracy and validityRequired10YearsEstablish methods and procedures for tracking data quality completeness data redundancy and improvement.Required10YearsConduct data capacity planning life cycle duration usage requirements feasibility studies and other tasks.Required10YearsExperience in ERWIN toolRequired10YearsExperience in NIEM modelRequired10Years
Questions
No.QuestionQuestion1Commonwealth 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 assignmentQuestion2Please list candidates email address.Question3In what city and state does your candidate PERMANENTLY reside Question4Is your candidate willing to interview ONSITE This is REQUIRED NO exceptions. Question5Is your candidate willing to work on customer site approximately 2 to 3 days a week This is REQUIRED NO exceptions.Question6How soon after an offer can your candidate start