Circle the City
Senior Data Analyst – Circle the City
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 (Power Automate or equivalent); strong Excel; experience with Athena Health/EHR systems.
Analytical & Interpersonal Skills : Critical thinking, problem‑solving, ability to manage multiple deadlines, high attention to detail, and strong communication skills.
Physical & Other Requirements : Prolonged periods of sitting/standing; occasional lifting up to 20 lbs; ability to manage stress, multitask, and adapt in a dynamic environment while demonstrating commitment to serving vulnerable and underserved populations.
#J-18808-Ljbffr
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 (Power Automate or equivalent); strong Excel; experience with Athena Health/EHR systems.
Analytical & Interpersonal Skills : Critical thinking, problem‑solving, ability to manage multiple deadlines, high attention to detail, and strong communication skills.
Physical & Other Requirements : Prolonged periods of sitting/standing; occasional lifting up to 20 lbs; ability to manage stress, multitask, and adapt in a dynamic environment while demonstrating commitment to serving vulnerable and underserved populations.
#J-18808-Ljbffr