Apply on Employer Site

Photon · 2 months ago

Data Analyst | Onshore

Newtok, AK

Full-time

Onsite

Senior Level, Lead/Staff

$48K/yr - $168K/yr

8+ years exp

Photon is seeking a Data Analyst to enhance and stabilize data pipelines feeding the Snowflake data warehouse. The role involves ingesting and reconciling data from various sources, designing Power BI dashboards, and partnering with the finance team to ensure the accuracy of financial reporting.

E-CommerceInformation TechnologyMobile AppsWeb DesignWeb Development

H1B Sponsor Likely

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

Qualification

Snowflake data warehousePower BISQLPythonData analyticsFinancial systems integrationHealthcare data experienceAnalytical mindsetCommunication skillsCollaboration skills

Required

8+ years of hands-on experience in data analytics or engineering

Proven experience with Snowflake data warehouse – schema design, SQL, data pipeline optimization

Proven experience with Power BI – DAX, data modeling, dashboard design, publishing

Proven experience with SQL and Python for data transformation

Proven experience integrating financial systems (e.g., Sage, QuickBooks, NetSuite) with data warehouses

Proven experience working with healthcare or multi-location business data

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

Preferred

EMR data familiarity

Benefits

Medical, vision, and dental benefits

401k retirement plan

Variable pay/incentives

Paid time off

Paid holidays

Company

Photon

Glassdoor3.6

Photon is a technology corporation that provides Strategy Consulting, Creative Design, and Technology Services to global enterprise.

Founded in 2007

London, England, GBR

5001-10000 employees

https://www.photon.in

H1B Sponsorship

Photon has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (233)

2024 (168)

2023 (236)

2022 (184)

2021 (157)

2020 (249)