Rebate Administration Data Engineer

The Rebate Administration Data Engineer organizes and analyzes raw data, builds data pipelines, and develops analytical programs & tools � using SQL, Python, etc. � to enhance the analytic capability and reliability of the Rebate Administration and Operations teams.

Position Responsibilities:

• Thoroughly understand all Rebate Administration data sources, fields, and relationships, including historical claims, Medi-Span tables, NCPDP tables, and Capital Rx�s Book of Business data to interpret trends, identify patterns, and conduct complex data analyses in support of Rebate Administration and Operations business goals

• Investigate new data sources for the purpose of building & maintaining data pipelines to clean, transform, and aggregate disparate data

• Use agile software development to create, maintain, and improve Rebate Administration�s back-end systems for data extracts, pricing processes, and analytic tools to advance the department�s technical capabilities

• Model front-end and back-end data sources to help draw a more comprehensive picture of user flows throughout the system and to enable powerful data analysis

• Work closely with our Rebate Administration and Operations teams to help build complex algorithms that provide useful insights into our data

• Lead the analysis and development of new models and front-end tools that can be used to make predictions and answer questions for financial modeling & reporting

• Collaborate with various teams across the company on data sources and analytic methodology in support of the Rebate Administration and company objectives

• Provide standard and ad-hoc analytics to support the Rebate Administration team as needed

• Be an advocate for best practices and continued learning

• Establish and document SOPs to ensure superior data quality and reliability

• Assist in training and on-boarding new hires in Rebate Administration data, tools, and processes

• Support the maintenance of the Rebate Administration code repository, including reviewing and managing all major and minor releases

• All employees are responsible for adherence to the Capital Rx Code of Conduct including reporting of noncompliance.

Required Qualifications:

• Undergraduate bachelor�s degree (or equivalent) in Mathematics, Statistics, Economics, Computer Science, or IT

• 3+ years of experience with Python, SQL, and data visualization/exploration tools

• 3+ years of proven experience in data analysis, such as financial analysis, actuarial services, accounting, pricing, underwriting, etc.

• Familiarity with the AWS ecosystem, specifically Redshift and RDS

• Familiarity with Snowflake and PostgreSQL

• Experience in building or maintaining ETL processes

• Exceptional technical knowledge in software engineering and programming languages

• Excellent numerical, analytical, and problem-solving skills

• Track record of leading cross-functional initiatives, driving high performance, meeting deadlines, and executing on deliverables in a time-constrained environment

• Ability to balance multiple complex projects simultaneously

• Exceptional written and verbal communication skills, especially for explaining technical concepts to nontechnical business leaders

• Extremely flexible, highly organized, and able to shift priorities easily

• Attention to detail & commitment to delivering high quality work product

• Knowledge of pharmaceutical claims and or rebates is a plus

• Knowledge of and passion for improving the health care industry a plus

Visa Sponsorship: Capital Rx does not provide sponsorship to any candidates. This includes, but is not limited to those that require H1-B, TN, OPT, etc. Candidates must have authorization to work in the US at the time of application and throughout employment.

Base Salary: $100,000 - $120,000

This position description is designed to be flexible, allowing management the opportunity to assign or reassign duties and responsibilities as needed to best meet organizational goals.

About Capital Rx

Capital Rx is a full-service pharmacy benefit manager (PBM) and pharmacy benefit administrator (PBA), advancing our nation�s electronic healthcare infrastructure to improve drug price visibility and patient outcomes. As a Certified B Corp�, Capital Rx is executing its mission through the deployment of JUDI�, the company�s cloud-native enterprise health platform, and a Single-Ledger Model�, which increases visibility and reduces variability in drug prices. JUDI connects every aspect of the pharmacy ecosystem in one efficient, scalable platform, servicing millions of members for Medicare, Medicaid, and commercial plans. Together with its clients, Capital Rx is reimagining the administration of pharmacy benefits and rebuilding trust in healthcare.

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.