Apply on Employer Site

PANTHERx Rare Pharmacy · 1 month ago

EDW Technical Designer and Solutions Engineer

Pittsburgh, PA, US

Full-time

Hybrid

Senior Level

5+ years exp

PANTHERx Rare Pharmacy is the nation’s largest rare disease pharmacy, dedicated to providing superior health outcomes for patients. The EDW Technical Designer and Solutions Engineer will design and implement scalable data solutions, ensuring data integration and quality across the organization while collaborating with various stakeholders to enhance business processes and reporting capabilities.

BiotechnologyHealth CareMedicalPharmaceutical

Culture & Values

Responsibilities

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

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

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

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

Qualification

SQL programmingData warehousingCloud data platformsBI/reporting toolsDimensional modelingData integrationHealthcare technologyAgile methodologiesAI/ML frameworksData governance