Abacus
Name
DWC Modernization Sr Data Architect
RFP
no.
DOLIR-2502-62090-002
gency, State
Department of Labor & Industrial Relations (DOLIR), MO
rea/Service
Staffing
Location
Jefferson City, MO
Contract Duration
09/01/2025 - 06/30/2027
Release Date
06/06/2025
Q & A due Date
06/17/2025 5:00 PM CT
Budget
Pursuant to paragraph (2.9.3 b. 6) of the contract, all SOWs with a total firm, fixed price for all deliverables that is over $75,000 shall include a 10% holdback per deliverable, unless otherwise identified in the SOW. This holdback must be reflected in your SOW response's firm, fixed pricing, if applicable (SOW total price over $75,000). In order to address the holdback on any SOW bid over $75,000, your payment milestones should reflect 90% of the cost for each milestone and shall include the final payment milestone that represents 10% of the total price of your SOW bid.'
Bid due Date
06/20/2025 by 5:00 PM CT
SOW
The Missouri DOLIR Division of Workers' Compensation (DWC) is undertaking a comprehensive modernization of its legacy Workers' Compensation systems, including replacement of the AS/400-based AICS application with a new "DWC Work Comp Connect" solution. To achieve this, DWC seeks a
Senior Data Architect
to serve as a subject-matter expert (SME) and technical resource throughout the 21-month project (09/01/2025-06/30/2027).
Overall Objectives: Provide expert guidance in data architecture, master data management, and data governance for the entire DWC Modernization project. Ensure accurate, consistent, and complete master data across all new and existing DWC systems. Design and implement robust data migration, data integration, and data warehousing strategies, including end-to-end ETL processes. nalyze existing AICS AS/400 data structures and translate business/data requirements into a modernized relational/columnar data model compatible with AWS-hosted PostgreSQL, SQL Server, Amazon Aurora, and Dynamo DB. Key Responsibilities: Data Migration & ETL: • Oversee all data migration efforts: analyze current data (quality, structure, anomalies), develop transformation logic, and execute incremental/full data loads into new database schemas. • Evaluate existing migration tools; recommend and implement performance optimizations for large-scale data transfers. • Create and maintain data validation and exception reporting processes to ensure high data fidelity throughout migration. Master Data Management & Governance: • Define and standardize master data definitions, coordinate with DWC data stewards to cleanse, reconcile, and govern key entities (e.g., claimants, employers, providers). • Develop and enforce database system standards, data dictionaries, and comprehensive documentation for ongoing data stewardship. • Collaborate with business analysts to identify orphaned or invalid records; recommend remediation plans. Data Modeling & Architecture: • Create detailed logical and physical data models (e.g., using Visio, DataIO) to support the new DWC Work Comp Connect application. • Translate functional requirements from the "Future State Memo" into a normalized/denormalized database design that supports application performance, scalability, and reporting. • Establish and enforce database lifecycle management practices: plan and guide database engine upgrades, utility migrations, and configuration changes to optimize uptime and security. nalytics & Reporting Support: • Develop complex SQL queries to support ad hoc and scheduled reporting, ETL workflows, and automated job scheduling. • Monitor and benchmark database performance baselines, recommending infrastructure adjustments (storage, memory, indexing) as needed. • Serve as the SME for data delivery processes between various systems (e.g., UInteract, FileVine) via RESTful integrations. Technical Oversight & Collaboration: • Partner with DWC Modernization Project Director and ITSD Project Manager to review design decisions, identify technical risks, and ensure alignment with Missouri State security/compliance standards (FERPA, HIPAA, PII/PHI safeguards). • Provide weekly status reports (using ITSD Project Status Report template) detailing tasks completed, upcoming work, risks, and percent complete. Reports due each Monday by EOD. • Facilitate technical knowledge transfer: mentor/guide junior data engineers, collaborate with ITSD staff on development and test plan creation, and assist with defect logging/tracking. Compliance & Security: • Comply with all State security policies: maintain Active Directory credentials, use State-approved VDI or remote desktop methods, and ensure all development occurs on ITSD-provided infrastructure. • Guarantee all services are U.S.-based (no offshore resources). • Manage and secure State Data: enable nightly incremental data extracts to feed the State Data Warehouse, support end-of-contract data extraction (60-day window), and assist with routine extraction validation. Deliverables: Monthly Status Reports: Summarize weekly reports (per ITSD template) for each month (September 2025 through June 2027), delivered via PDAF process. Data Architecture Artifacts: • Logical and physical data models for AICS legacy and new Work Comp Connect schemas. • Data dictionaries, entity-relationship diagrams, and transformation logic documentation. ETL & Migration Scripts: Well-tested SQL/ETL code, quality assurance filters, and exception-handling logic. Master Data Governance Plan: Standardized definitions, data steward guidelines, and remediation procedures. Performance Baseline Reports: Database benchmark metrics and recommended infrastructure changes. Final Data Extract Packages: Complete, validated data extraction for archival and hand-off at project end (within 60 days post 06/30/2027). Staffing Types & Volume: One (1) Senior Data Architect (full-time allocation, U.S.-based) responsible for all data architecture and migration tasks outlined above. Submittal Requirement
Completed SOW Response Document:
Vendor sections of this SOW fully filled out, including signature block. Deliverable Payment Milestone Table (with firm-fixed prices per monthly status report deliverable, holdbacks if applicable). Contracting Resource Price Calculations Table (hourly rates × estimated hours for internal cost validation; note: State will pay per deliverable). Proposal Narrative:
pproach & Methodology (Exhibit A): Detailed plan for all tasks in Section 2 (data migration, modeling, governance, reporting). Personnel Qualifications & Biographies (Exhibit B): Resume/CV demonstrating &Client; 5 years' experience on large State government data modernization projects, familiarity with AICS or similar AS/400 systems, and mastery of PostgreSQL/Aurora/Dynamo DB on AWS. Relevant Company History & Experience (Exhibit C): Three (3) case studies on: State or higher-education data modernization involving AS/400 migration. Master data governance implementations with centralized data warehouses. Complex ETL and performance optimization on cloud-hosted databases (AWS). Participation Commitment (Exhibit D): MBE/WBE/SDVBE documentation, if applicable. Work Breakdown Structure (WBS): Gantt chart or similar illustrating tasks, milestones, and timelines aligned with Section 2 deliverables. Testing & Validation Plan: Description of how nightly incremental extracts, QA filters, and final data extraction will be validated. Security & Compliance Approach: Procedures for handling PII/PHI, ensuring U.S.-based development, and using State-provided environments. Resumes for Proposed Resource:
One (1) Senior Data Architect resume showing relevant certifications (e.g., Certified Data Management Professional, AWS Database Specialty) and &Client; 5 years' experience in State government or regulated environments. Licensing Confirmation:
Proof that Vendor will procure/maintain any required development tools and database licenses (e.g., Visio, DataIO, AWS account tools) for the duration of the contract. Submission Format & Requirements:
Electronic Submission Only: PDF format, emailed to sarah.j.mealy@oa.mo.gov by 06/20/2025 5:00 PM CT. Page Limits: Maximum of 50 pages for narrative/exhibits (resumes excluded). Font: 11 pt or larger for text; smaller fonts only in graphics/diagrams. No Embedded Files/Hyperlinks: Failure to comply may result in exclusion of non-compliant content from evaluation. Evaluation Criteria
Cost - 53 points pproach and Methodology for Scope of Work - 44 points Personnel Qualifications and Biographies - 49 points Company History and Experience - 44 points Potential bonus points if Exhibit D is completed: MBE/WBE Participation - 10 points Organization for the Blind/Sheltered Workshop Preference - 15 points MO Service-Disabled Veteran Business Preference - 3 points Total - 218 points
References
Three (3) relevant client references (State or higher-education data modernization)
Resumes required?
Yes - resume for the proposed Senior Data Architect (Exhibit B)
Rate card required
No traditional rate card. Pricing must be firm-fixed per deliverable (monthly status reports). Vendor must also submit "Contracting Resource Price Calculations" (hourly rate × estimated hours) for internal reference only.
ny specific requirement
ll services and resources must be provided in the United States. No offshore work permitted. Resource must comply with DOLIR/ITSD security policies, complete required trainings, and sign confidentiality agreements. Resource must possess &Client; 5 years' experience in data architecture and data modernization projects, with direct exposure to AS/400 AICS or similar. Vendor must maintain all necessary development licenses (e.g., Visio, DataIO, AWS tools) and coordinate environment access via State-provided Active Directory/VDI. Hardcopy/Email/portal submission
Email
Link
Via Email
DWC Modernization Sr Data Architect
RFP
no.
DOLIR-2502-62090-002
gency, State
Department of Labor & Industrial Relations (DOLIR), MO
rea/Service
Staffing
Location
Jefferson City, MO
Contract Duration
09/01/2025 - 06/30/2027
Release Date
06/06/2025
Q & A due Date
06/17/2025 5:00 PM CT
Budget
Pursuant to paragraph (2.9.3 b. 6) of the contract, all SOWs with a total firm, fixed price for all deliverables that is over $75,000 shall include a 10% holdback per deliverable, unless otherwise identified in the SOW. This holdback must be reflected in your SOW response's firm, fixed pricing, if applicable (SOW total price over $75,000). In order to address the holdback on any SOW bid over $75,000, your payment milestones should reflect 90% of the cost for each milestone and shall include the final payment milestone that represents 10% of the total price of your SOW bid.'
Bid due Date
06/20/2025 by 5:00 PM CT
SOW
The Missouri DOLIR Division of Workers' Compensation (DWC) is undertaking a comprehensive modernization of its legacy Workers' Compensation systems, including replacement of the AS/400-based AICS application with a new "DWC Work Comp Connect" solution. To achieve this, DWC seeks a
Senior Data Architect
to serve as a subject-matter expert (SME) and technical resource throughout the 21-month project (09/01/2025-06/30/2027).
Overall Objectives: Provide expert guidance in data architecture, master data management, and data governance for the entire DWC Modernization project. Ensure accurate, consistent, and complete master data across all new and existing DWC systems. Design and implement robust data migration, data integration, and data warehousing strategies, including end-to-end ETL processes. nalyze existing AICS AS/400 data structures and translate business/data requirements into a modernized relational/columnar data model compatible with AWS-hosted PostgreSQL, SQL Server, Amazon Aurora, and Dynamo DB. Key Responsibilities: Data Migration & ETL: • Oversee all data migration efforts: analyze current data (quality, structure, anomalies), develop transformation logic, and execute incremental/full data loads into new database schemas. • Evaluate existing migration tools; recommend and implement performance optimizations for large-scale data transfers. • Create and maintain data validation and exception reporting processes to ensure high data fidelity throughout migration. Master Data Management & Governance: • Define and standardize master data definitions, coordinate with DWC data stewards to cleanse, reconcile, and govern key entities (e.g., claimants, employers, providers). • Develop and enforce database system standards, data dictionaries, and comprehensive documentation for ongoing data stewardship. • Collaborate with business analysts to identify orphaned or invalid records; recommend remediation plans. Data Modeling & Architecture: • Create detailed logical and physical data models (e.g., using Visio, DataIO) to support the new DWC Work Comp Connect application. • Translate functional requirements from the "Future State Memo" into a normalized/denormalized database design that supports application performance, scalability, and reporting. • Establish and enforce database lifecycle management practices: plan and guide database engine upgrades, utility migrations, and configuration changes to optimize uptime and security. nalytics & Reporting Support: • Develop complex SQL queries to support ad hoc and scheduled reporting, ETL workflows, and automated job scheduling. • Monitor and benchmark database performance baselines, recommending infrastructure adjustments (storage, memory, indexing) as needed. • Serve as the SME for data delivery processes between various systems (e.g., UInteract, FileVine) via RESTful integrations. Technical Oversight & Collaboration: • Partner with DWC Modernization Project Director and ITSD Project Manager to review design decisions, identify technical risks, and ensure alignment with Missouri State security/compliance standards (FERPA, HIPAA, PII/PHI safeguards). • Provide weekly status reports (using ITSD Project Status Report template) detailing tasks completed, upcoming work, risks, and percent complete. Reports due each Monday by EOD. • Facilitate technical knowledge transfer: mentor/guide junior data engineers, collaborate with ITSD staff on development and test plan creation, and assist with defect logging/tracking. Compliance & Security: • Comply with all State security policies: maintain Active Directory credentials, use State-approved VDI or remote desktop methods, and ensure all development occurs on ITSD-provided infrastructure. • Guarantee all services are U.S.-based (no offshore resources). • Manage and secure State Data: enable nightly incremental data extracts to feed the State Data Warehouse, support end-of-contract data extraction (60-day window), and assist with routine extraction validation. Deliverables: Monthly Status Reports: Summarize weekly reports (per ITSD template) for each month (September 2025 through June 2027), delivered via PDAF process. Data Architecture Artifacts: • Logical and physical data models for AICS legacy and new Work Comp Connect schemas. • Data dictionaries, entity-relationship diagrams, and transformation logic documentation. ETL & Migration Scripts: Well-tested SQL/ETL code, quality assurance filters, and exception-handling logic. Master Data Governance Plan: Standardized definitions, data steward guidelines, and remediation procedures. Performance Baseline Reports: Database benchmark metrics and recommended infrastructure changes. Final Data Extract Packages: Complete, validated data extraction for archival and hand-off at project end (within 60 days post 06/30/2027). Staffing Types & Volume: One (1) Senior Data Architect (full-time allocation, U.S.-based) responsible for all data architecture and migration tasks outlined above. Submittal Requirement
Completed SOW Response Document:
Vendor sections of this SOW fully filled out, including signature block. Deliverable Payment Milestone Table (with firm-fixed prices per monthly status report deliverable, holdbacks if applicable). Contracting Resource Price Calculations Table (hourly rates × estimated hours for internal cost validation; note: State will pay per deliverable). Proposal Narrative:
pproach & Methodology (Exhibit A): Detailed plan for all tasks in Section 2 (data migration, modeling, governance, reporting). Personnel Qualifications & Biographies (Exhibit B): Resume/CV demonstrating &Client; 5 years' experience on large State government data modernization projects, familiarity with AICS or similar AS/400 systems, and mastery of PostgreSQL/Aurora/Dynamo DB on AWS. Relevant Company History & Experience (Exhibit C): Three (3) case studies on: State or higher-education data modernization involving AS/400 migration. Master data governance implementations with centralized data warehouses. Complex ETL and performance optimization on cloud-hosted databases (AWS). Participation Commitment (Exhibit D): MBE/WBE/SDVBE documentation, if applicable. Work Breakdown Structure (WBS): Gantt chart or similar illustrating tasks, milestones, and timelines aligned with Section 2 deliverables. Testing & Validation Plan: Description of how nightly incremental extracts, QA filters, and final data extraction will be validated. Security & Compliance Approach: Procedures for handling PII/PHI, ensuring U.S.-based development, and using State-provided environments. Resumes for Proposed Resource:
One (1) Senior Data Architect resume showing relevant certifications (e.g., Certified Data Management Professional, AWS Database Specialty) and &Client; 5 years' experience in State government or regulated environments. Licensing Confirmation:
Proof that Vendor will procure/maintain any required development tools and database licenses (e.g., Visio, DataIO, AWS account tools) for the duration of the contract. Submission Format & Requirements:
Electronic Submission Only: PDF format, emailed to sarah.j.mealy@oa.mo.gov by 06/20/2025 5:00 PM CT. Page Limits: Maximum of 50 pages for narrative/exhibits (resumes excluded). Font: 11 pt or larger for text; smaller fonts only in graphics/diagrams. No Embedded Files/Hyperlinks: Failure to comply may result in exclusion of non-compliant content from evaluation. Evaluation Criteria
Cost - 53 points pproach and Methodology for Scope of Work - 44 points Personnel Qualifications and Biographies - 49 points Company History and Experience - 44 points Potential bonus points if Exhibit D is completed: MBE/WBE Participation - 10 points Organization for the Blind/Sheltered Workshop Preference - 15 points MO Service-Disabled Veteran Business Preference - 3 points Total - 218 points
References
Three (3) relevant client references (State or higher-education data modernization)
Resumes required?
Yes - resume for the proposed Senior Data Architect (Exhibit B)
Rate card required
No traditional rate card. Pricing must be firm-fixed per deliverable (monthly status reports). Vendor must also submit "Contracting Resource Price Calculations" (hourly rate × estimated hours) for internal reference only.
ny specific requirement
ll services and resources must be provided in the United States. No offshore work permitted. Resource must comply with DOLIR/ITSD security policies, complete required trainings, and sign confidentiality agreements. Resource must possess &Client; 5 years' experience in data architecture and data modernization projects, with direct exposure to AS/400 AICS or similar. Vendor must maintain all necessary development licenses (e.g., Visio, DataIO, AWS tools) and coordinate environment access via State-provided Active Directory/VDI. Hardcopy/Email/portal submission
Link
Via Email