June 30, 2025 / Comments Off on WIC Data Analyst
| 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 |
| Experience collecting and managing WIC data from State of Ohio WIC agency via the Innovation Ohio Platform (IOP). | 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 WIC data as found in the State of Ohio WIC applications, including but not limited to Omneity and WIC Vendor Management.
- 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 dashboard 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 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 workflowsRequiredRequired- This field is for validation purposes and should be left unchanged.
- Max. file size: 1 GB.
Freqently Asked Questions
Mastering data conversion, pivot operations, and logical assignments in SQL is crucial for a Wic Data Analyst. These skills enable efficient transformation and extraction of meaningful insights from large datasets relevant to WIC program management and reporting.
In Columbus, OH, WIC Data Analysts often work closely with state-specific platforms like the Innovation Ohio Platform (IOP), which influences data collection methods. Familiarity with Ohio's WIC applications such as Omneity and vendor management is vital, setting it apart from roles in other regions.
Starting as a Wic Data Analyst can lead to senior analytics roles within public health or government agencies. Progression often involves specializing in larger-scale data governance, policy impact analysis, or moving into managerial positions overseeing nutrition assistance program data operations.
Tra'bian Enterprises supports hybrid work while expecting local Columbus-based analysts to engage in collaborative data projects. Analysts leverage tools like Hue and Impala for SQL workflows, balancing remote data processing with in-person strategy sessions to optimize WIC program analytics.
Yes, analysts at Tra'bian Enterprises often develop complex dashboards tailored for federal and state reporting, navigating unique data structures from the Ohio WIC agency. This demands a nuanced understanding of both regulatory requirements and advanced SQL querying to ensure compliance and accuracy.
Wic Data Analysts in Columbus typically earn between $65,000 and $80,000 annually, depending on experience and contract terms. This range reflects the area's demand for senior data analytical skills, particularly with expertise in SQL and state-specific WIC data systems.
Candidates living within a one-hour drive from Columbus qualify for this hybrid Wic Data Analyst position, making suburban commutes feasible. This local proximity ensures effective participation in both remote and onsite collaboration sessions essential for managing WIC data workflows.
Columbus shows growing demand for specialized data analysts skilled in public health programs like WIC, driven by increased federal reporting requirements. Candidates with strong SQL and data management experience, especially with Ohio WIC systems, find competitive opportunities in this niche.
Wic Data Analysts uniquely combine advanced SQL skills including pivoting and logical data assignments with domain-specific knowledge of WIC program data management. Proficiency in querying tools like Hue and experience with state platform data ingestion are key differentiators.
Daily responsibilities include querying and transforming large datasets using Impala SQL, developing reusable workflows, creating data views for complex reports, and collaborating with business users to tailor analytics that support state and federal WIC program objectives.
Find The Related Jobs
Career Professionals, Inc.
Conflicts Research Analyst
Dayton, OH
Popular Searches for WIC Data Analyst