Data Modeler

Database Modeler ServicesLocation: 4052 Bald Cypress Way Tallahassee, FL 32399 (Onsite)Type: C2C/W2Duration: Long termPurpose: This scope of work is for Data Modeler services to support the centralization and cloud-modernization of the Department’s Health Management System (HMS). Contractor will provide these services to the Florida Department of Health (Department).Contractor Qualifications and Experience:A minimum of 5 years of demonstrated experience using master data management (MDM) tools and platforms, such as Informatica MDM, IBM InfoSphere, SAP Master Data Governance, or others. Familiarity with configuring, customizing, and managing these tools is required.A minimum of 5 years of documented experience data modeling, database design, and familiarity with various database technologies, both traditional (like SQL databases) and modern (like object-oriented (IRIS/Cache, NoSQL databases)).A minimum of 2 years of documented experience with cloud platforms such as Amazon Web Services (AWS), Azure, or Google Cloud, including knowledge of cloud-based data storage, processing, and management services.Documented experience in integrating data from various sources into a centralized system, including migrating data to cloud environments, while ensuring data quality and consistency.Comprehensive knowledge of MDM principles, practices, and technologies. This includes the lifecycle of master data, data governance, data quality, data stewardship, and data integration.Knowledge of data governance frameworks and compliance regulations, like the Health Insurance Portability Accountability Act (HIPAA), relevant to data management and privacy.Contractor Responsibilities:Service Tasks: Contractor will perform the following tasks in the time and manner specified:Develop and maintain the data dictionary for the HMS at the direction of the Department. Fully define all data elements including detailed description, purpose, business constraints, and relationships to other elements. Develop and enforce naming conventions and data standards to ensure consistency across the application. This may include standard formats for dates, monetary values, or unique identifiers. Ensure that the data dictionary is integrated into the software development lifecycle. It shall be a reference point for developers, database administrators, and analysts during design, development, and testing phases. Implement processes to ensure the data dictionary is up to date with any changes to the application’s data structure or business rules as directed by the Department. This includes adding new data elements, modifying existing ones, or removing obsolete ones. Implement version control and change management processes to track changes made to the data dictionary over time. Ensure the data dictionary is accessible to all relevant stakeholders, including development teams, database administrators, business analysts, Department Program Areas, and HMS end users as directed by the Department.Provide subject matter expertise for the implementation of a master patient index (MPI) for the HMS at the direction of the Department. Evaluate the HMS to understand its structure, data quality, integration points, and existing data issues and limitations. Collaborate with the Centralization of HMS (CHMS) Project Team to define and implement processes to standardize and clean patient data to ensure accuracy and consistency. This involves resolving duplicate records, correcting errors, and ensuring data conforms to defined standards. Develop data governance policies specific to patient data, focusing on data quality, privacy, and security, especially in compliance with healthcare regulations like HIPAA. In collaboration with the CHMS Team, provide subject matter expertise to design the architecture of the MPI system for a cloud environment, ensuring it is scalable, secure, and compliant with healthcare standards. Apply advanced MDM techniques to manage and maintain the integrity of patient data across systems. This includes implementing rules for data matching, merging, and linking patient records.Develop and define a master data management strategy that aligns with the Department’s HMS centralization and modernization objectives as directed by Department. Perform data assessment specifically identifying data quality issues, inconsistencies, and redundancies across the HMS Databases. Define quality control strategies for monitoring the consolidation of HMS databases. Define and implement processes to manage the deduplication of patient records. Complete job-required training as assigned by the Department. Submit verification of completion for each training (i.e. completed sign-in sheet, certification of completion, etc.) to the Department Contract Manager as directed by the Department. The Contractor, its employees, subcontractors, and agents must comply at all times with all Department data security procedures and policies in the performance of this scope of work as specified in the Data Security and Confidentiality document attached to the purchase order.