Overview
Remote
Depends on Experience
Contract - W2
Contract - Independent
Contract - 12 Month(s)
Skills
Data Dictionary
ETL Architecture
Data Modeling
ERD
Mapping
Knowledge Transfer
CCWIS
Meta-data Management
Job Details
Job Description:
***Crop to Crop resumes are accepted
MDCPS seeks an experienced professional to participate in planning and execution of data cleansing and data migration initiatives and concurrently participate in development of data models, data stack architecture, technical implementation and other critical functions of data management that will enable evidence based Child Welfare Practice at MDCPS.
MAJOR RESPONSIBLITIES:
- Support and participation in Identification and management of data-related issues / risks and gaps
- Understanding, conceiving and documenting 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, entity relationship diagrams, data base schema, data dictionary, transformation lineage, business vocabulary/semantic
models. - Data Set Catalogue Planning and Implementation.
- Provisioning and managing meta data 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:
- Eight (8) years of experience with Multidimensional Model Data Base Design, ETL design and development.
- Eight (8) years of experience with data quality and master data management integration.
- Eight (8) years of experience with ERD's, business vocabulary, data dictionary and database schema mapping.
- Eight (8) years of data analytic implementation projects
- Three (3) years of experience with cloud-based data stack tool and platforms
- Excellent English-speaking skills, written communication skills, and knowledge transfer skills
Desired Skills:
- Experience in Child Welfare data modeling, case management and analytics
- Experience with data quality and data exchange components of federal requirements for Child Welfare
management systems - Prior CCWIS experience
- Ability to communicate effectively
- Ability to build a positive, productive rapport with team members
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.