Solution Design Engineer I Jobs

EDW Technical Designer and Solutions Engineer

7,000 Diseases - 500 Treatments - 1 Rare Pharmacy PANTHERx is the nation’s largest rare disease pharmacy, and we put the patient experience at the top of everything that we do. If you are looking for a career in the healthcare field that embraces authentic dedication to patient care, you don’t need to look beyond PANTHERx. In every line of service, in every position and area of expertise, PANTHERx associates are driven to provide the highest quality outcomes for our patients. We are seeking team members who: Are inspired and compassionate problem solvers; Produce high quality work; Thrive in the excitement of the ever-challenging environment of modern medicine; and Are committed to achieving superior health outcomes for people living with rare and devastating diseases. At PANTHERx, we know our employees are the driving force in what we do. We cultivate talent and encourage growth within PANTHERx so that our associates can continue to explore their interests and expand their careers. Guided by our mission to provide uncompromising quality every day, we continue our strategic growth to further reach those affected by rare diseases. Join the PANTHERx team, and define your own RxARE future in healthcare! Location: Pittsburgh, PA (Hybrid or Remote) Classification: Full-time Status: Exempt Reports to: Director, Data Engineering and Analytics Purpose 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. In addition to ensuring EDW tables, processes, and transformations meet business requirements and support advanced analytics, the position 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. Responsibilities EDW Design \& Development + 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. Collaboration \& Documentation + 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. Continuous Improvement + 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. Reporting \& Dashboard Development + 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. Required Qualifications 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. Work Environment This position operates in a home or professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines. Physical Demands While performing the duties of this job, the employee is regularly required to sit, see, talk, or hear. The employee frequently is required to stand; walk; use hands and fingers to handle or feel; and reach with hands and arms. Visual acuity is necessary for tasks such as reading and working with various forms of data on a screen for extended periods of time. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the job. 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! Equal Opportunity: PANTHERx Rare Pharmacy is an equal opportunity employer, and does not discriminate in recruiting, hiring, promotions or any term or condition of employment based on race, age, religion, gender, ethnicity, sexual orientation, gender identity, disability, protected veteran's status, or any other characteristic protected by federal, state or local laws.

Solution Design Engineer I

From CA$83,000/yr

Who We Are: Barrett Distribution Centers is a leader in providing customized third-party logistics, omni-channel distribution, and direct-to-consumer fulfillment services for customers in a variety of industries. We are – more than anything else – a trusted consultant to our customers, working tirelessly to find solutions to their business challenges. Who We’re Looking For: We’re always on the lookout for smart, hard-working, and skilled top performers who are interested in joining a fantastic team within a fast-growing company If you’re great at what you do, passionate about doing it, and looking for a new home that rewards excellent work, effort, and collaboration, Barrett is the place for you! Why You’ll Love a Career at Barrett Distribution Centers: Health, dental, and vision insurance Opportunities for advancement – we love to promote from within! Ongoing training and leadership development Profit-sharing program – all employees benefit when the company succeeds! Competitive compensation Tuition reimbursement 401K savings plan with company match PTO A second-to-none culture where you’ll be treated like family and allowed to excel What You’ll Do: You’ll consistently apply the following core values as you interact with people both inside and outside of our organization: 1. Always Better 2. Utmost Integrity 3. Dedication to the Customer 4. I am an Owner 5. Open and Honest Communication You’ll be responsible for knowing and acting in accordance with Barrett’s vision to WOW our customers, partners, and fellow employees with every interaction. The Position: The Solution Design Engineer I, reporting to the Director of Industrial Engineering and Solution Design, supports the design of innovative, scalable, and cost-effective operational solutions for new and existing customers. This role works under the guidance of senior engineers and collaborates cross-functionally with sales, operations, and other stakeholders to ensure customer requirements are accurately reflected in proposed solutions and aligned with Barrett Distribution Centers’ operational objectives. The Solution Design Engineer I contributes to the development of high-quality solutions by assisting with process design, facility layouts, labor analysis, and system considerations that support operational efficiency, service levels, and overall performance. This position works Monday through Friday, from 9am-5:30pm. The compensation range for this position is $83K-$96K, depending on experience. Your Day-to-Day: Solution Development: Support the design of end-to-end operational solutions for new business opportunities, including facility layouts, material handling equipment selection, labor planning, and basic technology integration, under the guidance of senior engineers. Customer Engagement: Participate in customer and internal discussions to understand business needs, operational constraints, and service expectations; assist in translating requirements into design inputs and specifications. Data Analysis \& Modeling: Analyze historical and forecasted data to support throughput, storage capacity, and labor planning using established models, tools, and templates. Proposal Support: Assist in developing solution narratives, cost models, and ROI analyses for RFP responses and new business proposals; support internal and customer presentations. Technology Integration: Support the evaluation and incorporation of standard automation technologies, systems, and process flows into proposed solutions. Cross-Functional Collaboration: Collaborate with sales, operations, engineering, IT, and project management teams to support solution development and implementation efforts. Documentation \& Communication: Prepare design documentation, CAD layouts, and presentation materials to communicate solution concepts, assumptions, and benefits. Industry Best Practices: Apply industry-accepted technologies, automation concepts, and best practices in solution design while developing technical and business expertise. Performs other duties as assigned Travel: Moderate travel required to customer sites and company facilities (approximately 30%, up to 50% during peak project phases). What You Bring to the Table: Bachelor’s degree in Industrial Engineering, Systems Engineering, or related field required. Up to Two (2) years’ experience in solution design, business process engineering, warehousing, production environment, or related experience required. Working knowledge of solution design and warehouse engineering principles. Proficiency in Microsoft Office tools and AutoCAD. Solid understanding of warehouse operations and industry best practices. Basic to working knowledge of WMS functionality and concepts. Ability to adjust training presentations to skill set of audience. Ability to read, write, and communicate effectively in English. Ability to deal with a high level of ambiguity, balance competing priorities, complex situations, and tight deadlines. Strong emphasis on organizational skills and attention to detail. * Must demonstrate high level of interpersonal and communication skills with ability to work well under pressure and problem solve across a variety of business processes. The above statements are intended to describe the general nature and level of work performed by employees assigned to this classification. They are not to be construed as an exhaustive list of all job duties performed by the personnel so classified. Barrett Distribution Centers is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religious creed, retaliation, national origin, ancestry, sexual orientation, gender, gender identity/expression, mental or physical disability, genetic information, choice of health insurance, marital status, age, veteran status or any other basis protected by law.

AI/ML Engineer / Solution Designer – Toronto - Hybrid

AI/ML Engineer / Solution Designer – Toronto - Hybrid Capco – The Future. Now. Capco is a distinctly and positively different place to work. Much more than consultants, we are active participants in the global financial services industry. Our passionate business and technology professionals enjoy a unique environment where they are actively encouraged to apply intellect, innovation, experience and teamwork. We ware dedicated to ful

AI/ML Engineer / Solution Designer – Toronto - Hybrid

AI/ML Engineer / Solution Designer – Toronto - Hybrid Capco – The Future. Now. Capco is a distinctly and positively different place to work. Much more than consultants, we are active participants in the global financial services industry. Our passionate business and technology professionals enjoy a unique environment where they are actively encouraged to apply intellect, innovation, experience and teamwork. We ware dedicated to ful