The Business Analyst will work collaboratively with Milliman SkySail Consultants to complete analyses and reports using SkySail’s industry-leading software along with other computer programs. A key part of this role will be working to support our clients’ efforts in all thing’s pharmacy pricing. You will work closely with the Business Development and Pricing teams as well as the Software Developer group to help meet all clients’ needs and further improve the tool. This individual will report to the Senior Pharmacy Benefits Manager.
Who We Are
Milliman Skysail is a consulting and software-as-a-service (SaaS) unit of Milliman that leads the way in pharmacy claims analysis and reporting. SkySail Rx was founded in 2015 and acquired by Milliman in 2021. We foster an entrepreneurial work environment, reward excellence, and offer competitive compensation and benefits. We are a fast-growing company looking for a hands-on professional who enjoys rolling up their sleeves to meet goals, improve internal efficiencies, and increase Client satisfaction. The successful candidate will have an entrepreneurial spirit and the desire to learn in a rapidly growing market.
Job Responsibilities
- Complete repricing exercises using Skysail’s Analytics platform.
- Generate quarterly pricing reporting for clients.
- Work with IT team to help test new additions to the platform.
- Help Account team answer questions and present reporting to clients.
- Track, research, adjudicate, review, and respond to customer and/or external inquiries.
- Perform ongoing reporting to clients as needed.
- Produce ad-hoc analyses as needed.
- Query data and help design reporting.
- Produce recurring SQL/Excel reporting and QA for internal team members and external clients as needed.
- Other duties as assigned.
- Handle confidential and proprietary materials.
Minimum Requirements
- Two years of work experience in PBM, Pharmacy Industry, and/or related field OR a Bachelor’s Degree preferably in Business, Math, Science, or IT related fields
- Hands-on proficiency with Microsoft Excel and Word
Competencies and Behaviors that Support Success in this Role
- Understanding of Excel functions and other equations
- Working knowledge of SQL or other programming languages
- Ability to work both independently and collaboratively with frequent interruptions and time constraints.
- Demonstrated integrity, trustworthiness, and respect for confidentiality.
- Extremely detail oriented and organized.
- Enthusiastic, helpful attitude with a willingness to learn.
- Thrive in an entrepreneurial and collaborative culture
- Takes ownership of tasks and projects, with a strong team player attitude.
- Able to prioritize tasks and work under internal and external client deadline pressure.
- Quick learner.
- Conscientious and flexible, with a great work ethic, and team-player attitude.
- A polished demeanor and ability to interact professionally and amicably with staff at all levels.
- Good analytical and problem-solving skills.
- Track record of collaborating in a team environment.
- Ability to listen to feedback and integrate as appropriate.
- Demonstrated “let’s find a way to do it” attitude – no task is too big or too small
The Team
Milliman is one of the leading experts in healthcare financing and delivery. We advise clients on a wide range of issues-from assessing the impact of healthcare reform on organizations or populations to streamlining operations while advancing the quality of patient care. Our consulting work is supported by a powerful toolkit of data analytics solutions and informed by the most trusted, comprehensive set of cost guidelines in the industry.
Through a team of professionals ranging from actuaries to clinicians, technology specialists to plan administrators, we offer unparalleled expertise in employee benefits, investment consulting, healthcare, life insurance and financial services, and property and casualty insurance.
Salary: The salary range is $45,000 to $70,000, depending on a combination of factors, including but not limited to education, relevant work experience, qualifications, skills, certifications, location, etc.
Location:This role is based out of the Milliman SkySail office, but candidates can work remotely anywhere in the United States.
All qualified applicants will receive consideration for employment, without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)