Senior Data Analyst

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)

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.