Data Analyst - (Must Exp: Impala & ANSI SQL)

Overview

On Site
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)

Skills

Data Analysis
Hue
SQL
Impala
ANSI
State of Ohio
Ohio Department of Health

Job Details

Title : DOH-IT Consultant 2 Birth Defects
Location : Columbus, OH
Duration : 12 + Months
Client : State of OH - Hybrid Job Title: Senior Data Analyst

Description: The candidate must have senior data analysis experience in the following:

  • Experience collecting and managing birth defect data as found in the State of Ohio applications, including but not limited to the Maternal and Child Health Integrated Data System.
  • Experience collecting and managing birth defect data from the State of Ohio Department of Health agency via the Innovation Ohio Platform (IOP).
  • Experience using Impala/ANSI SQL to select and transform data as needed. SQL experience must include data conversion, pivots, and logical assignments.
  • Experience using Hue (Impala Editor) for querying large datasets, managing SQL scripts, and creating reusable query workflows within shared or sandbox environments.
  • Experience creating views or temporary tables within a sandbox database and/or schema to facilitate more complex queries.
  • Experience working with business users to understand and document their analytics and reporting requirements.
  • Experience developing complex reports and dashboards for state and federal reporting.
  • Experience with all types of testing from unit to system and user acceptance testing, developing test cases and scenarios along with business users, reporting and tracking defects, and triaging/resolving issues.
  • Experience training business users on analytic tools and data structures.


Skills :

Skill

Required / Desired

Amount

of Experience

Experience collecting and managing birth defect data as found in the State of Ohio applications

Required

Experience collecting and managing birth defect data from the State of Ohio Department of Health agency via the Innovation Ohio Platform (IOP).

Required

Experience using Impala/ANSI SQL to select and transform data as needed. SQL experience must include data conversion, pivots, and logical assignments

Required

Experience using Hue (Impala Editor) for querying large datasets, managing SQL scripts, and creating reusable query workflows

Required

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.