What are the responsibilities and job description for the Data Analyst position at Calance?
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 skills.
- Strong analytical, problem-solving, and logic skills.
- Excellent customer service and communication abilities.
- Ability to work independently and collaboratively in a fast-paced environment.
- Familiarity with healthcare data standards (ICD, CPT, HL7, FHIR) is a plus. Knowledge of computer programming or experience with analytic software.
- Ability to conduct research into a wide range of computing or health regulatory issues as required.
- Ability to absorb and retain information quickly.
- Highly self motivated and directed.
- Keen attention to detail.
- Proven analytical and problem-solving abilities; sound judgment.
- Ability to effectively prioritize and execute tasks in a high-pressure environment.
- Experience working in a team-oriented, collaborative environment.
- Able to quickly build and maintain rapport with co-workers of differing backgrounds; team player. Ability to present ideas in user-friendly language.
- Positive professional insight
- Flexibility and dependability
SHIFT: Mon-Fri, 8am-5pm PST, Fully Remote (Candidates must live within 30 minutes of job site)
WORK AUTHORIZATION:
U.S. Citizen or Green Card
Salary : $60 - $70