Jobloria
Senior Data Analyst
Tra'bian Enterprises
Location : Columbus, OH, 43215
Job Type : Temporary
Date Posted : 1 December 2025
June 30, 2025 / Comments Off on Senior Data Analyst (Birth Defects Data Analyst)
| Experience collecting and managing birth defect data as found in the State of Ohio applications | Required |
| Experience collecting and managing birth defect data from the State of Ohio Department of Health via the Innovation Ohio Platform (IOP) | Required |
| Experience using Impala/ANSI SQL to select and transform data as needed. SQL experience must include data conversion, pivots, and logical assignments | Required |
| Experience using Hue (Impala Editor) for querying large datasets, managing SQL scripts, and creating reusable query workflows | Required |
LOCATION: Columbus, Ohio
POSITION TYPE: 12 month contract
POSITION TERMS: Hybrid – must be local or within a one hour drive
The candidate must have senior data analysis experience in the following:
- 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.
- Experience collecting and managing birth defect data from the State of Ohio Department of Health agency via the Innovation Ohio Platform (IOP).
- Experience using Impala/ANSI SQL to select and transform data as needed. SQL experience must include data conversion, pivots, and logical assignments.
- Experience using Hue (Impala Editor) for querying large datasets, managing SQL scripts, and creating reusable query workflows within shared or sandbox environments.
- Experience creating views or temporary tables within a sandbox database and/or schema to facilitate more complex queries.
- Experience working with business users to understand and document their analytics and reporting requirements.
- Experience developing complex reports and dashboards for state and federal reporting.
- 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.
- Experience training business users on analytic tools and data structures.
SKILLS:
Experience collecting and managing birth defect data as found in the State of Ohio applicationsRequiredExperience collecting and managing birth defect data from the State of Ohio Department of Health via the Innovation Ohio Platform (IOP)RequiredExperience using Impala/ANSI SQL to select and transform data as needed. SQL experience must include data conversion, pivots, and logical assignmentsRequiredExperience using Hue (Impala Editor) for querying large datasets, managing SQL scripts, and creating reusable query workflowsRequired- This field is for validation purposes and should be left unchanged.
- Max. file size: 1 GB.
Freqently Asked Questions
Columbus has a growing demand for senior data analysts with expertise in public health datasets, especially in state health departments. Candidates with specialized skills in birth defect data and platforms like Innovation Ohio Platform often face moderate competition, but their niche experience gives them a distinct advantage in securing roles.
Given Tra'bian Enterprises’ hybrid policy, living within an hour's drive of Columbus is crucial. Traffic patterns during peak hours and public transit options can affect commute time, so candidates often prioritize neighborhoods with quick highway access or reliable transit to maintain work-life balance.
Senior data analysts typically command advanced SQL capabilities such as complex data pivots, logical assignments, and creating reusable query workflows. Their proficiency extends beyond basic querying to crafting views or temporary tables, enabling sophisticated analysis and reporting that junior analysts might not handle independently.
Yes, entry-level data analysts in Columbus can progress to senior roles by deepening expertise in tools like Impala and platforms such as the Innovation Ohio Platform. Gaining domain knowledge in public health data and mastering reporting requirements also opens doors to managerial or specialized analytic positions.
At Tra'bian Enterprises, senior data analysts play a pivotal role in bridging technical data processes with business objectives. They engage directly with stakeholders to document analytics needs, ensuring that developed reports and dashboards align precisely with state and federal reporting mandates.
This role emphasizes managing birth defect data specific to Ohio's health systems, requiring familiarity with state applications and platforms like Innovation Ohio. The position also demands rigorous testing and user training, setting it apart by combining technical depth with public health domain expertise.
Senior data analysts in Columbus focusing on public health data typically earn between $85,000 and $105,000 annually. Factors influencing pay include proficiency with SQL and specialized platforms, contract terms, and experience with state and federal reporting standards.
Mastering the Innovation Ohio Platform allows analysts to access and manage critical birth defect datasets efficiently. This expertise streamlines data extraction and transformation, enabling precise analytics that directly support public health reporting and decision-making within Tra'bian Enterprises.
Senior analysts leverage Hue's intuitive interface to write, manage, and optimize Impala SQL queries, facilitating complex data transformations and reusable workflows. This combination ensures scalable, efficient querying of expansive health datasets critical for accurate analysis and reporting.
Find The Related Jobs
Career Professionals, Inc.
Conflicts Research Analyst
Dayton, OH