remote
Senior Data Analyst - Finance Encounter Data - Covered California - Caloptima
Data Analyst
Senior Data Analyst in finance, driving insights from Covered California encounter data using Python, SQL, Tableau, and advanced Excel to support strategic decision‑making and improve healthcare outcomes.
About the role
Key Responsibilities
- Design, develop, and maintain robust data pipelines to ingest and transform encounter data for financial analysis.
- Build and optimize SQL queries and Python scripts for data extraction, cleaning, and enrichment.
- Create interactive Tableau dashboards and reports to visualize key financial metrics and trends.
- Collaborate with cross‑functional teams to define data requirements and translate business questions into analytical solutions.
- Perform advanced Excel modeling for scenario analysis, forecasting, and budgeting.
- Ensure data quality, integrity, and compliance with regulatory standards.
Requirements
- 5+ years of experience in data analysis within a finance or healthcare environment.
- Proficiency in Python (pandas, NumPy), SQL, Tableau, and Excel (advanced functions, VBA).
- Strong understanding of financial statements, budgeting, and cost analysis.
- Experience with data modeling, ETL processes, and data governance.
- Excellent communication skills and ability to translate complex data into actionable insights.
Skills
pythonsqltableauexcel