Senior Analytics Engineer

7,000 Diseases - 500 Treatments - 1 Rare Pharmacy PANTHERx is the nation’s largest rare disease pharmacy, and we put the patient experience at the top of everything that we do. If you are looking for a career in the healthcare field that embraces authentic dedication to patient care, you don’t need to look beyond PANTHERx. In every line of service, in every position and area of expertise, PANTHERx associates are driven to provide the highest quality outcomes for our patients. We are seeking team members who: Are inspired and compassionate problem solvers; Produce high quality work; Thrive in the excitement of the ever-challenging environment of modern medicine; and Are committed to achieving superior health outcomes for people living with rare and devastating diseases. At PANTHERx, we know our employees are the driving force in what we do. We cultivate talent and encourage growth within PANTHERx so that our associates can continue to explore their interests and expand their careers. Guided by our mission to provide uncompromising quality every day, we continue our strategic growth to further reach those affected by rare diseases. Join the PANTHERx team, and define your own RxARE future in healthcare! Location: Pittsburgh, PA (Hybrid) Classification: Exempt Status: Full-Time Reports to: Manager, Analytics Engineering Purpose The Senior Analytics Engineer designs and builds the governed semantic layer on PANTHERx’s Databricks platform: Unity Catalog metric views, Gold-layer table design, Silver-to-Gold promotion logic, and reusable data products. This role is responsible for establishing every business metric as a single, canonical, versioned definition that serves every downstream consumer: Power BI dashboards via DirectLake, external partner feeds, internal analytics, and AI model inputs. The Senior Analytics Engineer serves as a senior practitioner within the Analytics Engineering track, replacing bespoke, one-off SQL derivation with governed, reusable assets, setting the technical bar for semantic layer design, and mentoring Analytics Engineers as the team scales. Responsibilities Semantic Layer & Metric Views Designs and builds Unity Catalog metric views as the canonical, versioned definitions of business metrics, with ownership assigned, lineage tracked, and access controls enforced. Designs Gold-layer tables and Silver-to-Gold promotion logic in partnership with Data Engineering, ensuring the semantic layer is architecturally sound, performant, and maintainable as the platform grows. Migrates legacy consumption logic, including EDW views, legacy data products, and ad-hoc SQL derivation, into governed metric views with validated output parity. Sets and enforces standards for metric view design, naming conventions, versioning, and documentation, in alignment with Data Governance metadata standards. Data Product Development Builds reusable data products in Unity Catalog, catalogued with owner, classification, and lineage, enabling self-service discovery without ad-hoc engineering intervention. Works from data product specifications and acceptance criteria entering through the Informatics intake process, and flags specification gaps before build work begins. Partners with Analytics & BI to ensure metric views meet DirectLake consumption requirements, so dashboards and reports are built on governed definitions rather than re-derived logic. Partners with Partner Data Services on metric views serving external partner feeds, ensuring feed-facing definitions meet contract schema and quality requirements. Quality, Documentation & Governance Documents metric definitions, promotion logic, and data products to team standards, and contributes plain-language definitions to the business glossary, ensuring no semantic layer asset depends on a single point of failure. Implements validation and observability for semantic layer assets, ensuring metric changes are versioned, tested, and communicated before downstream consumers are affected. Partners with QA on data-layer validation of analytics outputs against governance-defined quality dimensions. Serves as the senior escalation point for metric definition conflicts, working with business stakeholders and Data Governance to resolve competing definitions into a single canonical version. Mentorship & Cross-Functional Collaboration Mentors Analytics Engineers on semantic layer design, SQL and PySpark craft, and documentation discipline; reviews pull requests in Azure DevOps & Git to maintain code quality. Serves as a technical liaison with business stakeholders, translating business metric requirements into precise, testable definitions and explaining definition decisions in plain language. Collaborates with Data Engineering on platform architecture decisions affecting the semantic layer, and with Data Governance on metadata, classification, and lineage standards. Required Qualifications 6+ years of progressive analytics engineering or data engineering experience, including production ownership of a semantic layer, metrics layer, or governed consumption layer serving multiple downstream consumers. Deep, hands-on expertise with Databricks in production environments: Unity Catalog, Delta Lake, medallion architecture, and Gold-layer design. Demonstrated experience establishing canonical metric definitions for reuse: defining a business metric once and serving it consistently to BI, analytics, and external consumers. Advanced SQL and strong PySpark and Python proficiency, sufficient to design, build, and optimize complex promotion logic and metric definitions independently. Strong dimensional and consumption-oriented data modeling skills: designing Gold-layer structures for query performance, reusability, and downstream consumption. Clear understanding of analytics engineering as a discipline distinct from data engineering (pipelines, ingestion) and BI (dashboards, reports), and the ability to operate at that seam. Strong communication skills; able to work directly with business stakeholders, Governance, QA, and Informatics to converge on precise metric definitions. Preferred Qualifications Healthcare, specialty pharmacy, or regulated industry experience, with exposure to clinical or operational data environments. Hands-on experience with Unity Catalog metric views specifically, or an equivalent governed metrics layer in production. Familiarity with Power BI DirectLake consumption patterns sufficient to design metric views that serve semantic models efficiently. Familiarity with enterprise data catalog tooling (Atlan, Collibra, or equivalent) and designing semantic layer assets as catalogued, governed assets. Familiarity with data contract standards (ODCS or equivalent) for metric views serving external partner feeds. Exposure to AI/ML platform integration: understanding how semantic layer and metric view design affect model input quality and feature engineering. Experience mentoring engineers and setting technical standards without formal management authority. Bachelor’s degree in Computer Science, Data Science, Data Engineering, or a related field, or equivalent experience. Work Environment This position works in a home office and professional office environment. When in-office this role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines, and communications via MS Teams. Physical Demands While performing the duties of this job, the employee is regularly required to sit, see, talk or hear. The employee frequently is required to stand; walk; use hands and fingers to handle or feel; and reach with hands and arms. Visual acuity is necessary for tasks such as reading and working with various forms of data on a screen. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the job. Benefits: Hybrid, remote and flexible on-site work schedules are available, based on the position. PANTHERx Rare Pharmacy also affords an excellent benefit package, including but not limited to medical, dental, vision, health savings and flexible spending accounts, 401K with employer matching, employer-paid life insurance and short/long term disability coverage, and an Employee Assistance Program! Generous paid time off is also available to all full-time employees. Of course we offer paid holidays too! Equal Opportunity: PANTHERx Rare Pharmacy is an equal opportunity employer, and does not discriminate in recruiting, hiring, promotions or any term or condition of employment based on race, age, religion, gender, ethnicity, sexual orientation, gender identity, disability, protected veteran's status, or any other characteristic protected by federal, state or local laws.