Data Analyst

Position: Benefits Data Analyst
Tri Net is a leading provider of comprehensive human resources solutions for small to midsize businesses (SMBs). We enhance business productivity by enabling our clients to outsource their HR function to one strategic partner and allowing them to focus on operating and growing their core businesses. Our full-service HR solutions include features such as payroll processing, human capital consulting, employment law compliance and employee benefits, including health insurance, retirement plans and workers’ compensation insurance.

Tri Net has a nationwide presence and an experienced executive team. Our stock is publicly traded on the NYSE under the ticker symbol TNET. If you’re passionate about innovation and making an impact on the large SMB market, come join us as we power our clients’ business success with extraordinary HR.Don't meet every single requirement? Studies have shown that many potential applicants discourage themselves from applying to jobs unless they meet every single requirement.

Tri Net always strives to hire the most qualified candidate for a particular role, ensuring we deliver outstanding results for our small and medium-size customers. So, if you're excited about this role but your past experience doesn't align perfectly with every single qualification in the job description, nobody’s perfect – and we encourage you to apply. You may just be the right candidate for this or other roles.

A Brief Overview The Benefits Data Analyst supports the Client Open Enrollment Team and is an integral team player responsible for performing data management retrieval, reporting and processing functions supporting the company's multifaceted open enrollment processes, practices, and system. An extensive portion of this position's time is spent gathering data from a variety of sources, compiling results and reporting on findings.

The development of reports involves perceptive comparative analysis and manipulation of data. Reports are expected to include insightful recommendations based on assessment within the broader context of the incumbent's experience in and/or knowledge of the health care and health benefits industry.

What you will do Analyze client performance, producing reports and reconciling large amounts of disparate data. This includes analyzing and interpreting claims, fees, and conditions data to determine present and future financial performance.

Create and manage the client costing tool.

Understand multiple data sources and structures to maintain strong data infrastructure, bringing relevant data sources into a consolidated environment for more efficient data manipulation and relationship reporting.

Create queries using design techniques that ensure adherence to database development standards using a variety of database applications.

Coordinate with all levels of management to gather, analyze, and summarize data to accommodate all stakeholder requests.

Assist with the annual client renewal process for medical, dental, and other healthcare benefits.

Document business requirements to ensure systems and processes are set up correctly.

Responsible for carrier rate validation.

Performs other duties as assigned

Complies with all policies and standards

Education Qualifications Bachelor's Degree or equivalent experience required

Bachelor's Degree in Finance, Economics, or other business-related areas preferred

Experience Qualifications Typically 2+ years working with relational databases and complex spreadsheets required

Experience in healthcare analytics and/or insurance preferred

Skills and Abilities

Ability to critically evaluate information gathered from multiple sources, reconcile any identified conflicts, and categorize high-level information

Strong Microsoft Office experience. Advanced proficiency in Excel required

A demonstrated commitment to high professional ethical standards and a diverse workplace

Ability to adapt to a fast paced continually changing business and work environment while managing multiple priorities

Comfortable across multiple systems and interfaces.

Experience with data warehouse preferred.

Strong critical thinking, problem solving, and analytical skills with an attention to…