Contract Healthcare Data Analyst - Snowflake & SQL

American business solutions inc; Columbus (OH); On-site; USD 90,000 - 120,000; Full time

Job summary

American business solutions inc is seeking a contract SQL/Data Analyst to translate and optimize queries for Snowflake, working with epidemiologists to transform data and support federal/state reporting. You will help document logic, build complex reports, and ensure data quality across multiple data sources.

Responsibilities include converting existing HUE/Cloudera queries to Snowflake, creating structured queries, and validating results with stakeholders.

Qualifications

• Five years of experience developing and executing SQL queries with minimal supervision.
• Experience gathering, analyzing, and documenting reporting requirements with business stakeholders.
• Experience performing QA checks to ensure data accuracy and consistency for analysis and reporting.
• One year of ANSI SQL on Snowflake platform.
• Bachelor-level degree in CS, Engineering, Business, or related field.

Responsibilities

• Translate existing SQL queries from HUE Cloudera to Snowflake.
• Collaborate with epidemiologists to design program-based SQL queries based on reporting needs.
• Answer questions from epidemiologists about SQL structure and design during development.
• Create queries for line-listed data using multiple tables and variables.
• Generate summary queries with multiple stratification criteria and validate with canned reports.
• Develop data cleaning queries for complex data structures to identify sites or cases requiring follow-up.
• Modify and troubleshoot queries during UAT to ensure functionality.
• Document logic and outputs within each query.

Skills

SQL development

Requirements gathering

Data QA

Snowflake ANSI SQL

4-year degree

IT consulting

Birth defect data

Ohio IOP data

Education

4-year college degree

Tools

SQL

Job description

American business solutions inc is seeking a contract SQL/Data Analyst to translate and optimize queries for Snowflake, working with epidemiologists to transform data and support federal/state reporting. You will help document logic, build complex reports, and ensure data quality across multiple data sources.

Responsibilities include converting existing HUE/Cloudera queries to Snowflake, creating structured queries, and validating results with stakeholders.