Epicareer Might not Working Properly
Learn More

Underwriting Data Analyst

Salary undisclosed

Apply on


Original
Simplified
Location: Hybrid preferred (Local to NYC area) or Remote

Position Responsibilities

  • Collect, clean, process, and analyze potential and current clients’ pharmaceutical data – using SQL, R, Python, and MS Excel as appropriate – to support the Underwriting and Sales teams in the acquisition of new business and retention of current clients
  • Thoroughly understand internal and external data fields, identify patterns of data irregularities, and improve data quality and intake
  • Reach out to and question relevant parties regarding any data ambiguity and request any additional data elements that may be required or beneficial for analysis
  • Assist in the writing and maintenance of the Underwriting infrastructure code in SQL, R, and Python
  • Participate in process enhancement for data analytics and reporting
  • Provide ad-hoc analytics support the Underwriting team in the successful completion of all bid opportunities
  • Provide analytics support to the Pricing, Clinical Account Management, and Implementation teams to facilitate client transitions as needed
  • Responsible for adherence to the Capital Rx Code of Conduct including reporting of noncompliance.

Required Qualifications

  • Undergraduate bachelor’s degree, with record of strong academic performance in Statistics, Economics, Finance, Business, Computer Science, or a quantitative social science
  • 1+ years of proven experience in data analysis, such as financial analysis, actuarial services, accounting, pricing & underwriting
  • Proficient in SQL; knowledge of Python and/or R are a major plus
  • Knowledge of Tableau is a plus
  • Experience working with structured and unstructured data
  • Knowledge of pharmaceutical claims is a plus
  • Track record of leading cross-functional initiatives, driving high performance, meeting deadlines, and executing on deliverables
  • Ability to balance multiple complex projects simultaneously and manage a frequently shifting work queue
  • 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
  • Knowledge of and passion for improving the health care industry a plus

Base Salary: $75,000 - $90,000

Nothing in this position description restricts management’s right to assign or reassign duties and responsibilities to this job at any time.

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.
Location: Hybrid preferred (Local to NYC area) or Remote

Position Responsibilities

  • Collect, clean, process, and analyze potential and current clients’ pharmaceutical data – using SQL, R, Python, and MS Excel as appropriate – to support the Underwriting and Sales teams in the acquisition of new business and retention of current clients
  • Thoroughly understand internal and external data fields, identify patterns of data irregularities, and improve data quality and intake
  • Reach out to and question relevant parties regarding any data ambiguity and request any additional data elements that may be required or beneficial for analysis
  • Assist in the writing and maintenance of the Underwriting infrastructure code in SQL, R, and Python
  • Participate in process enhancement for data analytics and reporting
  • Provide ad-hoc analytics support the Underwriting team in the successful completion of all bid opportunities
  • Provide analytics support to the Pricing, Clinical Account Management, and Implementation teams to facilitate client transitions as needed
  • Responsible for adherence to the Capital Rx Code of Conduct including reporting of noncompliance.

Required Qualifications

  • Undergraduate bachelor’s degree, with record of strong academic performance in Statistics, Economics, Finance, Business, Computer Science, or a quantitative social science
  • 1+ years of proven experience in data analysis, such as financial analysis, actuarial services, accounting, pricing & underwriting
  • Proficient in SQL; knowledge of Python and/or R are a major plus
  • Knowledge of Tableau is a plus
  • Experience working with structured and unstructured data
  • Knowledge of pharmaceutical claims is a plus
  • Track record of leading cross-functional initiatives, driving high performance, meeting deadlines, and executing on deliverables
  • Ability to balance multiple complex projects simultaneously and manage a frequently shifting work queue
  • 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
  • Knowledge of and passion for improving the health care industry a plus

Base Salary: $75,000 - $90,000

Nothing in this position description restricts management’s right to assign or reassign duties and responsibilities to this job at any time.

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.