Job Title: Senior Data Analyst Location: Columbus, OH (Hybrid) Duration: 12 Months Description The candidate must have senior data analysis experience in the following: • Experience collecting and managing birth defect data as found in the • • • applications, including but not limited to the Maternal and Child Health Integrated Data System. • Experience collecting and managing birth defect data from the • • • Department of Health agency via client's Innovation Platform. • 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. • Experience training business users on analytic tools and data structures. Job #: 25-33272