JobCubby JobCubby
Sign up
CIRCLE THE CITY

Sr. Data Analyst

CIRCLE THE CITY Phoenix, Arizona, United States

Hospitals and Health Care · 201-500 employees

Oct 15
data-analyst Mid (2-5 yrs) Other United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.

About the role

The Senior Data Analyst manages the Enterprise Data Warehouse and transforms clinical, financial, and operational data into actionable insights. They are responsible for building dashboards, automating workflows, and supporting leadership with regulatory and grant reporting.

What they look for

SQL T-SQL Snowflake ETL SSIS Business Intelligence Data Warehousing RPA PowerAutomate AthenaHealth Healthcare Analytics Data Governance HIPAA Excel Reporting Data Integration

Requirements

Candidates must have a bachelor's degree in a relevant field and at least 4 years of experience in data analytics or business intelligence. Proficiency in SQL, cloud data platforms, ETL tools, and healthcare EHR systems is required.

Full description

Job Details: Job Location: Admin Office - Phoenix, AZ, Salary Range: Undisclosed, Summary of Position:  

The Senior Data Analyst transforms clinical, financial, and operational data into actionable insights that drive strategic decision-making across Circle the City. Leveraging expertise in database management, business-intelligence tools, automation, and healthcare analytics, the role manages the Enterprise Data Warehouse, builds dashboards, and provides fact-based analysis from AthenaHealth and other systems to support leadership, regulatory submissions, and grant reporting.

Essential Duties & Responsibilities

 

Data Management & Integration - Design, optimize, and document data structures in Snowflake (or equivalent). - Develop and maintain T-SQL procedures and secure EDI workflows (SSIS, HL7, SFTP). - Reconcile data from disparate sources and troubleshoot anomalies.

Business Intelligence & Reporting - Build and enhance dashboards for leadership and teams. - Create and maintain monthly KPI dashboards and ad-hoc reports. - Produce monthly revenue and cumulative revenue analyses to support Finance month-end close. - Generate regular patient-encounter and patient-count reports; track patient bed-days for Respite locations. - Provide annual regulatory datasets (UDS, AHCCCS Reconciliation, audits) and quarterly grant/funder reports (e.g., City of Tempe/Mesa).

Automation & Process Optimization - Develop and manage RPA workflows to automate repetitive data tasks. - Identify new automation opportunities across departments and lead implementation efforts.

Analytics & Stakeholder Support - Serve as a liaison between IT, Finance, Operations, and Clinical teams to translate data requirements into solutions. - Provide ad-hoc analytic support for leadership, funders, and audits; explain data anomalies, benchmark shifts, and insights to non-technical stakeholders. - Act as a resource for extracting data from AthenaHealth and other databases.

Compliance, Governance & Security - Uphold data governance, HIPAA, HiTrust, and Circle the City security standards. - Maintain audit trails, access controls, and data-quality programs.

 Qualifications: Education & Experience - Bachelor's degree in Computer/Data Science, Healthcare Informatics, Finance, or related field; minimum 4 years in data analytics/BI, healthcare preferred. Equivalent professional experience may substitute for degree.

Technical Skills - Advanced SQL/T-SQL; Snowflake or comparable cloud data platforms; ETL tools (SSIS); BI tools; RPA (PowerAutomate or equivalent); strong Excel; experience with AthenaHealth/EHR systems.

Analytical & Interpersonal Skills - Critical thinking, problem-solving, ability to manage multiple deadlines, high attention to detail, and strong communication skills.

Similar roles