Data Analyst, Finance Operations

About Capital Rx:

Capital Rx is a next generation pharmacy benefits manager, overseeing prescription benefit plans on behalf of employers, unions, and government entities. Determined to transform an outdated model, Capital Rx’s mission is to change the way prescription benefits are priced and administered in the US, unlocking enduring social change. Through our platform approach, Capital Rx delivers data-driven insights and actionable strategies that reduce costs, while improving patient outcomes. Our commitment to innovation, technology and service is the reason why Capital Rx is among the fastest-growing PBMs in the country.

Position Description:

The Data Analyst, Finance Operations is highly visible and critical position being added to the Finance function at Capital Rx. Person in position will provide support to for all value-added services, clinical programs, and other upsell services for Capital Rx. This role will play an important role in defining, build out, and expand the other PBM services for the enterprise. This will include data mining, KPI creation and management, and operational work flows for departments. This person will help provide valuable insight that will be used to assess the performance of Capital Rx and drive change within the company.

Position Responsibilities:

• Oversee analytics to support ongoing operations needs
• Collaborate with department leaders from key functional areas (contact center, client services, clinical operations) to design, refine, automate, and maintain data analytics for invoicing purposes
• Develop ad hoc and standard reports to support internal and external analytics and reporting needs
• Manage workflow for inbound and outbound data requests, reporting deliverables, and other inquiries
• Clean, collect, organize, and draw insights from client, vendor, and internal data – using mainly SQL or Excel. Python and/or R can be used as needed
• Assist in the writing and maintenance of the Finance SQL queries
• Thoroughly understand data fields, identify patterns of data irregularities, and improve data quality and intake
• Assist with finance function consisting of bi-monthly AR/AP cycles, quarterly rebate processes, annual reconciliations and improve processes as needed
• Help in building out and codifying billing structures, refining and automating processes
• Suggest process refinement and collaboration enhancement for data and other related underwriting items

Required Qualifications:

• Bachelor’s degree in, Business, or a closely related field (In lieu of a degree, equivalent relevant work experience may be considered)
• PBM / health plan experience required
• 3-5 years of proven experience in data & analytics
• Experience performing complex analyses on large sets of data
• Knowledge of data management, statistics, modeling
• Experience working with structured and unstructured data
• Proficient in SQL and Excel; Knowledge of Python or R for data analysis is a plus
• Ability to balance multiple complex projects simultaneously
• Exceptional written and verbal communication skills
• Extremely flexible, highly organized, and able to shift priorities easily
• Attention to detail & commitment to delivering high quality work product

Capital Rx values a diverse workplace and celebrates the diversity that each employee brings to the table. We are proud to provide equal employment opportunities to all employees and applicants for employment and prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, medical condition, genetic information, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.