Operations Data Analyst II (Healthcare Claims Processing)

Healthcare Management Administrators (HMA) is a premier third-party health plan administrator dedicated to providing customized health plans. The Operations Data Analyst II will enhance HMA's Analytics function by implementing automated reports and processes, serving as a Subject Matter Expert for internal stakeholders, and addressing reporting-related queries.

Responsibilities:

• Gather and document reporting and analysis requirements from business stakeholders
• Design and develop analytics solutions tailored to business needs, leveraging appropriate technologies aligned with the best internal practices and system architecture
• Perform testing, validation, and quality assurance on both self-developed and team-developed analytics solutions
• Train non-analytics users on how to effectively use analytics tools and report
• Troubleshoot and resolve issues related to report failures and data inconsistencies
• Translate solutions across technologies (e.g., SQL to Power Query) and source data from alternative platforms (e.g., Qiclink, Benefit Focus
• Identify and implement enhancements to existing deliverables, including automation opportunities and process improvements
• Serve as a backup or understudy for overflow tasks and back-fill coverage across designated departments
• Collaborate with IT teams and business stakeholders to identify and address issues, risks, and concerns related to data integrity
• Communicate findings, observations, and recommendations to business stakeholders using clear, business-friendly language
• Demonstrate deep expertise in analytics technologies (e.g., Python, Power Query, DAX, SQL, R, Fabric, CaseTrakker Reporting) with the ability to teach and mentor other analysts in their effective use. (2 or more)
• Conduct quarterly analytics business reviews with department leaders, presenting insights and performance metrics for your assigned specialty area

Requirements:

• Bachelor's degree or equivalent experience required
• 3-5+ years' previous experience with reporting and data analysis using SQL and PowerBI
• Proven success creating and maintaining data visualization tools including PowerBI Expert level skills within Microsoft Excel and the ability to manipulate data with ease
• Must be a critical thinker and very analytical in order to synthesize data and troubleshoot issues
• Great communication skills in order to interact with stakeholder and efficiently gather requirements
• Resilient, adaptable, and have the ability to grasp new ideas and concepts quickly
• Mastery of time management and ability to work on multiple projects simultaneously, stay organized and maintain a keen attention to detail
• Experience utilizing claims processing software such as Facets, Qiclink, Benefit Focus, Javalina, HealthEdge, etc
• Certification in PowerBI preferred
• Experience in the health care analytics industry, including payer/TPA models strongly preferred