Sr. Data Analyst

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

Job summary

Circle the City in Phoenix seeks a Senior Data Analyst to transform clinical, financial, and operational data into actionable insights. You will manage the Enterprise Data Warehouse, build dashboards, and provide fact-based analysis from AthenaHealth and other systems to support leadership, regulatory submissions, and grant reporting.

The role emphasizes data governance, HIPAA compliance, and cross-functional collaboration with IT, Finance, Operations, and Clinical teams.

Qualifications

• Bachelor's degree or equivalent in a related field with healthcare analytics experience preferred.
• Strong SQL/T-SQL proficiency and Snowflake experience.
• Experience with AthenaHealth or EHR data sources and healthcare reporting.
• Excellent communication and cross-functional collaboration skills.

Responsibilities

• Design, optimize, and document data structures in Snowflake.
• Develop and maintain T-SQL procedures and SSIS ETL workflows.
• Build dashboards and monthly KPI reports for leadership and teams.
• Provide ad-hoc analytics for audits, funders, and regulatory reports.

Skills

Advanced SQL/T-SQL

Snowflake

ETL tools (SSIS)

BI tools

RPA (Power Automate)

Excel

AthenaHealth data access

Education

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

Tools

SSIS

Power Automate

AthenaHealth

Job description

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 & ResponsibilitiesData 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.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.