Senior Data Analyst: Healthcare BI & EHR Dashboards

South Coast Community Services; Mission Viejo (CA); Hybrid; USD 100,000 - 125,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

South Coast Community Services in Southern California is seeking a Senior Data Analyst to support decision‑making through reliable reporting, data analysis, and documentation of data structures. This role works with behavioral health EHR data and collaborates with Marketing, Finance, Clinical Operations, and IT to deliver accurate insights.

You will build and optimize Tableau dashboards, write complex SQL queries, and document data sources and workflows to ensure data clarity, integrity, and

Qualifications

• Bachelor’s degree in quantitative fields such as data analytics, statistics, mathematics, health informatics, or related discipline.
• 3–5 years of experience in a data analyst or similar role.
• Strong proficiency in SQL, including complex joins, aggregations, and data transformation.
• Experience building dashboards and visualizations in Tableau or a similar BI tool.
• Experience working with complex relational databases and multi-source data environments.
• Ability to document data systems, reporting logic, and workflows clearly and accurately.
• Strong attention to detail and commitment to data accuracy and integrity.

Responsibilities

• 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.
• 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 elevate opportunities for improvement.
• Support the development and maintenance of data dictionaries and internal documentation resources.
• 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.
• Collaborate with stakeholders to understand reporting needs and translate business questions into data queries and visualizations.
• Support multiple departments including Marketing, Finance, Customer Care, and Clinical Operations with data requests and analysis.
• Present findings in a clear, concise manner appropriate for both technical and non-technical audiences.
• Work with behavioral health EHR data to support reporting and analysis needs.
• Assist in extracting and validating data from EHR and connected systems.
• Develop familiarity with system workflows and data capture processes to improve reporting accuracy.

Skills

SQL

Tableau

Data analysis

Data documentation

Relational databases

Data integrity

Education

Bachelor’s degree in quantitative fields

Job description

South Coast Community Services in Southern California is seeking a Senior Data Analyst to support decision‑making through reliable reporting, data analysis, and documentation of data structures. This role works with behavioral health EHR data and collaborates with Marketing, Finance, Clinical Operations, and IT to deliver accurate insights.

You will build and optimize Tableau dashboards, write complex SQL queries, and document data sources and workflows to ensure data clarity, integrity, and