IT Consultant (Birth Defect Analyst)

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.
• 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 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.

About Diversified Systems
Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.

Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.

Diversity, Equity and Inclusion
DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.