About the role

EDW Technical Designer at PANTHERx designing data solutions and enhancing business processes for healthcare pharmacy. Collaborating with stakeholders and ensuring data reporting aligns with analytics.

Responsibilities

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.
Ensures EDW tables, processes, and transformations meet business requirements and support advanced analytics.
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.
Partners with data scientists, data engineers, analysts, BI developers, and business stakeholders to deliver integrated solutions and AI-enhanced insights.

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.

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!