Underwriting Data Engineer

Judi Health is an enterprise health technology company providing a comprehensive suite of solutions for employers and health plans. The Underwriting Data Engineer organizes and analyzes raw data, builds data pipelines, and develops analytical programs and tools to enhance the analytic capability and reliability of the Underwriting, Rebate Administration, and Sales teams.

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 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 back-end systems for data extracts, pricing processes, and analytic tools to advance the department’s technical capabilities
• Model 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 analysis
• Troubleshoot and customize infrastructure code in SQL, R, and Python to diagnose and solve data or process issues
• Work closely with our Underwriting and Clinical teams to help build complex algorithms that provide useful insights into our data
• Assist 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 & reporting
• Collaborate with various teams across the company on data sources and analytic methodology in support of Underwriting, Rebate Administration, and company objectives
• Provide standard and ad-hoc analytics to support the Underwriting and Rebate Administration teams for the successful completion of bid opportunities and rebate payment management

Requirements:

• Undergraduate bachelor's degree (or equivalent) in Mathematics, Statistics, Economics, Computer Science, or IT
• 1+ year of experience with Python, SQL, and data visualization/exploration tools; R experience is a major plus
• 1+ year of proven experience in data analysis, such as financial analysis, actuarial services, accounting, pricing & underwriting
• Familiarity with the AWS ecosystem, specifically Redshift and RDS
• 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 is a plus