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.
Skills Required
- Bachelor’s degree in Computer Science, Data Science, Healthcare Informatics, Finance, or a related field; equivalent professional experience may substitute.
- Minimum 4 years of experience in data analytics or business intelligence.
- Advanced SQL and T-SQL skills.
- Experience with Snowflake or comparable cloud data platforms.
- Experience with ETL tools, including SSIS.
- Experience with business intelligence tools and dashboard development.
- Experience with RPA tools such as Power Automate or equivalent.
- Strong Microsoft Excel skills.
- Experience with AthenaHealth or other EHR systems.
- Healthcare analytics experience.
- Critical thinking and problem-solving skills.
- Ability to manage multiple deadlines with strong attention to detail.
- Strong communication and stakeholder collaboration skills.
What We Do
Circle the City is a nonprofit Federally Qualified Health Center in Maricopa County, Arizona, providing primary care, mobile medical services, and Arizona's only medical respite centers for people experiencing homelessness. The organization offers beds, 24/7 nursing, daily care, case management and connections to housing and resources, serving thousands annually with a mission to deliver compassionate, innovative healthcare to individuals facing homelessness.
