Business Intelligence Analyst III -Population Health

About the role

We are a Colorado-based company dedicated to improving the health of our state. Our focus is on driving improvements in quality, member experience, outcomes, and cost. We are committed to diversity, equity, and inclusion.

Responsibilities

• Is the primary point of contact for department data requests.
• Works with multiple departments to gather information regarding requests.
• Serves as an integrated line of business team member ensuring that information needs are understood, complete specifications are identified, and the appropriate analysis, research, report, or other support is identified to address those needs.
• Analyzes and documents requirements through research, data gathering, and brainstorming activities.
• Designs and documents customer reporting and analytic requests by defining, creating, evaluating, and selecting alternatives.
• Serves as an integrated line of business team member ensuring that information needs are understood, complete specifications are identified, and the appropriate analysis, research, report, or other support is identified to address those needs.
• Develops and updates dynamic reports in Power BI, presents report results to Senior Management.
• Identifies actionable issues through data interpretation and research. Provides summary of trends, observations, and actionable items on complex reporting issues and development reports.
• Applies advanced data analysis and statistical techniques to answer any number of complex data questions and initiatives.
• Validates that output meets Line of Business needs.
• Promotes collaboration with Line of Business Directors to “dig deeper” into output and identifies areas of further analysis.
• Utilizes a variety of software applications and data sources to develop methodologies for the Population Health department.
• Actively develops new tools and system enhancements, troubleshoots and solves data issues.
• Sets out, identifies, documents, and initiates resolutions to data quality issues that are discovered during report and analysis development.
• Participates in available training programs and maintains an individual training/education strategy with immediate supervisor.
• In coordination with Department management, specific elements of the Company’s Strategic Plan will be identified as focus areas for this position and will be included as position responsibilities.

Qualifications

• Education: Bachelor’s degree in public health or health care related area, health informatics, data analytics, or statistics. Equivalent combination of experience and/or education may substitute with a preference for four years progressive relevant work experience.
• Experience: Minimum of five years’ experience in public health or healthcare data related field with at least four years of SQL experience. Significant and demonstrated experience with advanced data reporting and analysis methods, data management and query tools including the use of Toad, SSMS, SSRS, Power BI, Business Objects, Tableau, Python, or other similar tools required. Experience analyzing healthcare claims, encounter, utilization, or clinical/quality data required. Experience with population health analytics, risk stratification, or value-based care reporting preferred. Exposure to predictive analytics is a plus.
• Knowledge, Skills, and Abilities: Expert understanding of health benefits, medical terminology, medical procedures, and managed care industry; expertise with CPT, ICD and other coding systems; demonstrated analytical, problem solving, and research ability as evidenced by experience in the identification of requirements and the definition, evaluation, and selection of appropriate solutions to business problems or opportunities. Ability to pivot and respond quickly with complicated ad hoc analyses of claims, membership, and publicly available health data, and other data sources, as needed. Demonstrates support for the company’s mission, vision and values. Position requires excellent written and verbal communication skills. Demonstrated ability for turning complicated verbal requests into reports and queries; ability to interpret complex data results and effectively summarize information that can be easily translated into company action. Must have strong interpersonal and teamwork skills with good organizational and time management skills. May be required to manage multiple priorities and projects with tight deadlines. Must be proficient in MS-Office applications (Excel, Access, Word, Power Point).

Skills

• Expert understanding of health benefits, medical terminology, medical procedures, and managed care industry; expertise with CPT, ICD and other coding systems; demonstrated analytical, problem solving, and research ability as evidenced by experience in the identification of requirements and the definition, evaluation, and selection of appropriate solutions to business problems or opportunities.
• Ability to pivot and respond quickly with complicated ad hoc analyses of claims, membership, and publicly available health data, and other data sources, as needed.
• Demonstrated ability for turning complicated verbal requests into reports and queries; ability to interpret complex data results and effectively summarize information that can be easily translated into company action.
• Strong interpersonal and teamwork skills with good organizational and time management skills.
• Proficient in MS-Office applications (Excel, Access, Word, Power Point).
• Exposure to predictive analytics is a plus.

Benefits

The compensation for this position is $94,600.00 - $126,200.00 annually. Colorado Access has provided a compensation range that represents its good faith estimate of what Colorado Access may pay for the position at the time of posting. Colorado Access may ultimately pay more or less than the posted compensation range. The salary offered to the selected candidate will be determined based on factors such as the qualifications of the selected candidate, departmental budget availability, internal salary equity considerations, and available market information, but not based on a candidate’s sex or any other protected status. In addition to being part of a mission driven organization serving our community, as an eligible Colorado Access employee, you’ll receive a generous benefits package, that includes:

• Medical, dental, vision insurance that starts the first day of the month following start date.
• Supplemental insurance such as critical illness and accidental injury.
• Health care and dependent care flexible spending account options.
• Employer-paid basic life insurance and AD&D (employee, spouse and dependent).
• Short-term and long-term disability coverage.
• Voluntary life insurance (employee, spouse, dependent).
• Paid time off.
• Retail plan.
• Annual bonus program (based on eligibility, requirements and performance).