Senior Data Analyst

Overview

Hybrid
$90 - $100
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

Analytical Skill
Analytics
Dashboard
Data Conversion
Database
Hue
Testing
SQL
Test Cases
Training
Cloudera Impala
Data Structure

Job Details

One of our clients in the government domain is seeking a Senior Data Analyst with a strong background in managing and analyzing WIC program data, specifically within the State of Ohio systems such as Omneity and the Innovation Ohio Platform (IOP). Skilled in SQL (Impala/ANSI), including advanced data transformation techniques like pivots and logical assignments. Proficient in using Hue for querying large datasets, creating complex views, and developing reusable workflows. Adept at gathering and translating business requirements into actionable reports and dashboards for state and federal reporting. Demonstrated expertise in all phases of testing, from unit to UAT, as well as training end users on data tools and reporting systems.

Senior Data Analyst

Hybrid: Columbus, OH

Long Term Contract

Responsibilities:

  • Experience collecting and managing WIC data as found in the State of Ohio WIC applications, including but not limited to Omneity and WIC Vendor Management.
  • Experience collecting and managing WIC data from the State of Ohio WIC 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.
  • Experienced in training business users on analytic tools and data structures.

Required Skills:

  • 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
  • Experience collecting and managing WIC data from the State of Ohio WIC agency via the Innovation Ohio Platform (IOP).
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.