Lead Data Specialist

Overview

Remote
Depends on Experience
Full Time
Accepts corp to corp applications
Able to Provide Sponsorship

Skills

Analytical Skill
Analytics
Business Rules
Cloud Computing
Communication
Data Cleansing
Data Dictionary
Data Management
Data Migration
Data Modeling
Data Quality
Database
Dimensional Modeling
ERD
ETL Architecture
English
Extract
Transform
Load
Knowledge Transfer
Management
Mapping
Master Data Management
Meta-data Management
Microsoft Exchange
Migration
Provisioning
Reporting
Semantics
Time Series

Job Details

OBJECTIVE:

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.

POSITION SUMMARY:

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 additional to that, 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 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

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 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 skill

Preferred Qualifications:

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.