Job summary:

Job description:

****  Very long term project initial PO for 1 year but expected to go for multiple years *** Webcam interview*** Required to be onsite in MS one full week per month.  

OBJECTIVE:

MDCPS seeks a 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 contributing
• team member on the MDCPS Data Management Team(DMT). The DMT is an emergent capability
• within 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, 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 the DMT.

MAJOR RESPONSIBLITIES:

• Data profiling legacy and external source data (Data quality diagnostic business rules and coding)
• Entity Relationship Diagramming, Business Vocabulary, Data Dictionary, Semantic Models
• Data mapping specifications for migration from large legacy database to new case
• management application, entity relationship diagrams, source and target data base schemas,
• data dictionary, transformation lineage, business vocabulary/semantic models.
• Provisioning meta data into data stack
• Semantic model development with time series, hierarchical/drill down views for child welfare metrics
• Master Data Management Processes and Tools
• Post capture data quality analytics and remediation orchestrated amongst applications and data stack
• Identifying and documenting data transformation requirements
• Identifying and documenting data analytics and reporting requirements
• technical / ETL development
• Identifying business rules for complex business metrics and coding calculations for those metrics.
• Development and orchestration of data migrations, data cleansing and data transformation workstreams
• Support backlog maintenance for data quality remediations

Required Skills/Experience:

To be considered, all proposed consultants must meet the following mandatory requirements:

• Four (4) years of experience with Multidimensional Model Data Base Design, ETL design and development.
• Four (4) years of experience with calculating data error rates and data cleansing on source databases.
• Four (4) years of experience with data quality and master data management integration.
• Four (4) years of experience with ERDs, business vocabulary, data dictionary and database schema mapping.
• Four (4) years of data analytic implimentation projects
• Two (2) years of experience with cloud based data stack tool and platforms
• Excellent English speaking skills, written communication skills, and knowledge transfer skills

Preferred Qualifications:

• Experience in Child Welfare data modeling, case management and analtyics
• Experience with data quality and data exchange components of federal requirements for Child
• Welfare management systems
• Ability to communicate effectively
• Ability to build a positive, productive rapport with team members

Contact the recruiter working on this position:

The recruiter working on this position is Chinmayee Patro(Raghu Team)
His/her contact number is +(1) (202) 6979490
His/her contact email is chunlipatro@msysinc.com

Our recruiters will be more than happy to help you to get this contract.