Sr. Healthcare Programmer Analyst

## Senior Healthcare Programmer/Analyst ## Position Summary The Senior Healthcare Programmer/Analyst is a data-driven professional responsible for designing and executing complex SQL queries to extract, transform, and analyze large volumes of healthcare data. This role develops and delivers analytical reports for Health Plans, including ODAGs, Part C, Denial Logs, and Inpatient Referral Universes, while identifying trends and insights that support data-informed decision-making. ## Essential Duties and Responsibilities - Generate a high volume of monthly, quarterly, and ad hoc reports for Health Plans. - Develop and maintain report formats based on Health Plan templates, including ODAGs, Part C, Denial Logs, and Inpatient Referral Universes. - Automate report generation through the design and scheduling of SSRS reports to ensure timely and accurate delivery. - Maintain and enhance Tableau dashboards to monitor authorization turnaround times and denial rates. - Clean, validate, and reconcile source data to ensure accuracy and integrity of reporting outputs. - Translate complex analytical findings into clear, actionable insights and intuitive visual dashboards. - Perform complex data analysis using advanced critical thinking and problem-solving skills. - Manage and prioritize multiple projects while proactively communicating workload, risks, and deadlines to management. - Respond to end-user requests for report customization, enhancements, and troubleshooting. - Communicate clearly and professionally with stakeholders at all levels of the organization. - Consistently deliver accurate, high-quality work within established timelines. - Collaborate with cross-functional teams to achieve shared goals and ensure data consistency. - Perform additional duties as assigned to support team and organizational objectives. ## Compensation The pay range for this position at commencement of employment is expected to be between $115,000 year to $125,000 year; Base pay may vary depending on factors including market location, job-related knowledge, licensure, skills, and experience. The total compensation package may also include additional elements such as a sign-on bonus and discretionary awards, along with a comprehensive benefits package including medical, financial, and other benefits (such as 401(k) eligibility and paid time off, including vacation, sick leave, and parental leave). Details will be provided upon offer of employment. This is an at-will position. The Company reserves the right to modify compensation and benefits at any time based on individual performance, organizational needs, and market factors. ## About the Organization As one of the fastest-growing Independent Physician Associations in Southern California, Regal Medical Group, Lakeside Community Healthcare, and Affiliated Doctors of Orange County offer a fast-paced, supportive, and collaborative work environment. The organization promotes teamwork, encourages professional development, and provides opportunities for career advancement. ## Benefits **Health and Wellness** - Employer-paid medical, pharmacy, and dental coverage - Vision insurance - Zero copay for employed physician office visits - Flexible Spending Account (FSA) - Employer-paid life insurance - Employee Assistance Program (EAP) - Behavioral health services **Savings and Retirement** - 401(k) retirement savings plan - Income protection insurance **Additional Benefits** - Vacation time - Paid holidays and sick leave - Tuition reimbursement - License renewal and CEU reimbursement program - Employee referral bonus - Mileage reimbursement - Company events and celebrations - Business-casual work environment ## Equal Opportunity Statement The employer will consider qualified applicants with criminal histories in a manner consistent with the requirements of the Los Angeles Fair Chance Initiative for Hiring Ordinance. ## Education and Experience - Strong familiarity with healthcare analytics. - Minimum of 3 years of SQ…