Dice is the leading career destination for tech experts at every stage of their careers. Our client, RICEFW Technologies Inc, is seeking the following. Apply via Dice today! IT Consultant 2 Job Title: Senior Data Analyst Description: The candidate must have senior data analysis experience in the following: • 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 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 dashboard 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. Required/Desired Skills Skill Required /Desired Amount of Experience Experience using Impala/ANSI SQL to select and transform data as needed. SQL experience must include data conversion, pivots, and logical assignments Required 0 Experience using Hue (Impala Editor) for querying large datasets, managing SQL scripts, and creating reusable query workflows Required 0 Experience collecting and managing WIC data from State of Ohio WIC agency via the Innovation Ohio Platform (IOP). Required 0 Questions No. Question Question1 Do you understand, and will abide by, the provision in your subcontract with OST that it is PROHIBITED for government equipment to be taken or used outside of the United States by your contractors? The consequences of this occurring can and will result in repercussions to you, the prime vendor, regardless if the candidate works for a sub-vendor of yours. It will also result in immediate termination of the contractor, and make them ineligible for rehire in the program