Enterprise Data Modeler

Job Description

Job Location : Richmond, VA, Hybrid.

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.

VDOT Enterprise Data Modeler.

• 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

Responsibilities :

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

Requirements

Skills Set : Skill Required / Desired Experience Experience as a Business Analyst on PeopleSoft HCM on implementation or upgrade projects Required 8 years Experience with PeopleSoft HCM 9.2 Payroll or Time & Labor Required 8 years Experience as a Business Analyst in identifying requirements and creating formal functional documents for key business stakeholders and SMEs Required 8 years Experience as a Business Analyst in conducting formal work sessions and functional analysis presentations Required 8 years Experience in performing hands-on end-to-end system integration and external interface testing Required 8 years at least 4) Experience with Microsoft O365 applications (Word, Excel, PowerPoint, Teams, Visio) Required 8 years Experience working with a public sector organization (Federal, State, or Local Government) Required 4 years Experience working with the Comptroller of Public Accounts (CPA) CAPPS Financials Required 2 years Experience with PeopleSoft HCN 9.2 Payroll or Time & Labor Required 2 years Experience with PeopleSoft Approval Workflow Engine (AWE) Required 2 years Experience with SharePoint Required 2 years Experience with Jira Required 1 year Experience working with the Scrum framework Required 1 year