Remote Senior Health Data Analyst - Snowflake & SQL

Kodi Inc; North Carolina; On-site; USD 100,000 - 140,000; Full time

Job summary

Kodi Inc is seeking a Senior Health Birth Defect Data Analyst to collect and manage birth defect data and translate SQL queries from HUE Cloudera to Snowflake. You will work with epidemiologists to develop program-based SQL queries and support reporting for state and federal needs.

Responsibilities include translating queries, creating complex data views, and training business users, with a focus on data quality and documentation.

Qualifications

• 5 years of SQL development and execution experience with minimal supervision.
• 5 years of experience gathering and documenting reporting requirements with business stakeholders.
• 5 years of QA to ensure data accuracy and consistency.
• 1 year ANSI SQL experience on Snowflake.
• Experience translating SQL from HUE Cloudera to Snowflake.

Responsibilities

• Translate existing SQL queries built in HUE Cloudera to Snowflake.
• Meet with epidemiologists to develop SQL queries with program-based logic models.
• Answer questions about SQL query structure, syntax, and design during development.
• Create line-listed data queries and summary aggregates with multiple stratification.
• Develop data cleaning queries in complex data structures to identify sites/cases.
• Provide documentation detailing logic and outputs within each query.

Skills

SQL

Communication skills

Stakeholder collaboration

Tools

Snowflake

HUE Cloudera

Job description

Kodi Inc is seeking a Senior Health Birth Defect Data Analyst to collect and manage birth defect data and translate SQL queries from HUE Cloudera to Snowflake. You will work with epidemiologists to develop program-based SQL queries and support reporting for state and federal needs.

Responsibilities include translating queries, creating complex data views, and training business users, with a focus on data quality and documentation.