Manager- Analytics Engineering

PANTHERx Rare Pharmacy; Pittsburgh (Allegheny County); Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Hybrid/remote work options

Excellent benefits package

401K with employer matching

Paid time off

Employee Assistance Program

Job summary

PANTHERx Rare Pharmacy in Pittsburgh, PA is seeking a seasoned Manager, Analytics Engineering to lead the semantic layer and data product development in a Databricks-based environment. You will design metric views, govern Gold/Silver data, mentor a growing team, and partner across Analytics, Data Governance, and IT to deliver trusted analytics and scalable data products for BI and AI model inputs.

Location is Pittsburgh with hybrid work options and a mission to improve outcomes for patients with

Qualifications

• 7+ years in data/analytics engineering, incl. 2+ years in people management
• Deep expertise with Databricks Unity Catalog, metric views, and delta lake architectures
• Experience owning semantic layer functions and data product development
• Ability to articulate analytics engineering as distinct from data engineering and BI

Responsibilities

• Owns the Unity Catalog semantic layer as the canonical source of truth for metrics
• Designs and governs metric views, data mart architecture, and data products
• Leads data product development and reusable analytics assets for self-service discovery
• Partners with Analytics, Data Governance, and Data Engineering to ensure governance and alignment

Skills

Databricks

Unity Catalog

Metric views

SQL

PySpark

Team leadership

Data governance

Education

Bachelor's degree in CS/DS/Engineering

Tools

Atlan

Collibra

Job description

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: Senior Director, Data & Analytics

Purpose

The Manager, Analytics Engineering leads the Analytics Engineering track within the Data & Analytics organization, owning the semantic layer between raw pipeline output and BI consumption. This function owns Gold-layer table design, Unity Catalog metric view definitions, Silver-to-Gold promotion logic, and data product development in a Databricks-native environment. By establishing governed, reusable metric views as the canonical source of truth for business metrics, the Analytics Engineering track enables consistent, trustworthy analytics delivery across BI, external partner feeds, and AI model inputs.

Responsibilities

Semantic Layer Ownership

• Owns the Unity Catalog semantic layer as the canonical, governed source of truth for all business metrics: metric view definitions, Silver-to-Gold promotion logic, data mart architecture, and data product development.
• Establishes the principle that every business metric is defined once as a metric view and made available, consistently and correctly, to every downstream consumer: Power BI dashboards via DirectLake, external partner feeds, internal analytics, and AI model inputs.
• Sets and enforces standards for metric view design, naming conventions, versioning, and documentation, in alignment with Data Governance metadata standards and Unity Catalog access controls.
• Partners with the Data Architecture on Gold-layer design decisions, ensuring the semantic layer is architecturally sound, maintainable, and scalable as the platform grows.

Data Product Development

• Leads the development of reusable data products in Unity Catalog, building the data product catalog that enables self-service analytics discovery without ad-hoc engineering intervention.
• Ensures analytics requests enter the engineering pipeline with defined acceptance criteria and data product specifications before build work begins, in coordination with Informatics intake.
• Drives consistency and reuse across analytics delivery by replacing bespoke, one-off SQL derivation with governed, versioned metric views and data products.

Team Leadership & Development

• Develops a team culture oriented around the semantic layer discipline, which is distinct from both Data Engineering (pipeline and platform focused) and Analytics & BI (dashboard and report focused).
• Builds individual development plans and career frameworks for the team, defining clear growth paths within the Analytics Engineering track.
• Fosters a culture of standards adherence, documentation discipline, and reusability across all data product and metric view development.

Cross-Functional Partnership

• Partners with Analytics & BI to ensure metric views meet BI consumption requirements and that the Analytics & BI team builds on the semantic layer without re-deriving logic.
• Partners with Data Engineering to ensure Gold-layer tables and Silver-to-Gold promotion logic are aligned with the data engineering platform architecture.
• Partners with Data Governance to ensure metric view definitions are governed assets: ownership assigned, lineage tracked, and metadata standards enforced.
• Partners with Informatics to ensure analytics requests enter the build pipeline with defined scope and acceptance criteria.
• Partners with QA to support data layer validation of analytics outputs against governance-defined quality dimensions.

Required Qualifications

• 7+ years of progressive data engineering or analytics engineering experience, with at least 2 years in a people management or team lead capacity.
• Deep, hands-on expertise with Databricks: Unity Catalog, metric views, Delta Lake, medallion architecture, and Silver-to-Gold promotion logic in production environments.
• Demonstrated experience owning or building a semantic layer function: metric definitions, data product development, and the discipline of defining business metrics once for reuse across consumers.
• Clear understanding of analytics engineering as a distinct discipline from data engineering (pipelines, ingestion) and BI (dashboards, reports); able to articulate and hire to that distinction.
• Proficiency in SQL and PySpark; sufficient to set engineering standards, review code quality, and make architecture decisions for the semantic layer.
• Proven ability to build and lead teams, including establishing standards and practices in a function without an existing organizational identity to inherit.

Preferred Qualifications

• Healthcare, specialty pharmacy, or regulated industry experience with exposure to clinical or operational data environments.
• Experience with data product design, data product catalogs, and self-service analytics enablement in a governed Databricks environment.
• Familiarity with data governance frameworks and experience designing semantic layer assets to meet governance metadata and lineage standards.
• Experience with data catalog tooling (Atlan, Collibra, or equivalent) and designing metric views as catalogued, governed assets.
• Exposure to AI/ML platform integration: understanding how semantic layer and metric view design decisions affect model input quality and feature engineering.
• Familiarity with pipeline observability platforms (Monte Carlo or equivalent) and how observability integrates with semantic layer asset monitoring.
• Bachelor's degree in Computer Science, Data Science, 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.