Birth Defect Analyst

Saxon Global • Columbus, OH

20h • Onsite

About The Position

This role involves collecting and managing birth defect data from the State of Ohio Department of Health agency via the Innovate Ohio Platform (IOP). The analyst will be responsible for translating existing SQL queries from HUE Cloudera to the Snowflake platform, developing new SQL queries based on reporting requirements and data structure, and answering questions from epidemiologists regarding SQL queries. The position also includes creating various types of queries for line-listed and aggregate data, utilizing innovative approaches for data cleaning, and performing all types of testing, including unit, system, and user acceptance testing. Additionally, the analyst will train business users on analytic tools and data structures.

Requirements

• Experience collecting and managing birth defect data from the State of Ohio Department of Health agency via the Innovate Ohio Platform (IOP).
• Experience using Snowflake/ANSI SQL to select and transform data as needed.
• SQL experience must include data conversion, pivots, and logical assignments.
• 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.
• Excellent communication skills both written and oral.

Responsibilities

• Translate existing SQL queries built in the HUE Cloudera to execute on the Snowflake platform.
• Meet with epidemiologists to develop SQL queries that incorporate program-based logic models based on reporting requirements and data structure.
• Answer questions from epidemiologists about the structure, syntax, logic, and design of SQL queries during the collaborative development process.
• Create queries for line listed data, incorporating variables from many different data tables.
• Create summary queries of aggregate data using multiple stratification criteria and validate using existing canned reports.
• Utilize innovative approaches to develop data cleaning queries within complex data structures that identify sites and/or cases.
• Develop complex reports and dashboards for state and federal reporting.
• Conduct unit, system, and user acceptance testing, developing test cases and scenarios along with business users, reporting and tracking defects, and triaging/resolving issues.
• Train business users on analytic tools and data structures.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed