Job Details

Lead Data Analyst – Programming and Analytics

About This Role

Requisition #20413

Employment Type

Full Time

Location

Full Time - Hybrid, Minimum 2 Days Onsite at 445 Grant Avenue, San Francisco, CA 94108

Education

Bachelor's Degree in Computer Science or 6+ years' experience in a related field.

Experience

Minimum of 5 years of data reporting analysis experience

Pay Scale: Ranging from $91,478-$129,189 per year

The salary of the selected finalist will be determined based on various factors including experience, education, and training. This pay scale does not guarantee a specific wage.

Position Summary

This role involves designing and developing programs and reports in a Microsoft-centric environment, utilizing tools such as MS SQL, T-SQL, SSRS, SSIS, and C#.NET. The analyst will provide accurate, complex analysis-based information, working independently and communicating effectively in a fast-paced healthcare setting, preferably with experience in health plan payer environments.

Primary Responsibilities

• Lead and mentor a team of Data Analysts, overseeing projects and providing strategic insights.
• Develop and review reports to meet health plan requirements, ensuring compliance and supporting data-driven decisions.
• Provide analytical support for departments, focusing on enrollment, membership, payments, claims, provider networks, and utilization management.
• Generate reports complying with regulations such as HIPAA, CMS guidelines, and state laws.
• Collaborate with internal and external stakeholders to design solutions, document reports, and respond to ad hoc queries.
• Interact daily with IT and business departments on various issues.
• Contribute to architecture and design of internally developed solutions.
• Maintain records and logs of support activities.
• Address enrollment-related changes, backend logic, ETL, and reporting issues.
• Serve as SME for complex enrollment issues and oversee reconciliation processes.
• Work with business leaders to improve processes and resolve issues.
• Develop and update workflows and guides for better efficiency.
• Manage and train staff to ensure team success.
• Perform other duties as assigned by the IT Manager.

Professional Development

• Maintain and develop skills through training, reading, and participation in IT organizations.
• Provide training and support to staff and users to develop in-house expertise.

Qualifications

• Bachelor's Degree in Computer Science or 6+ years' experience.
• Extensive experience (3-4 years) with programming languages and reporting tools such as C#.NET, SQL Server, SSIS, SSRS, Crystal Reports, etc.
• Healthcare experience, especially in health plan payer settings, with knowledge of enrollment, claims, provider networks, and utilization management.
• Proficiency with MSSQL or similar relational databases and Data Warehouse concepts.
• At least 5 years of data reporting analysis experience.
• Strong documentation skills for workflows, data sources, and procedures.
• Proactive approach to automation and process improvement.
• Ability to handle sensitive information with confidentiality.
• Effective verbal and written communication skills.
• Good planning and organizational skills.
• Highly proficient in ETL and SSIS processes.

Join Our Team

If you are passionate about community health and interested in this role, please contact us at ...@chasf.org. We are always looking for talented individuals to join our team.