EDW Technical Designer and Solutions 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 or Remote)

Classification: Full-time

Status: Exempt

Reports to: Director, Data Engineering and Analytics

Purpose

The Enterprise Data Warehouse (EDW) Technical Designer, working closely and collaboratively with the EDW Principal Architect, is responsible for designing and implementing modern, scalable data solutions that enable efficient data integration, transformation, and reporting across the organization. This role combines expertise in data modeling and SQL development with hands-on experience in cloud-native technologies, including Microsoft Azure, Databricks, and Medallion Architecture.

In addition to ensuring EDW tables, processes, and transformations meet business requirements and support advanced analytics, the position provides integrated process consulting to align business architecture needs with emerging technologies. By influencing decisions and priorities regarding the enterprise’s overall business system architecture, the EDW Technical Designer enhances current business processes and supports corporate goals through AI-driven optimizations, structured data lakehouse principles, and actionable insights delivered via reports and dashboards.

Responsibilities

• EDW Design & Development
  • Designs and implements EDW tables, schemas, and data models using dimensional modeling (star/snowflake) based on the defined EDW architectural philosophy and standards.
  • Writes and tests complex SQL queries, stored procedures, and scripts for large-scale data processing and reporting.
  • Works with the EDW Principal Architect and other developers to optimize complex SQL queries, stored procedures, and scripts.
  • Creates source-to-target mapping documents and ensure accurate data lineage.
  • Optimizes SQL queries, stored procedures, and database objects for performance and scalability.
  • Ensures data quality, consistency, and governance across multiple sources and layers of the Medallion Architecture.
  • Conducts data profiling and quality checks across source systems and EDW layers.
• Collaboration & Documentation
  • Partners with data scientists, data engineers, analysts, BI developers, and business stakeholders to deliver integrated solutions and AI-enhanced insights.
  • Consults with business units to understand existing business processes to increase efficiency and business functions.
  • Acts in a consultative role during plan, build, and implementation of solutions to the enterprise and ensures goals are achieved.
  • Provides technical guidance and mentorship to junior team members.
  • Participates in project planning, resource allocation, and solution implementation.
  • Manages multiple projects and/or programs for the health net enterprise.
  • Maintains comprehensive documentation for data models, pipelines, and AI integration strategies.
• Continuous Improvement
  • Stays current with emerging technologies and best practices in EDW, SQL development, and BI reporting.
  • Participates in research, evaluation, and assessment of proposed new technologies.
  • Recommends improvements to data processes, performance tuning, and reporting capabilities.
• Reporting & Dashboard Development
  • Designs and develops interactive dashboards and reports using BI tools (e.g., Power BI, Tableau).
  • Collaborates with business stakeholders to gather reporting requirements and translate them into technical solutions.
  • Ensures reports and dashboards are accurate, user-friendly, and aligned with KPIs.

Required Qualifications

• Bachelor’s degree in computer science, Business Administration, or related field.
• Minimum of 5 years of System/Solutions integration experience, EDW development, SQL programming, and data integration.
• Strong proficiency in SQL and relational database design.
• Experience with BI/reporting tools (Power BI, Tableau, SSRS).
• Solid understanding of dimensional modeling and data warehousing principles.
• Experience in designing and implementing technology solutions in a large, complex environment.

Preferred Qualifications

• Healthcare business process and technology experience.
• Master’s degree in computer science, Business Administration, or related field.
• Familiarity with iterative development methodologies (Agile).
• Experience with cloud data platforms (Databricks, Snowflake, Azure Synapse/Data Factory/SQL Databases, AWS Redshift).
• Experience with AI/ML frameworks (e.g., Azure Machine Learning, Spark MLlib).
• Knowledge of data governance and compliance best practices.

Work Environment

This position operates in a home or professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.

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 for extended periods of time. 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, as well as limited paid time off for part-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.