OneMain Financial Jobs

Essential Job Responsibilities Include:

• Develop and maintain Excel-based tools using advanced formulas, PivotTables, and Power Query to streamline data workflows, financial modeling, and reporting.

• Build, optimize, and maintain complex SQL queries and data models supporting claims repricing, rebate projections, financial forecasting, and performance benchmarking.

• Aggregate, normalize, and analyze pharmacy claims data from multiple PBM pricing products (e.g., CVS, Optum, Express Scripts), ensuring financial accuracy and consistency.

• Create dynamic, template-driven analytical frameworks to standardize outputs across varying account structures, pricing products, and contract terms.

• Support Project Prism through data verification, validation of pricing logic, troubleshooting discrepancies, and collaboration with database teams to resolve structural or performance issues.

• Support analysis and modeling efforts for PBM RFP negotiations, including financial comparisons, scenario modeling, and sensitivity analysis.

• Develop and support preliminary disruption analysis tools, including validation and distribution of member-level and account-level reporting.

• Collaborate with cross-functional stakeholders to support rebate forecasting, contract modeling, and broader business strategy initiatives.

• Troubleshoot issues related to data access, file locking, macro errors, query performance, and compilation issues across analytical environments.

• Maintain version control and documentation for reusable SQL queries, Excel templates, and analytical frameworks.

• Design and implement quality control checks to ensure financial integrity and data accuracy throughout multi-step transformation pipelines.

• Support high-priority ad-hoc analyses for internal leadership and external partners under compressed timelines.

• Focus on PBM pricing list management, ensuring all lists are accurate and up to date, with ability to analyze list changes and report significant financial or structural differences between versions.

Required Skills / Experience:

• Bachelor’s degree in Data Science, Computer Science, Public Health, Statistics, Finance, or related analytical field.

• 5+ years of progressive data analytics experience, preferably within PBM, pharmacy, or healthcare environments.

• Strong SQL proficiency, including complex joins, aggregations, window functions, performance optimization, and prevention of row multiplication errors.

• Advanced Excel skills, including:

• PivotTables and structured aggregations

• Power Query data transformation

• Advanced formulas (INDEX/MATCH, XLOOKUP, SUMIFS, array logic, financial modeling functions)

• Experience working with large healthcare claims datasets and multi-step financial modeling pipelines.

• Experience building dashboards and analytical reporting using Power BI, Tableau, or similar business intelligence platforms.

• Strong analytical and problem-solving skills, with demonstrated attention to financial accuracy and detail.

• Excellent written and verbal communication skills with ability to translate technical findings into business insights.

Preferred Skills/Experience:

• Advanced VBA scripting and Excel automation.

• Experience with SAS (including macro development and data step processing).

• Experience with Python for data processing, automation, or analytical support.

• Deep expertise in pharmacy claims data and PBM contract structures (rebates, tiers, guarantees, channel logic, AWP/WAC dynamics).

• Experience supporting RFP financial modeling and multi-year pricing comparisons.

• Experience with Snowflake or other cloud-based data platforms.

• Experience using Jira or similar ticket management systems to manage analytical workflows.

Based on relevant market data and other factors, the anticipated hiring range for this role is $88 ,000 to $110 ,000 annually. Final compensation rates will be determined based on various factors, including but not limited to experience, skills, knowledge, and internal equity considerations. This role is also short-term incentive eligible. Incentive amounts will vary by individual and business goals.

We are committed to fair and equitable compensation practices. The final salary offered to the selected candidate may vary from the posted range due to individual qualifications. Our goal is to ensure that all teammates are compensated fairly and competitively based on their contributions to our organization.

RxBenefits is also committed to providing best in class benefits to our teammates. We offer a robust total rewards package that includes:

• Remote first work environment

• Choice of a HDHP or PPO Medical plan, we pay 100% of the premium for the HDHP for you and your eligible family members

• Dental, Vision, Short- and Long-Term Disability, and Group Life Insurance that we also pay 100% of premiums (for your family too on Dental and Vision)

• Additional buy-up options for Short- and Long-Term Disability and Life Insurance

• 401(k) with an employer match up to 3.5% available after 60 days

• Community Service Day to give back and support what you love in your community

• 10 company holidays including MLK Day, Juneteenth, and the day after Thanksgiving plus a floating holiday to use as you like

• Reimbursements for high-speed internet, we’ll send you a computer and monitors to help you do your best work

• Tuition Reimbursement for accredited degree programs

• Paid New Parent Leave that can be used for adoption or birth

• Pet insurance to protect your furbabies

• A robust mental health benefit and EAP service through Spring Health to support you when you need it most

RxBenefits provides equal opportunities for everyone who works for us and everyone who applies to join our team, without regard to sex or gender, gender identity, gender expression, age, race, religious creed, color, national origin, ancestry, pregnancy, physical or mental disability, medical condition, genetic information, marital status, sexual orientation, any service, past, present, or future, in the uniformed services of the United States (military or veteran status), or any other consideration protected by federal, state, or local law.