Data Analyst | Onshore
About The Position
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.
Requirements
- 8+ years of hands-on experience in data analytics or engineering.
- 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.
- 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.
Nice To Haves
- Working with healthcare or multi-location business data (nice to have: EMR data familiarity).
Responsibilities
- 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, clinic-level and regional performance metrics, and 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.
Benefits
- Medical, vision, and dental benefits
- 401k retirement plan
- Variable pay/incentives
- Paid time off
- Paid holidays
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Industry
Professional, Scientific, and Technical Services
Education Level
No Education Listed
Number of Employees
5,001-10,000 employees
