Data Analyst
Company: Calance
Location: Fresno, CA (Remote)
Type: Full-time
Remote: Yes
Posted: 2026-06-09
About this role
SUMMARY:
The Data Analyst position plays a critical role by delivering accurate, timely, and actionable data across operational, financial, billing, and clinical domains. This position blends traditional data analysis responsibilities with foundational data engineering tasks, including data pipeline development, SQL optimization, and system integration.
SUMMARY OF RESPONSIBILITIES:
- Develop and maintain reports and dashboards to support clinical, operational, and financial decision-making.
- Respond to data requests using PowerBI or custom SQL queries when necessary.
- Validate and document data accuracy before report delivery.
- Collaborate with stakeholders to understand reporting needs, KPIs, and performance metrics.
- Provide end-user support for self-service reporting platforms and educate staff on data interpretation.
- Maintain a repository of SQL scripts, report inventories, PowerBI models and documentation for repeatable use.
- Build and maintain ETL/ELT processes to extract, transform, and load data from systems such as athenaOne, athenaOne Dental, and other healthcare platforms.
- Support internal data mapping and integration efforts for new and existing implementations.
- Optimize SQL queries and database performance to improve report generation and data accessibility.
- Assist in the development and maintenance of data models and schemas for reporting databases.
- Interface with external systems and APIs to support data interoperability and reporting needs.
PRIOR EXPERIENCE:
- Experience with athenaOne and athenaOne Dental workflows and reporting tools desired
- Familiarity with HRSA reporting requirements for FQHCs.
- Experience with Microsoft Power Platform solutions such as PowerBI and PowerAutomate desired
- Experience with Microsoft SQL desired
- Experience in healthcare operations or financial reporting desired
SKILLS:
- Proficiency in SQL and data visualization tools (e.g., Power BI, Tableau).
- Intermediate to advanced Microsoft Excel sk...