Position Summary
The Senior Data Analyst is responsible for supporting organizational decision-making through the development of reliable reporting, data analysis, and documentation of systems and data structures. This role works across clinical, operational, and financial datasets to produce accurate, actionable insights and maintain a clear understanding of how data flows across systems.
The position requires strong technical skills in SQL and Tableau, along with the ability to work with complex relational data environments, including behavioral health EHR systems. A key focus of this role is ensuring data clarity and consistency by documenting existing data sources, reporting logic, and system relationships, enabling more effective and scalable analytics across the organization.
This role partners with stakeholders across Marketing, Customer Care, Finance, Clinical Operations, and IT to deliver reporting and analysis that supports day-to-day operations and ongoing performance improvement.
Key Responsibilities
Data Analysis and Reporting
- Develop, maintain, and enhance Tableau dashboards and reports supporting referral tracking, intake performance, clinician activity, and program metrics.
- Write and optimize SQL queries to extract, join, and transform data from complex relational databases.
- Produce recurring and ad hoc reports to support operational and strategic decision-making.
- Ensure accuracy and consistency of reported data through validation and reconciliation processes.
Data Systems Documentation and Structure
- Document current data systems, including data sources, table structures, field definitions, and relationships across systems.
- Maintain clear documentation of reporting logic, metric definitions, and calculation methodologies.
- Identify gaps or inconsistencies in data structures and escalate opportunities for improvement.
- Support the development and maintenance of data dictionaries and internal documentation resources.
Data Quality and Integrity
- Perform regular audits to identify data inconsistencies, missing values, or reporting discrepancies.
- Partner with IT and operational teams to investigate and resolve data quality issues.
- Ensure alignment between source system data (e.g., EHR, CRM, billing systems) and reporting outputs.
Cross-Functional Support