• 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. Cygnus Belief We believe in our commitment to diversity & inclusion. Equal Employment Opportunity Statement Cygnus is an Equal Opportunity Employer. We ensure that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation. All our employment decisions are taken without looking into age, race, creed, color, religion, sex, nationality, disability status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status, or any other aspects of employment protected by federal, state, or local law. Applicants for employment in the US must have work authorization & Cygnus does not offer any sponsorship of a visa for employment authorization in the United States. Thanks & Regards Amit Kumar Cygnus Professionals 3490 US Highway 1 Princeton, NJ 08540 M: 732 485 0000 Ext 9057 or 609-566-6868 (Direct) F: (888) 900-6979 E: amit.k@cygnuspro.com LinkedIn: https://www.linkedin.com/in/amit-kumar-341290137/