Manager, Data Analyst

Judi Health, LLC; Denver (CO); Hybrid; USD 138,000 - 173,000; Full time

Job summary

Judi Health, LLC is seeking a Lead Underwriting Data Analyst to guide a team responsible for the data analytics used in underwriting and pricing for health benefits clients. The role involves managing data analysts, improving data quality, and delivering analyses for new and recontracting opportunities.

The position requires strong SQL, Python, and R skills, with experience in pharma claims data, ETL, and cloud data warehouses. Hybrid work with offices in NYC, Denver, and Charlotte is offered.

Qualifications

• Undergraduate degree with strong academic performance in quantitative field.
• 5+ years in data analysis including pricing/underwriting context.
• 1+ year of experience managing direct reports.
• 1+ year experience with pharmaceutical claims data.
• Expertise in SQL for data transformation and analysis with good documentation.
• Proficiency in Python and R.
• Knowledge of ETL fundamentals and cloud-based data warehouses.
• Experience with structured and unstructured data.
• Proven history of leading cross-functional initiatives and meeting deadlines.

Responsibilities

• Collect, clean, and analyze client pharmaceutical data to support underwriting and sales.
• Improve data quality, understand data fields, and reduce irregularities.
• Coordinate data requests with relevant parties for analysis needs.
• Troubleshoot and customize SQL, Python, and R code for data issues.
• Develop new analyses, reports, and process improvements for pricing models.
• Provide ad-hoc analytics support for bid opportunities.
• Support Pricing, Clinical, Account Management, and Implementation teams with analytics.
• Collaborate to maintain underwriting and financial modeling infrastructure and SOPs.
• Train new hires in underwriting data tools and processes.
• Manage and prioritize the Underwriting Data Analysts' work queue.
• Conduct QA reviews of ad hoc analyses and dashboards.
• Document processes, procedures, and best practices.

Skills

Data analysis

SQL proficiency

Python

R

ETL fundamentals

Cloud data warehouses

Structured data handling

Communication skills

Cross-functional collaboration

Time management

Education

Bachelor’s degree in Statistics, Economics, Finance, Business, CS, or a quantitative social science

Master’s degree preferred in related fields

Tools

SQL

Python

R

Tableau

Excel

ETL tools

Job description

About Judi Health

Judi Health is a health technology company providing benefit administration solutions to employers, unions, health plans, and government entities. Judi Health replaces fragmented, outdated systems with the industry's first Unified Claims Processing™ architecture, seamlessly consolidating pharmacy and medical benefit administration on a single, secure platform. By delivering true price transparency, eliminating unnecessary middleman fees, and leveraging advanced AI-powered care delivery, Judi Health helps clients achieve unprecedented operational efficiency and service levels. At Judi Health, we're deploying the infrastructure our country needs to deliver the healthcare we all deserve. We are the intelligence platform powering benefits plans for millions of Americans and proudly leading the next generation of care. To learn more, visit www.judi.health.

Location: Hybrid 3 days (offices in NYC, Denver, CO and Charlotte, NC area)

Position Summary

Lead Judi Rx’s Underwriting Data Analyst team in the day-to-day operations in support of underwriting for both new business opportunities and recontracting of current clients. Manage, train, and mentor the Underwriting Data Analyst team members in all facets of their roles, as well as act as the first POC and SME for all data-related questions for the greater Underwriting department. Directly contribute to and provide oversight over the Underwriting Data Analyst team’s infrastructure including maintaining existing functionality and leading the development of new features.

Position Responsibilities

• Collect, clean, process, and analyze potential and current clients’ pharmaceutical data – using SQL, Python, R, 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
• Coordinate with relevant parties regarding any data ambiguity and request any additional data elements that may be required or beneficial for analysis
• Troubleshoot and customize infrastructure code in SQL, Python, and R to diagnose and solve data or process issues
• Create custom code in SQL, Python, and R for improved or entirely new functionality in support of ad hoc requests and to further the development of our growing infrastructure
• Manage the development of new analyses, reporting, and process enhancements in support of pricing models for new and existing products
• Provide ad-hoc analytics support to the Underwriting team for the successful completion of all bid opportunities
• Provide analytics support to the Pricing, Clinical, Account Management, and Implementation teams to facilitate client transitions
• Collaborate with Leadership Team and other business functions (sales, marketing, account management) to develop and maintain internal underwriting, financial modeling, and financial reporting system infrastructure and SOPs
• Train and on-board new hires in Underwriting data, tools, and processes
• Manage a team of Underwriting Data Analysts as direct reports
• Manage the Underwriting Data Analyst work queue and assignments
• Provide QA review of all ad hoc analyses and custom views for both internal and external reporting purposes
• Establish and maintain team documentation on processes, procedure, and best practices

Required Qualifications

• Undergraduate bachelor’s degree, with record of strong academic performance in Statistics, Economics, Finance, Business, Computer Science, or a quantitative social science
• 5+ years of proven experience in data analysis, such as financial analysis, actuarial services, accounting, pricing & underwriting
• 1+ year of experience in managing direct reports
• 1+ year of experience working with pharmaceutical claims data
• Expertise in SQL for data transformation and data analysis with strong coding hygiene and documentation practices
• Proficiency in Python and R
• Working knowledge of ETL fundamentals and experience working with cloud-based data warehouses
• Experience working with structured and unstructured data
• Track record of leading cross-functional initiatives, driving high performance, meeting deadlines, and executing on deliverables
• Exceptional written and verbal communication skills
• Ability to prioritize and manage multiple complex projects simultaneously under a frequently shifting work queue
• Extremely flexible, highly organized, and able to shift priorities easily
• Attention to detail & commitment to delivering high-quality work products

Preferred Qualifications

• Master’s degree, with record of strong academic performance in Statistics, Economics, Finance, Business, Computer Science, or a quantitative social science
• Knowledge of medical claims data
• Knowledge of Tableau
• Knowledge of and passion for improving the health care industry

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

This 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, and skills, and location of the job.

New York, NY Salary Range: $150,800 USD - $188,500 USD

Denver, CO Salary Range: $138,000 USD - $172,500 USD

Charlotte, NC Salary Range: $125,600 USD - $157,000 USD

All employees are responsible for adherence to the Judi Health 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.

We 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 https://www.judi.health/legal/privacy-policy.