Data Analyst

  • San Francisco, CA
  • Posted 14 hours ago | Updated 14 hours ago

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Able to Provide Sponsorship

Skills

Power BI
Snowflake
SQL
Python
healthcare
financial metrics
AR aging
revenue cycle KPI

Job Details

Hello ,

Hope you are doing well,

Myself Mankar from Photon and I have a position with our direct client, please send me your updated resume if you are interested and you can connect me through

Data Analyst

SFO, CA - Onsite

We are seeking a hands-on Data Analyst / Data Engineer to support the Client s analytics and finance teams in consolidating data from multiple dental clinics into a centralized Snowflake data warehouse and delivering actionable Power BI dashboards. The role requires a self-motivated individual capable of working independently with limited supervision, collaborating across Finance and Operations to deliver insights on revenue, receivables, and performance metrics.

Key Responsibilities

  • Work closely with the existing analyst to enhance and stabilize data pipelines feeding the Snowflake data warehouse.
  • Ingest and reconcile data from multiple dental clinic EMRs, Sage ERP/Finance system, and other operational sources.
  • Design and publish Power BI dashboards for:
  • Revenue cycle management (R30/60/90 aging, collections, forecasts)
  • Clinic-level and regional performance metrics
  • Financial vs clinical KPI alignment
  • Partner with the CFO and finance team to validate metrics and ensure accuracy of financial reporting.
  • Implement data quality checks, documentation, and version control for reports and SQL queries.
  • Recommend improvements to data architecture and help shape the longer-term data strategy.

Required Skills & Experience

  • 8+ years of hands-on experience in data analytics or engineering.
  • Proven experience with:
  • Snowflake data warehouse schema design, SQL, data pipeline optimization.
  • Power BI DAX, data modelling, dashboard design, publishing.
  • SQL and Python (preferred) for data transformation.
  • Integrating financial systems (e.g., Sage, QuickBooks, NetSuite) with data warehouses.
  • Working with healthcare or multi-location business data (nice to have: EMR data familiarity).
  • Strong analytical mindset with ability to interpret financial metrics, AR aging, and revenue cycle KPIs.
  • Excellent communication and collaboration skills with non-technical business users.
  • Self-starter, comfortable in fast-paced PE-backed environments.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.