Underwriting Data Engineer
About Judi HealthJudi Health is an enterprise health technology company providing a comprehensive suite of solutions for employers and health plans, including:Capital Rx, a public benefit corporation delivering full-service pharmacy benefit management (PBM) solutions to self-insured employers,Judi Health, which offers full-service health benefit management solutions to employers, TPAs, and health plans, andJudi, the industry's leading proprietary Enterprise Health Platform (EHP), which consolidates all claim administration-related workflows in one scalable, secure platform.Together with our clients, we're rebuilding trust in healthcare in the U.S. and deploying the infrastructure we need for the care we deserve. To learn more, visit www.judi.health.Position Summary:The Underwriting Data Engineer organizes and analyzes raw data, builds data pipelines, and develops analytical programs & tools - using SQL, R, Python, etc. as appropriate - to enhance the analytic capability and reliability of the Underwriting, Rebate Administration, and Sales teams.Position Responsibilities:Thoroughly understand all Underwriting and 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 Underwriting, Rebate Administration, and Sales business goalsInvestigate new data sources for the purpose of building & maintaining data pipelines to clean, transform, and aggregate disparate dataUse agile software development to create, maintain, and improve back-end systems for data extracts, pricing processes, and analytic tools to advance the department's technical capabilitiesModel front-end views and back-end data sources to draw a comprehensive picture of the user experience and analytic pipelines throughout the system and to enable powerful data analysisTroubleshoot and customize infrastructure code in SQL, R, and Python to diagnose and solve data or process issuesWork closely with our Underwriting and Clinical teams to help build complex algorithms that provide useful insights into our dataAssist in the analysis and development of new models and front-end tools that can be used to make predictions and answer questions for financial modeling & reportingCollaborate with various teams across the company on data sources and analytic methodology in support of Underwriting, Rebate Administration, and company objectivesProvide standard and ad-hoc analytics to support the Underwriting and Rebate Administration teams for the successful completion of bid opportunities and rebate payment managementRequired Qualifications:Undergraduate bachelor's degree (or equivalent) in Mathematics, Statistics, Economics, Computer Science, or IT1+ year of experience with Python, SQL, and data visualization/exploration tools; R experience is a major plus1+ year of proven experience in data analysis, such as financial analysis, actuarial services, accounting, pricing & underwritingFamiliarity with the AWS ecosystem, specifically Redshift and RDSExperience in building or maintaining ETL processesExceptional technical knowledge in software engineering and programming languagesExcellent numerical, analytical, and problem-solving skillsTrack record of leading cross-functional initiatives, driving high performance, meeting deadlines, and executing on deliverables in a time-constrained environmentAbility to balance multiple complex projects simultaneouslyExceptional written and verbal communication skills, especially for explaining technical concepts to nontechnical business leadersExtremely flexible, highly organized, and able to shift priorities easilyAttention to detail & commitment to delivering high quality work productKnowledge of pharmaceutical claims is a plusThis range represents the low and high end of the anticipated base salary range. The actual base salary will depend on several factors such as: experience, knowledge, skills, and location of the job.Remote, US Salary Range$76,800$121,000 USDNew York, NY Salary Range$96,000$121,000 USDDenver, CO Salary Range$88,800$111,000 USDAll employees are responsible for adherence to the Capital Rx Code of Conduct including the reporting of non-compliance. 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.Judi Health 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.By submitting an application, you agree to the retention of your personal data for consideration for a future position at Judi Health. More details about Judi Health's privacy practices can be found at