ZipRecruiter

Log In

1

Temporary Defect Analyst Jobs Near Me

Atash Enterprises, LLC

IT Consultant

Columbus, OH · On-site

... birth defect data as found in the State of Ohio applications, including but not limited to the ... temporary tables within a sandbox database and/or schema tofacilitate more complex queries. · ...

New

Vertiv Group Corp.

Technical Product Manager

Westerville, OH · On-site

$161K - $186K/yr

Analyze competitor products, documenting strengths, and deficiencies in core functionality ... Knowledge of bug/defect tracking tools is a plus. * Technical expertise to translate customer needs ...

Vertiv Co

Technical Product Manager

Westerville, OH · On-site

$161K - $186K/yr

Analyze competitor products, documenting strengths, and deficiencies in core functionality ... Knowledge of bug/defect tracking tools is a plus. * Technical expertise to translate customer needs ...

All JobsTemporary Defect Analyst JobsTemporary Defect Analyst Jobs Near Me

Temporary Defect Analyst information

What cities are hiring for Temporary Defect Analyst jobs?

Cities with the most Temporary Defect Analyst job openings:

What states have the most Temporary Defect Analyst jobs?

States with the most job openings for Temporary Defect Analyst jobs include:

What are the most commonly searched types of Defect Analyst jobs?

The most popular types of Defect Analyst jobs are:

Temporary Defect Analyst jobs near you
A map of the United States highlighting the number of Temporary Defect Analyst job openings by state according to ZipRecruiter. The image is accompanied by a detailed chart listing the number of Temporary Defect Analyst job openings in each state, with California having the most at 2 and Hawaii the least at 0.

Public Health Data Analyst

Columbus, OH • On-site

Atash Enterprises, LLC
See more jobs at Atash Enterprises, LLCexternal

Other

Posted 4 days ago

Job description

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.

·Experiencecollecting and managing birth defect data from the State of Ohio Department ofHealth agency via the Innovate Ohio Platform (IOP).

·Experienceusing Snowflake/ANSI SQL to select and transform data as needed. SQL experiencemust include data conversion, pivots, and logical assignments.

·Experiencecreating views or temporary tables within a sandbox database and/or schema tofacilitate more complex queries.

·Experienceworking with business users to understand and document their analytics andreporting requirements.

·Experiencedeveloping complex reports and dashboards for state and federal reporting.

·Experiencewith all types of testing from unit to system and user acceptance testing,developing test cases and scenarios along with business users, reporting andtracking defects, and triaging/resolving issues.

·Experiencetraining business users on analytic tools and data structures.

·Excellent communication skills both writtenand oral.

Day-to-Day responsibilities include but not limited to:

·Translateexisting SQL queries built in the HUE Cloudera to execute on the Snowflakeplatform.

·Meet withepidemiologists to develop SQL queries that incorporate program-based logicmodels based on reporting requirements and data structure.

·Answer questions from epidemiologists aboutthe structure, syntax, logic, and design of SQL queries during thecollaborative 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 trouble-shoot 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 (e.g., exclusions, calculated variables, sub-queries, stratification). 


5 years of experience in IT with consulting experience.

5 years required experience developing and executing queries using SQL with minimal supervision.

5 years required experience working with business stakeholders to gather, analyze, and document reporting requirements.

5 years required experience conducting quality assurance checks to ensure accuracy, completeness, and consistency of data used for analysis, reporting, and decision-making.

1 year required experience working on a project using ANSI SQL on the Snowflake platform.

4-year college degree in Computer Science, Engineering, Business, or other relevant field.


Skills Table:

Skill
Required / Desired
Amount
of Experience
5 years required experience developing and executing queries using SQL with minimal supervision.
Required
5
Years
5 years required experience working with business stakeholders to gather, analyze, and document reporting requirements.
Required
5
Years
5 years required experience conducting quality assurance checks to ensure accuracy, completeness, and consistency of data used for analysis, reporting
Required
5
Years
1 year required experience working on a project using ANSI SQL on the Snowflake platform
Required
1
Years
4-year college degree in Computer Science, Engineering, Business, or other relevant field.
Required
 
 
5 years of experience in IT with consulting experience.
Required
5
Years
Experience collecting and managing birth defect data as found in the State of Ohio applications, including but not limited to the Maternal and Child
Required
 
 
Experience collecting and managing birth defect data from the State of Ohio Department of Health agency via the Innovate Ohio Platform (IOP).
Required
 

Apply