Manager, Data Analyst

Capital Rx Inc.; Denver (CO); Hybrid; USD 138,000 - 173,000; Full time

Job summary

Judi Health in Denver, CO is seeking a Lead Underwriting Data Analyst to drive day-to-day operations of the underwriting analytics team. You will manage, mentor, and serve as SME for data-related queries while guiding infrastructure development and new feature delivery.

The role requires 5+ years in data analysis, 1+ year of management, and strong SQL, Python, and R skills, plus experience with ETL and cloud data warehouses.

Qualifications

• Bachelor's degree in a quantitative field such as Statistics, Economics, Finance, Business, or CS.
• 5+ years of data analysis experience (financial/ actuarial/ pricing & underwriting).
• 1+ year of managing direct reports.
• Experience with pharmaceutical claims data.
• Proficiency in SQL for data transformation and analysis; good documentation practices.
• Proficiency in Python and R.
• Familiarity with ETL and cloud-based data warehouses.
• Experience handling structured and unstructured data.
• Strong cross-functional collaboration and communication.
• Ability to deliver multiple complex projects on deadlines.

Responsibilities

• Lead the Underwriting Data Analyst team in daily operations and project delivery.
• Mentor team members and serve as SME for data-related questions.
• Maintain and enhance data infrastructure and analytics features.
• Analyze pharmaceutical data to support underwriting and pricing.
• Develop analyses, reports, and SOPs for new and existing products.
• Coordinate data requirements with pricing, clinical, and account teams.
• Provide ad-hoc analytics support for bid opportunities.
• Ensure data quality and resolve data issues across datasets.
• Train new hires and manage the analytics work queue.
• QA review of analyses and dashboards for internal/external reporting.

Skills

SQL

Python

R

Excel

Data analysis

Leadership

ETL

Cloud data warehouses

Tableau

Education

Bachelor's degree in Statistics/ Economics/ Finance/ Business/ Computer Science

Master's degree (preferred)

Tools

Tableau

Cloud data warehouses

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