Operations Data Analyst II (Healthcare Claims Processing)

HMA is the premier third-party health plan administrator across the PNW and beyond. We relentlessly deliver on our promise to provide medium to large-size employers with customized health plans. We offer various high-quality, affordable healthcare plan options supported with best-in-class customer service. 

We are proud to say that for three years, HMA has been chosen as a ‘Washington’s Best Workplaces’ by our Staff and PSBJ™. Our vision, ‘Proving What’s Possible in Healthcare™,’ and our values, People First!, Be Extraordinary, Work Courageously, Own It, and Win Together, shape our culture, influence our decisions, and drive our results.

What we are looking for: We are always searching for unique people to add to our team. We only hire people that care deeply about others, thrive in evolving environments, gain satisfaction from being part of a team, are motivated by tackling complex challenges, are courageous enough to share ideas, action-oriented, resilient, and results-driven. 

What you can expect: You can expect an inclusive, flexible, and fun culture, comprehensive salary, pay transparency, benefits, and time off package with plenty of personal development and growth opportunities. If you are looking for meaningful work, a clear purpose, high standards, work/life balance, and the ability to contribute to something important, find out more about us at: https://www.accesshma.com/

How YOU will make a Difference:

The purpose of the role is to continuously improve HMA’s Analytics function through data quality initiatives and automation. This role will work to identify, test, and implement automated reports and processes that are significant to business processes and internal stakeholders. Acting as the Subject Matter Expert for internal stakeholders, this position will also assist its customers with reporting-related questions and troubleshooting and will conduct research as needed to determine the appropriate responses.

This role requires experience utilizing claims processing software such as Facets, Qiclink, Benefit Focus, Javalina, HealthEdge, etc).

What YOU will do:

• 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

Knowledge, Experience and Attributes:

• Bachelor’s degree or equivalent experience required.
• 3-5+ years’ previous experience with reporting and data analysis using SQL and PowerBI.
• Certification in PowerBI preferred
• 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 in the health care analytics industry, including payer/TPA models strongly preferred

Application Note:

When applying, please include the phrase “What stood out to me about this role is…” somewhere in your application.

Compensation:

The base salary range for this position in the greater Seattle area is $111,000-$136,000 and varies dependent on geography, skills, experience, education, and other job or market-related factors. Performance-based incentive bonus(es) is available.

Disclaimer: The salary, other compensation, and benefits information are accurate as of this posting date. HMA reserves the right to modify this information at any time, subject to applicable law.

In addition, HMA provides a generous total rewards package for full-time employees that includes:

• Seventeen (IC) days paid time off (individual contributors)
• Eleven paid holidays
• Two paid personal and one paid volunteer day
• Company-subsidized medical, dental, vision, and prescription insurance
• Company-paid disability, life, and AD&D insurances
• Voluntary insurances
• HSA and FSA pre-tax programs
• 401(k)-retirement plan with company match
• Annual $500 wellness incentive and a $600 wellness reimbursement
• Remote work and continuing education reimbursements
• Discount program
• Parental leave
• Up to $1,000 annual charitable giving match

How we Support your Work, Life, and Wellness Goals

At HMA, we believe in recognizing and celebrating the achievements of our dedicated staff. We offer flexibility to work schedules that support people in all time zones across the US, ensuring a healthy work-life balance. Employees have the option to work remotely or enjoy the amenities of our renovated office located just outside Seattle with free parking, gym, and a multitude of refreshments. Our performance management program is designed to elevate career growth opportunities, fostering a collaborative work culture where every team member can thrive. We also prioritize having fun together by hosting in person events throughout the year including an annual all hands, summer picnic, trivia night, and a holiday party.

We hire people from across the US (excluding the state of Hawaii and the cities of Los Angeles and San Francisco.) 

HMA requires a background screen prior to employment.

Protected Health Information (PHI) AccessHealthcare Management Administrators (HMA); employees may encounter protected health information (PHI) in the regular course of their work. All PHI shall be used and disclosed on a need-to-know-basis and according to HMA’s standard policies and procedures.

HMA is an Equal Opportunity Employer.

For more information about HMA, visit