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. 

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 modeling, 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. 



Compensation, Benefits and Duration

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
No applications will be considered if received more than 120 days after the date of this post