Data Architect

Job ID: MS-115081 5POnsite/ Local Data Architect with MDM, ETL, ERD cloud, data modeling, analytics, data quality, and Child Welfare (CCWIS) experienceLocation: Jackson MS (MDCPS)Duration: 12 MonthsRequired to be onsite in MS one full week per month. Do NOT submit candidates unwilling to meet this requirement.See attached job description.Skills:Required Skills/ExperienceProvide the minimum required skills and/or experience the contractor must possess to qualify for this position. These requirements will be transferred to the Score Sheet and candidates without these requirements reflected on their resume will NOT be presented to the manager for consideration.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 implimentation projects– Three (3) years of experience with cloud-based data stack tool and platforms– Excellent English-speaking skills, written communication skills, and knowledge transfer skillsPreferred/Not RequiredProvide any skills/experience that would be helpful for the candidate to possess but not required. Examples: Previous supervisory experience, WebLogic experience helpful, etc.Preferred Qualifications:Experience in Child Welfare data modeling, case management and analtyicsExperience with data quality and data exchange components of federal requirements for Child Welfare management systemsAbility to communicate effectivelyAbility to build a positive, productive rapport with team membersOBJECTIVE: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 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 onthe 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 the DMT.MAJOR RESPONSIBLITIES:Support and participation in Identification and management of data-related issues / risks and gapsUnderstanding, conceiving and documenting source and target-state data architectures for applications and cloud based data analytic platforms1Data Pipeline Design and ImplementationDevelopment 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 packagesDeliver on measurable improvements of data quality metricsEntity Relationship Diagramming, Business Vocabulary, Data Dictionary, Multi-Dimensional Models, Semantic ModelsData 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 stackIdentifying 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 metricsE-RTR-5.doc