Senior Analytics Engineer

Pantherx Specialty LLC; United States; Remote; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical, Dental, Vision insurance

401K with employer matching

Life insurance

Job summary

PANTHERx Rare Pharmacy in Pittsburgh, PA, is seeking a Senior Analytics Engineer to design and maintain the governed semantic layer on our Databricks platform. You will establish canonical metric definitions and enable downstream analytics, dashboards, and AI model inputs.

You will lead the transformation of legacy logic into reusable metric views, mentor junior engineers, and collaborate with governance, QA, and BI teams to ensure data quality and accessibility across the organization.

Qualifications

• 6+ years of progressive analytics engineering or data engineering experience with production ownership of a semantic layer or governed consumption layer.
• Deep, hands-on Databricks experience: Unity Catalog, Delta Lake, medallion architecture, and Gold-layer design.
• Advanced SQL and strong PySpark and Python proficiency for complex promotion logic and metric definitions.

Responsibilities

• Designs and builds Unity Catalog metric views as canonical, versioned definitions with ownership and access controls.
• Designs Gold-layer tables and Silver-to-Gold promotion logic for scalable semantic layer architectures.
• Migrates legacy EDW views and ad-hoc SQL to governed metric views with output parity.
• Mentors Analytics Engineers, reviews PRs in Azure DevOps & Git to maintain code quality.
• Collaborates with Data Governance and stakeholders to define precise metric definitions and data contracts.

Skills

Advanced SQL

PySpark

Python

Data modeling

Analytics engineering

Communication

Education

Bachelor’s degree in CS or related field

Tools

Databricks

Unity Catalog

Delta Lake

Azure DevOps

Git

Power BI

Job description

Current job opportunities are posted here as they become available.

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.
• 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.

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.

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, as well as limited paid time off for part-time employees. Of course we offer paid holidays too!

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.