Excellent job opportunity as Data Analyst!



Responsibilities:

Execute recurring reporting projects, including loss ratios, reinsurance reporting and reserve analysis.
Analyze data and identify trends, patterns, or other notable information to identify emerging issues or opportunities for improvement.
Perform recurring data analyses including eligibility data comparisons and Salesforce quality control reporting.
Interpret data and develop reports to communicate findings to management.
Communicate with various Third Party Administrators (TPAs) and Pharmacy Benefit Managers (PBMs) and ensure all claims, enrollment and billing data is sent on a monthly basis and verify the accuracy of such data, working with our claims analytics platform vendor.
Work with our pharmacy benefit consultants to develop enhanced reporting on the performance of the PBMs that manage Rx benefits.
Analyzing and interpreting data from multiple sources to identify potential problems and make recommendations for improvement in operations.
Work on ad hoc reporting and analysis requests as assigned by management.
Extract data and reports from our claims analytics platform.
Participate with internal and external teams on other projects


Requirements

Expert in Microsoft Excel, including pivot tables, formulas, LOOKUP’s, and merging/consolidating data from multiple sources into a single report.
Knowledge in business intelligence tools and applications (i.e. Power BI, Tableau)
Ability to summarize and present large amounts of data in an organized fashion.
Process thinker and highly analytical with willingness to iterate and find solutions.
Ability to work in a structured manner, including logically working through a project plan or defined set of steps.
Fluent in English – both oral and written.
BS or BA degree in math, computer sciences, accounting, statistics, finance, or related fields




AppleOne is proud to be an Equal Opportunity Employer. We believe in people, and we are committed to working with people of all backgrounds and connecting them with clients and companies who share our goals of diversity and inclusiveness. All qualified applicants will receive consideration for employment without regard to race, religion, ancestry, color, national origin, age, gender identity or expression, genetic information, marital status, medical condition, disability, protected veteran status, sex (including pregnancy), sexual orientation, or any other characteristic protected by applicable federal, state, or local laws..

The Know Your Rights poster is available here:
https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12.pdf

The pay transparency policy is available here:
https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_%20English_formattedESQA508c.pdf

For temporary assignments lasting 13 weeks or longer, the Company is pleased to offer major medical, dental, vision, 401k and any statutory sick pay where required.

We are committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please contact your staffing representative who will reach out to our HR team.

AppleOne participates in the E-Verify program in certain locations as required by law. Learn more about the E-Verify program.
https://e-verify.uscis.gov/web/media/resourcesContents/E-Verify_Participation_Poster_ES.pdf