Business Intelligence Analyst I- Finance

The vision of Colorado Access is to have healthy communities transformed by the care that people want at a cost we can all afford.  Our mission is to partner with communities and empower people through access to quality, affordable care.

Why should you consider a career with Colorado Access?

We are a Colorado-based company, working to improve the health of our state. We care for individuals, families, and children who receive health care under Child Health Plan Plus (CHP+) and Health First Colorado (Colorado's Medicaid Program). Our focus is driving improvements in quality, member experience, outcomes, and cost. We are a mission-driven organization whose foundation is built by our vision, supported by our values and pillared by diversity, equity and inclusion.

1. Find work/life balance:  We offer PTO, floating holidays, nine company paid holidays, a hybrid work environment, an Employee Assistance Program and a 401K.
2. Be a part of something bigger and make an impact: We serve the underserved and most vulnerable populations in our community through access to quality and affordable health care. No matter what you do for Colorado Access, you are impacting our community and making a difference.
3. Sharpen your skills, learn, and grow: We support your continued development through tuition reimbursement, leadership training, promotion opportunities, performance evaluations, employee recognition, and a language pay stipend.

 

What you will do:

We are looking for a BUSINESS INTELLIGENCE ANALYST I- FINANCE who can help shape our vision and support our mission. Here is what the position will look like.

• Partner with Finance and cross-functional stakeholders to transform low to moderate level business requests into accurate and actionable business intelligence solutions.
• Develop a foundational understanding of managed care, internal financial and operational data, and Colorado Access’s key performance drivers.
• Design, develop, and maintain recurring and ad hoc financial and operational reports, dashboards, and analyses using SQL, Power BI, SQL Server Reporting Services (SSRS), and Excel.
• Develop and maintain moderately complex SQL queries to extract and analyze financial, claims, enrollment, capitation, and utilization data.
• Identify actionable insights through data analysis, research, and interpretation. Provides a summary of trends, observations, and actionable items on standard and ad hoc requests.
• Ensure accuracy, integrity, and consistency of data through validation, reconciliation, and quality assurance processes.
• Identify, document, and assist in resolving data quality issues.
• Assist in automating reporting processes and improving data workflows
• Maintain documentation of reports, data sources, business logic, and analytical methodologies.
• In coordination with department management, support designated elements of the Company’s Strategic Plan as identified focus areas for this position.

 

What you will bring:

Education:

• Bachelor’s degree in healthcare-related field, statistics, computer science, information systems, finance, accounting, or related field.
• Equivalent combination of experience and/or education may be considered in lieu of a bachelor’s degree.

 

Experience:

• Experience with SQL, including writing and modifying queries to retrieve and analyze data.

• Foundational understanding of relational databases, such as SQL Server.
• Exposure to BI and data visualization tools (e.g., Power BI, SSRS, Excel, Business Objects, or similar platforms).
• Experience with healthcare or behavioral health data is a plus.

 

 

Knowledge, Skills, and Abilities:

• Proficiency with Microsoft Office applications, including Word, Excel, PowerPoint, Outlook, and Teams.
• Ability to analyze and interpret complex data patterns and trends.
• Strong analytical, problem-solving, and critical-thinking abilities, with attention to detail and data accuracy.
• Excellent written and verbal communication skills, capable of translating complex business questions into clear requirements and effective data solutions.
• Must have strong interpersonal and teamwork skills, supported by good organizational and time management. 
• Ability to manage multiple priorities and projects with tight deadlines. 
• General understanding of health benefits, medical terminology, medical procedures, and the managed care industry is a plus
• Familiarity with CPT, ICD and other medical coding systems is a plus

 

 

Licenses/Certifications: A valid driver's license and proof of current auto insurance will be required for any position requiring driving.

 

 

 

Together we will be: an innovative and collaborative team who supports each other, the employees and vision of the company to reach our goals individually, together and as an organization.

 

Pay, Perks and Benefits at Colorado Access:

The compensation for this position is $78,200.00 - $88,800.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
• Retirement plan
• Tuition reimbursement (based on eligibility). 
• Annual bonus program (based on eligibility, requirements and performance).

 

Where you will work:

This position will be a hybrid model work environment, a blend of ‘In-Office’ and ‘Remote.’ 

 

 

We are not able to support out of state employees at this time as we continue to serve our members and community in the metro Denver area and across the beautiful state of Colorado.

Colorado Access is committed to providing equal opportunities to all people regardless of race, color, national origin, age, sex, genetic information, religion, pregnancy, disability, sexual orientation, veteran status or any other status protected by applicable law. We strive to maintain a work environment that is free from unlawful harassment and discrimination.