Business Intelligence Analyst. Fort Collins Move Collective

Business Intelligence Analyst

Salary Range: $89,648 - $125,507 annually based on relevant years of experience

Location: Larimer County, Colorado

Employment Type: Full time, 40 hours per week

Hours: Monday–Friday

Responsible for transforming healthcare and organizational data into actionable insights through the design, development, and delivery of analytic and reporting solutions. Supports all levels of the organization by interpreting, organizing, and communicating data in meaningful ways that inform operational, clinical, and strategic decisions. Translates complex business and clinical processes into intuitive, efficient data structures using SQL and business intelligence tools such as Power BI.

Determines and documents requirements, develops queries and visualizations, and applies professional judgment to recommend data solutions and presentation methods. Demonstrates strong collaboration and communication skills by engaging with internal stakeholders to ensure data is accurate, accessible, and aligned with organizational priorities.

• Design, build, enhance, and maintain reports, dashboards, and data models through direct interaction with business and clinical users.
• Develop and maintain formal and ad hoc reports in support of internal programs, grants and external agencies (including quality and state reporting).
• Conduct complex and detailed data analysis to identify, interpret, and communicate trends, anomalies and actionable insights to support decision‑making.
• Perform ad hoc and formal data extraction and analysis using T‑SQL within the Data Warehouse environment.
• Perform data analysis and reporting using EPIC tools such as Slicer Dicer or Clarity, ensuring consistency and accuracy across platforms.
• Contribute to the development and continuous improvement of BI and reporting standards, procedures, and documentation.
• Execute data validation and quality assurance processes in support of data governance initiatives and compliance with reporting requirements.
• Collaborate with cross‑functional teams to understand data needs, define metrics and design scalable analytic solutions that support clinical, financial, and operational outcomes.
• Maintain awareness of industry best practices and emerging BI technologies relevant to healthcare data analytics.
• Perform other duties as assigned.

• Bachelor’s degree in healthcare, Informatics, Finance, Business, Computer Science, or related field required.
• More than four years of proven experience developing data and reporting solutions in a healthcare or similarly complex environment required.
• More than two years of experience working with Power BI or similar business intelligence platform required.
• Proven experience working with healthcare‑related data—including EHR/EMR systems, claims, quality, and financial sources—with a solid understanding of applicable privacy and security standards required.
• Equivalent combination of education and experience may be evaluated and considered.

• EPIC Certification – Report Writer (Clarity / Caboodle) preferred.
• Bilingual/bi‑cultural preferred.

• Medical, dental, and vision coverage – including options for eligible dependents.
• Mental health and wellness resources.
• Short‑term and long‑term disability insurances.
• Paid time off (PTO):
  Accrued vacation and personal leave based on FTE status and length of service.
• Paid Sick Leave:
  Provided in accordance with the Colorado Healthy Families and Workplaces Act (HFWA).
• A range of voluntary benefits available to all employees.
• 403(b) retirement plan with employer matching contributions.

All employees are required to receive an annual flu vaccination or have an approved exemption in place and wear a mask during flu season.

Summit Stone will provide persons with disabilities with reasonable accommodations. If reasonable accommodation is needed to participate in the job application or selection process, please let your recruiter know.