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.
Requirements
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.
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.
MES Integration Engineer deploying and managing a commercial Manufacturing Execution System for quantum chip fabrication. Focused on integrating complex fabrication flows and supporting R&D environment.
Principal Solutions Architect at Argano providing strategic direction and oversight on integration of data platforms. Designing complex solutions and managing work processes from inception to delivery.
Lead artificial intelligence architecture for enterprise AI solutions at Wells Fargo. Collaborate cross - functionally to drive innovation and transform operational efficiency.
Senior Architect, Data Science responsible for designing scalable data science architecture. Collaborating across teams and overseeing implementation of robust data science solutions aligned with business objectives.
Cloud Migration Lead guiding application migrations to the cloud for Boeing's Defense, Space & Security division. Leading cross - functional teams in cloud - native transformations and ensuring successful adoption of modern engineering practices.
Manager leading the design and implementation of innovative insurance solutions at PwC. Focus on cloud transformation and enhancing customer experiences in insurance operations.
Senior Solution Architect developing impactful technology solutions for financial services. Collaborating across teams to influence strategic architecture and deliver high - quality digital services.
Information Governance Solutions Manager directing firm - wide IG system strategies, focusing on platform implementation and stakeholder collaboration. Leading migrations and ensuring compliance within law firm's operations.
Customer Solutions Consultant providing technical assistance and support for SiteMinder's hotel solutions. Serving diverse global customers with a focus on technical excellence and service quality.
Solution Architect focusing on AI governance and data pipeline design at eSimplicity. Collaborating across teams to drive innovative technology solutions for government clients.