IT Consultant (Birth Defect Analyst) Remote
Description: Diversified Systems is searching for a IT Consultant (Birth Defect Analyst) to collect and manage birth defect data. The consultant will use Snowflake/ANSI SQL to select, transform, validate, and report data while working with business users and epidemiologists to understand and document analytics and reporting requirements.
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.
- nswer 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 that require follow up.
- Modify and troubleshoot queries during user acceptance testing to validate query functionality.
- Provide detailed documentation within each query that clearly defines the logic and expected outputs for each section of coding, including exclusions, calculated variables, sub-queries, and stratification.
Requirements: - 5 years of experience in IT with consulting experience required.
- 5 years of experience developing and executing queries using SQL with minimal supervision required.
- 5 years of experience working with business stakeholders to gather, analyze, and document reporting requirements required.
- 5 years of experience conducting quality assurance checks to ensure accuracy, completeness, and consistency of data used for analysis, reporting, and decision-making required.
- 1 year of experience working on a project using ANSI SQL on the Snowflake platform required.
- 4-year college degree in Computer Science, Engineering, Business, or other relevant field required.
- Experience collecting and managing birth defect data as found in the State of Ohio applications, including but not limited to the Maternal and Child Health Integrated Data System required.
- Experience collecting and managing birth defect data from the State of Ohio Department of Health agency via the InnovateOhio Platform (IOP) required.
- Experience using Snowflake/ANSI SQL to select and transform data as needed required.
- SQL experience including data conversion, pivots, and logical assignments required.
- Experience creating views or temporary tables within a sandbox database and/or schema to facilitate more complex queries required.
- Experience working with business users to understand and document their analytics and reporting requirements required.
- Experience developing complex reports and dashboards for state and federal reporting required.
- 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 required.
- Experience training business users on analytic tools and data structures required.
- Excellent written and oral communication skills required.
