Senior Healthcare Data Analyst, Pharma Analytics

Cinnamon Inc. is a healthcare technology company dedicated to improving patient access to care. They are seeking a Senior Healthcare Data Analyst to lead the development of pharma facing analytics and dashboard strategies, ensuring accurate and insightful data to support enterprise pharma relationships.

Responsibilities:

• Lead development and evolution of Cinnamon’s pharma facing dashboard in Looker or Looker Studio within GCP
• Define and standardize KPIs aligned to contractual commitments, utilization metrics, and commercial goals
• Ensure dashboards are accurate, scalable, and executive ready
• Continuously improve visualizations and data storytelling for external stakeholders
• Develop, test, and optimize SQL queries in AlloyDB and BigQuery
• Perform deep dive analyses to answer pharma specific questions around performance, utilization, patient access, and outcomes
• Identify trends, risks, and opportunities within large healthcare data sets
• Validate data integrity and implement data quality checks
• Work directly with the VP of Business Development to translate pharma requests into reporting requirements
• Work backwards from what pharma needs to close and renew deals, identifying data gaps and proposing solutions
• Prepare data summaries and insights ahead of client meetings
• Potentially participate in client calls to explain methodology, KPIs, and findings
• Align pharma reporting needs with health system data realities
• Partner with Product and Engineering to refine schemas, improve performance, and expand available data fields
• Contribute to schema updates and performance optimizations
• Maintain HIPAA compliant handling of protected health information
• Store queries, documentation, and dashboards in GitHub following pull request workflows
• Document recurring reports, definitions, and QA procedures

Requirements:

• 3 to 6 years of hands on SQL experience working with healthcare data sets
• Strong proficiency in BigQuery and AlloyDB or similar GCP database technologies
• Experience building dashboards in Looker, Looker Studio, or similar BI tools
• Experience translating business or client questions into structured reporting requirements
• Familiarity with healthcare data including patient demographics, encounters, insurance, and orders
• Comfort presenting findings to non technical and executive audiences
• Working knowledge of HIPAA and secure data handling