Senior Data Analyst (local candidates only)

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - 12 Month(s)
No Travel Required

Skills

WIC Data
Impala
ANSI SQL
Data Transformation
Data Conversion
Pivots
Hue/Impala Editor
Querying Large Datasets
SQL Scripts
Workflows
Sandbox
Testing

Job Details

Seeking a Senior Data Analyst for collecting and managing WIC data as found in the State of Ohio WIC applications, including but not limited to Omneity & WIC Vendor
Management.

Duration: contract position/through 06/30/2026
Work location: Columbus, OH (hybrid-2 days a week onsite) Local candidates only

Skills/Experience:
-Collecting and managing WIC data from State of Ohio WIC agency via the Innovation Ohio Platform (IOP).
-Using Impala/ANSI SQL to select and transform data as needed. SQL experience must include data conversion, pivots, and logical assignments.
-Using Hue (Impala Editor) for querying large datasets, managing SQL scripts, and creating reusable query workflows within shared or sandbox environments.
-Creating views or temporary tables within a sandbox database and/or schema to facilitate more complex queries.
-Working with business users to understand and document their analytics and reporting requirements.
-Developing complex reports and dashboard for state and federal reporting.
-Performing 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.
-Training business users on analytic tools and data structures.

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.