Colorado Access · 12 hours ago
Business Intelligence Analyst II - Finance
Denver, CO
Full-time
Hybrid
Entry, Mid Level
$86K/yr - $97K/yr
2+ years expColorado Access is a Colorado-based company dedicated to improving the health of communities through access to quality, affordable care. They are seeking a Business Intelligence Analyst II - Finance who will partner with Finance and stakeholders to deliver actionable business intelligence solutions and support the company's mission through data analysis and reporting.
FitnessHealth CareNon Profit
Responsibilities
Partner with Finance and cross-functional stakeholders to understand analytical and reporting needs and deliver accurate, actionable business intelligence solutions
Gather, analyze, and document reporting and analytical requirements through research, data analysis, and stakeholder collaboration
Translate complex internal and external business intelligence requests into high-quality analytical products using the most credible and efficient data sources
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, optimize, and maintain complex SQL queries, stored procedures, and views to extract, transform, and analyze financial, claims, enrollment, capitation, and utilization data
Analyze complex datasets to identify trends, variances, risks, and opportunities related to budgeting, forecasting, rate setting, claims billing, cost analysis, and overall financial performance
Support rate-setting activities under the guidance of the Manager of Financial Analysis
Ensure accuracy, integrity, and consistency of data through validation, reconciliation, and quality assurance processes
Identify, document, and assist in resolving data quality issues
Identify opportunities to automate reporting processes, improve data workflows, and enhance self-service analytic capabilities
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
Qualification
Required
Bachelor's degree in a healthcare-related area, statistics, computer science, information systems, finance, accounting, or related field
A minimum of 2 years' experience working in a data-focused role, leveraging data to inform business decisions
2 years' experience with SQL is required with a preference for advanced SQL experience and SQL Server
Experience developing reports and dashboards using BI and data visualization tools (e.g., Power BI, SSRS, Excel, Business Objects, or similar platforms) is required
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
Capable of translating complex business questions into clear requirements and effective data solutions
Strong SQL skills with the ability to write and optimize complex queries (e.g., subqueries, window functions, temp tables, CTEs, etc.)
Demonstrates support for the company's mission, vision and values
Proficiency with Microsoft Office applications, including Word, Excel, PowerPoint, Outlook, and Teams
Excellent written and verbal communication skills
Strong interpersonal and teamwork skills, supported by good organizational and time management
Ability to manage multiple priorities and projects with tight deadlines
A valid driver's license and proof of current auto insurance will be required for any position requiring driving
Preferred
A background in healthcare or finance is a plus
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
Benefits
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).
Company
Colorado Access
Colorado Access are a nonprofit health plan that provides access to behavioral and physical health services for Coloradans.
201-500 employees
Funding
Current Stage
Growth StageLeadership Team
A
April Abrahamson
Chief People and Talent Development Officer
Jaime Moreno
Chief Communications and Members Experience Officer
Recent News
Guardian Recovery - CuraWest
2025-11-25
Company data provided by crunchbase