Solutions Architect at Lovable to design solutions aligning with customer goals and technical constraints. Collaborating with teams to drive adoption of AI - native software creation.
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
Solutions Architect at Orb driving evaluations of billing solutions for prospective clients. Bridging technology and business strategy while enhancing customer relationships and experiences.
Senior Client Solution Manager building strategic partnerships and driving revenue growth on Pinterest. Seeking experienced digital advertising sales professional with strong relationship building skills.
Solutions Architect designing and implementing complex solutions at MassMutual. Collaborating with teams to deliver technologies for sales and distribution processes enhancing business outcomes.
Oracle Applications Architect leading architecture, design, and optimization of Oracle ERP solutions at GDIT. Collaborating with teams to ensure safety and security of the nation through modernization efforts.
Solutions Architect leading Software Engineering for Chemistry Applications. Collaborating with engineers and stakeholders at leading chemical companies to enhance R&D processes.
Senior Manager leading design and implementation of integration solutions for enterprise systems at Simpson Thacher. Collaborating with teams to enhance scalability, security, and reliability.
Consulting Solution Architect developing comprehensive security solutions for CDW customers. Collaborating with sales and delivery teams to drive business growth in Hybrid Infrastructure services.
Senior Data & AI Solutions Architect at DXC Technology managing cloud data platforms and AI solutions. Leading architecture design, customer advisory, and implementation efforts in a remote capacity.
Solution Engineer Intern supporting sales engineering efforts and customer success for innovative automation solutions at Stonebranch. Collaborating with experienced engineers on technical evaluations and proof - of - concept projects.