Lead Data Specialist

Job Description

Job Description

This is a remote position.

Seeking 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. 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.

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

Requirements

Skill

Required / Preferred

Required Years of Experience

Candidate Experience

Multidimensional Model Data Base Design, ETL design and development

Required

Experience with data quality and master data management integration

Required

Experience with ERD's, business vocabulary, data dictionary and database schema mapping

Required

Data analytic implementation projects

Required

Cloud-based data stack tool and platform experience

Required

Excellent English Speaking skills, written communication skills, and knowledge transfer skills

Required

Experience in Child Welfare data modeling, case management and analytics

Preferred

Experience with data quality and data exchange components of federal requirements for Child Welfare

Preferred

management systems

Preferred

Prior CCWIS experience

Preferred

Ability to communicate effectively

Preferred

Ability to build a positive, productive rapport with team members

Preferred