We’re hiring a Data Analyst to lead and stabilize enterprise reporting across pharmacy operations, HUB services, and clinical reporting. This role will own all reporting responsibilities and help transition the organization from nightly batch reporting to a near real-time analytics environment. Your work will support the company goal of helping patients with rare and chronic illnesses get speciality care.
The organization is undertaking a major initiative to re-architect its data pipelines, shifting from a Snowflake-based replication model to an Azure and Databricks real-time data framework. This role will be instrumental in supporting this transition.
Candidates must live in the U.S. and be able to work without sponsorship or C2C arrangement.
Key Responsibilities:
Reporting & Analytics
- Design, build, and maintain KPI-driven dashboards and reporting solutions (Sigma, Tableau, Power BI).
- Develop and optimize complex SQL queries for operational and executive reporting.
- Translate ambiguous business questions into structured, scalable analytics solutions.
- Ensure reporting is accurate, performant, and aligned with business definitions.
Data Architecture & Pipeline Support
- Support re-architecture of data pipelines to enable near real-time reporting.
- Work within Azure and Databricks environments for ETL, transformation, and data processing.
- Collaborate with Data Engineering leadership to improve scalability and freshness of reporting assets.
- Identify data gaps and recommend automation improvements.
Business Partnership
- Partner closely with operations, pharmacy leadership, and engineering teams.
- Support root-cause analysis and investigative analytics for performance issues.
- Document data definitions, KPIs, and reporting logic for consistency and governance.
Qualifications:
- 3–5 years of experience in Data Analytics or Business Intelligence (open to strong junior candidates with the right technical foundation and work ethic).
- Advanced SQL skills (joins, CTEs, window functions, performance tuning).
- Experience with BI tools (Sigma preferred; Tableau or Power BI acceptable).
- Exposure to Azure, Databricks, or modern cloud data platforms.
- Experience working in healthcare, pharmacy, or regulated industries preferred.
- Strong analytical thinking and problem-solving skills.
- Excellent communication skills and ability to work cross-functionally.
About You:
- Strong work ethic and self-starter mentality.
- Ability to adapt to shifting priorities in a fast-moving environment.
- Willingness to attempt solutions independently before escalating.
- Clear communicator who fits into a collaborative, team-oriented culture.
- Comfortable in a primarily remote setting with light quarterly travel to Dallas for team events and tech summits.
- Open to a 1-year contract to hire arrangement.