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
Skills Required
- 8+ years of hands-on experience in data analytics or engineering.
- Experience with Snowflake data warehouse including schema design, SQL, and pipeline optimization.
- Power BI dashboard development, data modeling, and publishing (including DAX).
- Strong SQL skills for data transformation and querying.
- Python for data transformation (preferred).
- Experience integrating financial systems (e.g., Sage, QuickBooks, NetSuite) with data warehouses.
- Experience working with healthcare or multi-location business data (EMR data familiarity is a plus).
- Ability to interpret financial metrics, AR aging, and revenue cycle KPIs.
- Implement data quality checks, documentation, and version control for reports and SQL queries.
- Excellent communication and collaboration skills with non-technical business users; self-starter comfortable in PE-backed environments.
What We Do
Photon.com has emerged as one of the world’s largest and fastest-growing Digital Agencies. We work with 40% of the Fortune 100 on their Digital initiatives and are known for our ability to integrate Strategy Consulting, Creative Design, and Technology at scale. Please visit www.photon.com to learn more about us, how we work, and our customer case studies. Digital Transformation Starts Here.
