Principal Solution Architect - Reporting & Analytics
West Pharmaceutical Services - Exton, PA
Hiring: Principal Solution Architect - Reporting & Analytics Company: West Pharmaceutical Services Location: Exton, PA Job Posted Time: 2026-09-10 14:02:07 Employment Type: Hybrid Target Skills & Keywords : Azure, Data Pipeline, Data Warehouse, Databricks, Python, SAP, SQL About the job Experience: •8 years of relevant experience in areas specified under Essential Duties and Responsibilities. •Minimum 8 years of relevant experience in areas specified under Essential Duties and Responsibilities. Required Skills: •This is a hybrid position requiring the team member to be onsite a minimum of 3 days per week •No relocation is provided for this opportunity •There’s no better place to join an inclusive community of professionals with opportunities for lifelong learning, growth and development. Supported by benefit programs, we empower the physical, mental, emotional and financial health of our team members and their families. •We believe in giving back to help those in need in the communities where we live and work. And are equally committed to creating a healthier environment and planet through our sustainability efforts. •Act as a subject matter expert in designing and implementing Microsoft Fabric solutions, including Data Engineering, Data Factory, Lakehouse, Warehouse, and Power BI applications to support enterprise dashboards, reports, and analytics. •Develop dashboards, KPIs, and scorecards by integrating data from multiple sources. •Interface directly with cross-functional teams to gather reporting requirements and build solutions using Fabric Lakehouse and Warehouse structures. •Partner cross-functionally with Data Engineering and Architecture teams to design data models, medallion architecture, and semantic models. Qualifications: •In-depth knowledge of Microsoft Fabric architecture, including Lakehouse, Warehouse, Data Factory, Pipelines, and Dataflows Gen2. •Proficiency in DAX, SQL, Python, and understanding of source systems such as SAP. •Operational familiarity with supporting BI tools and ecosystem: Power Query, Azure Synapse, Azure SQL, or Databricks. •Demonstrated capacity to lead a team of 2–3 Associates/Solution Architects/Sr. Solution Architects in the Fabric & Power BI domain. •Demonstrated capacity to comply with all relevant SOPs and company policies related to the position. •Strong understanding and adherence to company safety and quality policies. •20%: Up to 52 business days per year •Sedentary-Exerting up to 10lbs/4kgs of force occasionally, and/or negligible amount of force frequently or constantly to lift, carry, push, pull, or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!