Manager, Data Analyst

Judi Health, LLC; Colorado; 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 pharma data analysis in support of underwriting, pricing, and client transitions. You will mentor analysts, oversee data infrastructure, and build new analytics features on an expanding platform.

The role requires strong SQL, Python, and R skills, plus experience with ETL and cloud data warehousing. This is a hybrid position with offices in NYC, Denver, and Charlotte, NC, offering ownership of data

Qualifications

• Undergraduate degree in Statistics, Economics, Finance, Business, CS, or a quantitative field.
• 5+ years in data analysis (finance, actuarial, pricing, underwriting).
• 1+ year managing direct reports.
• 1+ year working with pharmaceutical claims data.
• Expert SQL for data transformation with strong hygiene and docs.
• Proficiency in Python and R.
• Knowledge of ETL fundamentals and cloud-based data warehouses.
• Experience with structured and unstructured data.
• Track record leading cross-functional initiatives and meeting deadlines.
• Excellent written and verbal communication skills.
• Ability to prioritize multiple complex projects in shifting queues.
• Extremely flexible, organized, and able to shift priorities.
• Attention to detail and delivering high-quality work.

Responsibilities

• Collect, clean, process, and analyze client pharma data using SQL, Python, and R to support underwriting and sales.
• Understand data fields, identify irregularities, and improve data quality and intake.
• Coordinate with teams for data ambiguity and request additional elements as needed.
• Troubleshoot and customize SQL, Python, and R code to diagnose data/process issues.
• Create new analytics and code in SQL, Python, and R for ad hoc requests.
• Support pricing models with new analyses, reporting, and process improvements.
• Provide ad-hoc analytics support to underwriting for bid opportunities.
• Assist Pricing, Clinical, Account Management, and Implementation teams with transitions.
• Collaborate to develop and maintain internal underwriting, financial modeling, and SOPs.
• Train and onboard new hires in underwriting data, tools, and processes.
• Manage a team of Underwriting Data Analysts and their queue.
• Provide QA review of analyses and dashboards for internal/external reporting.
• Maintain team documentation on processes and best practices.

Skills

SQL

Python

R

Excel

Data analysis

Leadership

Project management

Communication

ETL

Cloud DW

Tableau

Pharma data

Education

Bachelor's degree

Master's degree

Tools

Tableau

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 - $188,500 USD

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

Charlotte, NC Salary Range $125,600 - $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.