Lead Data Specialist - Mississippi (100% Remote)
Job Code :MS 149462Job Title :Lead Data SpecialistClient Job ID :MS 149462Location :Mississippi (100% Remote)Duration :Until 10 / 12 / 2026 (11 months, 31 days)Job DescriptionState of Mississippi - Lead Data Specialist - Pathways Mississippi - MDCPS - 149462 (100% Remote)Agency :MS Department of Child Protection Services (MDCPS)Project :Pathways MississippiRate :Based on ExperienceWork Hours :Monday-Friday, 8 :00 AM - 5 :00 PM (40 hrs / week; occasional overtime)Background Check :Waived (No Background / Drug Screen)ObjectiveMDCPS seeks an experienced Lead Data Specialist to drive data cleansing, migration, and modeling initiatives supporting the modernization of the state's child welfare systems.The position contributes to building a cloud-based data stack that powers actionable analytics for evidence-based child welfare practices.Position SummaryThis full-time role will serve as a key contributor on the Data Management Team (DMT).The Lead Data Specialist will support the replacement of MDCPS's legacy case management system with a CCWIS Cloud-Based Solution and help implement a robust analytics platform.This position reports directly to the Lead Data Architect.Major ResponsibilitiesIdentify, manage, and resolve data-related issues, risks, and gaps.Design and document source and target-state data architectures for applications and analytic platforms.Develop and implement ETL and data pipelines.Build expertise in business semantics and data usage.Design ETL architecture , deliver data quality improvements, and define metrics.Create ERDs, data dictionaries, semantic and multidimensional models.Develop data mapping specifications for migration from large legacy systems.Plan and manage data catalog and metadata provisioning.Define and code business rules and complex metrics.Develop semantic models for time series and hierarchical analytics in child welfare data.Required Skills & Experience8years in Multidimensional Model Database Design and ETL design / development.8years with data quality and master data management integration.8years in ERDs, business vocabulary, data dictionary, and schema mapping.8years delivering data analytic implementation projects.3years experience with cloud-based data stack tools and platforms.Excellent English communication , documentation, and knowledge transfer skills.Preferred (Not Required)Experience in Child Welfare data modeling, case management, and analytics.Familiarity with federal CCWIS requirements.Prior CCWIS project experience.Strong collaboration and communication skills with diverse technical teams.Primary SkillsMultidimensional Model Database Design ETL Design Master Data Management Cloud-Based Data Stack Tools Case Management & Analytics ERD Database Schema Mapping Data Dictionary ETL Architecture. Experience: 5 years required