Data Analyst

Title: Data Analyst Duration: 1 year with possible extension Location: Jackson, MS 39202 NOTE: Must be onsite one full week per month PROJECT DETAILS: 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.

• 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 ERD's, 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

• 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