Sr. Data Analyst (60854)

Circle the City; Phoenix (AZ); On-site; USD 90,000 - 120,000; Full time

Job summary

Circle the City in Phoenix, AZ is seeking a Senior Data Analyst to transform clinical, financial, and operational data into actionable insights that drive strategic decisions. You will manage the data warehouse, build dashboards, and provide analysis from AthenaHealth and other systems to support leadership, regulatory submissions, and grant reporting.

The role requires expertise in SQL/T-SQL, Snowflake, ETL/EDI workflows, BI tools, and RPA, with a focus on data governance and security aligned

Qualifications

• Bachelor’s degree in Computer/Data Science, Healthcare Informatics, Finance, or related field; minimum 4 years in data analytics/BI.
• Equivalent professional experience may substitute for degree.

Responsibilities

• Design, optimize, and document data structures in Snowflake (or equivalent).
• Develop and maintain T-SQL procedures and secure EDI workflows (SSIS, HL7, SFTP).
• Build and enhance dashboards for leadership and teams.
• 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.

Skills

Advanced SQL

Analytical thinking

Communication

Attention to detail

Multitasking

Education

Bachelor’s degree in Computer/Data Science, Healthcare Informatics, Finance, or related field

Tools

Snowflake

SSIS

BI tools

Power Automate

Excel

AthenaHealth

Job description

Job Details: Job Location: Admin Office - Phoenix, AZ 85013, 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.