Enterprise Data Modeler

About Us: Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professionals constantly strive to bring together the best technologies available to manage client's complex business and technology, participate in implementation activities and collaborate in new ways to meet client needs. We provide excellent benefits such as Medical, Dental, Vision ++ a fun company to work!!! Job Description: Client - Virginia Department of Transportation (VDOT)Duration - 12+ MonthsLocation - 1401 E Broad St, Richmond, VAJob Nature - Hybrid (2 to 3 Days Onsite in a week) 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 and 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 a strategic approach. Perform data profiling and analysis for maintaining data models. Develop and support the usage of MDM toolkit and 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 with the 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. Skills Matrix: 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 and 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. 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 help to establish, modify and maintain data model. Required: 10 Years Analyze data-related system integration challenges and propose appropriate solutions with a strategic approach. Required: 10 Years Perform data profiling and analysis for maintaining data models. Develop and support the usage of MDM toolkit and integrate source systems into the MDM solution. 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 #J-18808-Ljbffr

Created: 2025-02-08