Strategic senior - level Solution Architect defining digital transformation roadmap. Responsible for Oracle ERP/SCM and Workday integration and governance at QTS Data Centers.
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.
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.
- Of course we offer paid holidays too!
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Director Solution Architecture at Webster, shaping architecture for Corporate IT platforms. Leading strategic delivery and aligning investments with business outcomes.
Principal Engineer ensuring secure design in Wells Fargo's technology products. Acting as a Data Product Security Solution Architect within Cybersecurity organization with a focus on security architecture.
Application & GenAI Pre - Sales Solutions Architect at e360 focusing on Generative AI solutions. Define solution vision and shape technical strategy for customer engagement.
Resident Solution Architect guiding customers through implementation and configuration of Immuta’s data solutions. Aiming for meaningful business outcomes across various industries from their investment.
Senior Director of Solutions Engineering at Comcast Business leading a team to drive technical strategy and solution design. Overseeing customer engagement and operational management for enterprise accounts.
Senior Workday HCM Integration Engineer supporting Workday functionalities and integration projects at SoFi in San Francisco. Collaborating with stakeholders and providing expert - level support.
Cloud Solutions Architect managing customer services hosted in a FedRAMP certified commercial cloud environment. Defining architecture and assessing migration strategies for optimized solutions.
Senior Test Solutions Engineer at Micron developing innovative memory and storage solutions. Leading testing strategy and execution to enhance information transformation.
Solution Engineering Manager leading a high - performing team for B2B SaaS solutions at Ironclad. Collaborating with Sales and Customer Outcomes to drive customer value realization and team performance.