Data Analyst | Onshore

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.
• Self‑starter, comfortable in fast‑paced PE‑backed environments.

• 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 modeling, dashboard design, publishing.
  • SQL and Python (preferred) for data transformation.
  • Integrating financial systems (e.g., Sage, Quick Books, Net Suite) 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.

Minimum Compensation: USD 48,000 — Maximum Compensation: USD 168,000. Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good‑faith estimate for the role.

Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full‑time employees.

This position is available for independent contractors.