Data Analyst

About Us:

Through its mission, the Ohio Children's Alliance applies the collective strength of its members to sustainably improve the provision of services to children, young adults, and families through policy advocacy, performance improvement, and member support.

Collaborate and advocate with great people! We are a team of talented and diverse people, who are passionate about building innovative solutions to challenges facing kids and families. With community agencies as our partners, we are empowering families to raise Ohio's next generation of leaders. Join us!

Role Overview: We are seeking a candidate who thrives on providing data-driven insights and recommendations. A creative and innovative thinker, a strong candidate will have significant experience with data collection, analysis, and visualization, including with health care claims and eligibility data. Candidates should possess outstanding organizational and communication skills and have experience identifying key quality improvement metrics and developing reports to present HEDIS measure performance (from claims data), program outcomes and quality improvement solutions to organizational leaders.

Key Responsibilities:

Under the direction of the Data Analytics Manager and the Director of Value-Based Care, this individual will:

• Create and implement new data collection processes
• Accept data (including raw healthcare claims and eligibility data) from multiple payors on a monthly basis
• Assess payor data to ensure it is complete and meets formatting requirements; follow-up with payors regarding late data and/or data issues
• Add payor data to the Alliance's data library
• Create, implement and maintain ETL and data cleansing processes for healthcare eligibility and claims data from multiple payors
• Create and maintain quality performance reports for multiple audiences, including creating HEDIS measures from claims data
• Manipulate large datasets
• Propose (and implement if approved) additional data sources that may add value to reporting
• Utilize qualitative and quantitative analysis techniques
• Develop and generate analysis for program initiatives, meetings, and communications
• Effectively present data analysis to leadership team and external stakeholders results using tables, graphs, dashboards, as well as written narrative
• Work closely with program staff to deliver quality reports in a timely manner
• Effectively communicate and collaborate with team members and external partners
• Maintain data integrity and security
• Represent the Alliance on committees as needed
• Other duties as assigned

Qualifications

• Bachelor's degree
• Minimum 3 years of experience as a health care data analyst or related position
• Demonstrated experience handling large data sets (including raw health care claims and eligibility data)
• Proficiency in Python, R, or SQL preferred (ability to write queries to extract, clean, and analyze data). Candidates without prior coding experience must demonstrate a strong willingness and aptitude to learn.
• Demonstrated experience with ETL (Extract/Transform/Load) processes and data cleaning/aggregation processes.
• Ability to develop and report on quality metrics (including HEDIS measures) and outcomes
• Proven self-starter with the ability to manage time and work priorities independently
• Excellent written and verbal communication skills
• Ability to work collaboratively internally and externally
• Experience with data visualization tools like Tableau, Power BI, or similar platforms and ability to quickly gain proficiency using similar software
• Advanced Excel skills and proficiency with Microsoft Office 365 products (Outlook, SharePoint, Teams, PowerPoint, Excel) strongly desired

Why Join Us?

• Impactful Work: Be part of making a real difference in the lives of children and families across Ohio.
• Professional Growth: Opportunities for continuous learning and career advancement.
• Supportive Team: Work with a passionate and dedicated team committed to excellence.
• Flexible Environment: Enjoy a dynamic work environment with flexibility.
• Diversity: The Ohio Children's Alliance is an equal opportunity employer committed to fostering a diverse and inclusive workplace. We welcome and value the contributions of people from different backgrounds, cultures, identities, and experiences, and we strive to create a work environment where everyone can belong, thrive, and grow.

% of Travel: 10-15%

Location: Hybrid; Occasional in-person requirements in Columbus, OH office

Organization: The Ohio Children's Alliance

Position Type: Full-time preferred, part-time considered; Hybrid position; employees residing within the state of Ohio will be expected to attend meetings and events as required by their position or requested by their supervisor. These meetings may be held anywhere in Ohio, typically in Columbus.

Compensation: $55,000-65,000 annually, negotiable commensurate with experience. Generous paid time off, health/dental/vision/life insurance coverage, 401(k) retirement benefit, professional development opportunities, public service student loan forgiveness.

How to Apply: Interested candidates are invited to submit their resume and a cover letter detailing their relevant experience and passion for the role. Applications without a cover letter will not be considered.

A background check will be run prior to hire.