Overview
Direct message the job poster from Radiant Digital. This position is full-time (40 hours weekly) and requires an individual to participate as a significantly contributing team member on the MDCPS Data Management Team (DMT). The near-term scope of this team and this position includes participating in data related migration and design activities on the replacement of legacy case management system with the new CCWIS Cloud-Based hosted solution, and planning and implementation of cloud-based data stack to enable robust and actionable analytics capabilities at MDCPS. This individual will be reporting to the lead architect on DMT.
Major Responsibilities
- Support and participation in identification and management of data-related issues / risks and gaps
- Understand, conceive and document source and target-state data architectures for applications and cloud based data analytic platforms
- Data Pipeline Design and Implementation
- Development of subject matter expertise in business drivers, business semantic meaning and business practice when providing data management services
- Design and Development of ETL architecture and technical work packages
- Deliver on measurable improvements of data quality metrics
- Entity Relationship Diagramming, Business Vocabulary, Data Dictionary, Multi-Dimensional Models, Semantic Models; Data mapping specifications for migration from large legacy database to new case management application, including entity relationship diagrams, database schema, data dictionary, transformation lineage, and business vocabulary / semantic models
- Data Set Catalogue Planning and Implementation
- Provisioning and managing metadata in the data stack; identifying business rules for complex business metrics and coding calculations for those metrics
- Semantic model design and development with time series, hierarchical / drill down views for child welfare metrics
Required skills
To be considered, all proposed consultants must meet the following mandatory requirements :
Eight (8) years of experience with Multidimensional Model Data Base Design, ETL design and developmentEight (8) years of experience with data quality and master data management integrationEight (8) years of experience with ERD's, business vocabulary, data dictionary and database schema mappingEight (8) years of data analytic implementation projectsThree (3) years of experience with cloud-based data stack tool and platformsExcellent English-speaking skills, written communication skills, and knowledge transfer skillsPreferred skills
Experience in Child Welfare data modeling, case management and analyticsExperience with data quality and data exchange components of federal requirements for Child Welfare management systemsPrior CCWIS experienceAbility to communicate effectivelyAbility to build a positive, productive rapport with team membersSeniority level
Mid-Senior levelEmployment type
ContractJob function
AnalystIndustries
IT Services and IT ConsultingJ-18808-Ljbffr