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 to 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.

Requirements

Proficient in SQL; Knowledgeable in Python and R
1+ years of proven experience in data analysis (academic or professional)
Exceptional written and verbal communication skills
Extremely flexible, highly organized, and able to shift priorities easily
Ability to balance multiple complex projects simultaneously and manage a frequently shifting work queue

Benefits

You will make a tangible impact on society. Your work will directly improve healthcare experiences for millions as we code new analyses and data views.
We are a late-stage startup with stability. We have startup energy with a focus on delivery, but healthy processes with a strong financial outlook that provides a sense of security.
There is so much to learn—both in terms of data analysis and coding, and in terms of the broader health care industry.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills

SQLPythonRdata analysisdata cleaningdata processingdata qualityanalytics supportreportinginfrastructure code

Soft skills

written communicationverbal communicationflexibilityorganizational skillsprioritizationproject managementadaptabilityattention to detailproblem-solvingcollaboration