Data Analyst

Summary

Clarium is a healthcare technology company using its AI-powered Astra OS platform to improve hospital supply chain operations. The Data Analyst will turn raw data into actionable business decisions by writing SQL and Python analyses, building dashboards, investigating data quality issues, and communicating findings to technical and non-technical stakeholders.

Responsibilities

• Write and optimize SQL to extract, join, and aggregate data across large relational datasets
• Use Python to clean, transform, and analyze data that doesn't fit neatly into a query
• Independently explore datasets to surface trends, anomalies, and opportunities the business hasn't thought to ask about yet
• Build and maintain dashboards and recurring reports that stakeholders actually use
• Partner with product and customer success teams to scope ambiguous questions into answerable analyses
• Investigate data quality issues and work with engineering to resolve them at the source
• Document data definitions, metrics, and methodology so results are reproducible and trusted
• Present findings and recommendations clearly to both technical and non-technical audiences

Skills

• 3+ years of professional experience in an analytics, data, or business intelligence role
• Strong proficiency in SQL — comfortable with joins, window functions, CTEs, and query optimization against large tables
• Strong proficiency in Python for data analysis (e.g. pandas, NumPy, Jupyter)
• Hands-on experience working with relational databases; PostgreSQL and Snowflake strongly preferred
• Working knowledge of Git for version control — branching, pull requests, and collaborating on a shared codebase
• Demonstrated ability to work independently — scoping your own analyses from a vague business question, and proactively identifying what's worth investigating without being handed a spec
• Track record of building dashboards and reporting that others rely on
• Excellent written and verbal communication skills
• Experience working with healthcare data — claims, EHR/EMR, eligibility, clinical, or patient-level data
• Familiarity with healthcare data standards and privacy requirements (HIPAA, PHI/PII handling, HL7/FHIR, ICD/CPT coding)
• Experience with hospital cost and operations data — ERP / supply chain (purchasing, inventory), resource and procedure utilization, and charge data (chargemaster, charge capture)
• Experience with dbt or similar modern analytics engineering workflows
• Experience with BI and visualization tools (Sigma, Tableau, Looker, Power BI, or similar)

Qualifications

Must Haves

• 3+ years of professional experience in an analytics, data, or business intelligence role
• Strong proficiency in SQL — comfortable with joins, window functions, CTEs, and query optimization against large tables
• Strong proficiency in Python for data analysis (e.g. pandas, NumPy, Jupyter)
• Hands-on experience working with relational databases; PostgreSQL and Snowflake strongly preferred
• Working knowledge of Git for version control — branching, pull requests, and collaborating on a shared codebase
• Demonstrated ability to work independently — scoping your own analyses from a vague business question, and proactively identifying what's worth investigating without being handed a spec
• Track record of building dashboards and reporting that others rely on
• Excellent written and verbal communication skills

Nice to Haves

• Experience working with healthcare data — claims, EHR/EMR, eligibility, clinical, or patient-level data
• Familiarity with healthcare data standards and privacy requirements (HIPAA, PHI/PII handling, HL7/FHIR, ICD/CPT coding)
• Experience with hospital cost and operations data — ERP / supply chain (purchasing, inventory), resource and procedure utilization, and charge data (chargemaster, charge capture)
• Experience with dbt or similar modern analytics engineering workflows
• Experience with BI and visualization tools (Sigma, Tableau, Looker, Power BI, or similar)

Benefits

• Incentive Stock Options proportionate to your salary
• Fully remote, with a NYC co-working space available; distributed team across multiple time zones with opportunities for in-person time
• Unlimited PTO
• Top-tier health, vision, and dental benefits
• 401K
• The opportunity to build on a strong foundational team with deep data and engineering roots at a stage where your work genuinely shapes the product
• A fast-paced, high-growth environment where we move quickly to solve critical healthcare challenges
• The chance to empower frontline healthcare workers by automating the administrative friction in their day-to-day
• Collaborative work alongside a high-caliber team of clinicians, engineers, and revenue leaders