Sr Technical Data Analyst
Allegan, MI, US, 49010
At Perrigo, we are driven by our mission to Makes Lives Better Through Trusted Health and Wellness Solutions, Accessible to All. We are proud to be a Top 10 player in the European Consumer Self-Care market and the largest U.S. store brand provider of over the counter and infant formula. Dedicated to providing The Best Self-Care for Everyone, we are the people behind the brands you trust. We are Opill®, Compeed®, Solpadeine®, NiQuitin®, and many more. We Are Perrigo. We are committed to enhancing the wellbeing of our colleagues and consumers alike. We pride ourselves on fostering an inclusive, collaborative culture where each person can experience a sense of belonging.
Join us on our One Perrigo journey as we evolve to win in self-care.
Description Overview
The Technical Data Analyst is responsible for designing, developing, and maintaining enterprise ETL and data integration solutions with a primary focus on SAP BusinessObjects Data Services (BODS) and Microsoft Azure Data Factory (ADF). This role ensures data accuracy, consistency, and availability across SAP master data domains and other enterprise systems. The analyst will also design data flows and integration patterns, collaborate with business and technical teams, and enforce Perrigo’s data governance standards. Additionally, the role includes managing and reviewing System Integrators (SIs) and Managed Service Providers (MSPs) to ensure adherence to Perrigo’s processes and best practices.
The Technical Data Analyst handles multiple concurrent projects, service requests, and support tickets across various data domains. This position may also provide work direction to contract employees and consultants assisting with specific projects.
Scope of the Role
- Design, develop, and maintain ETL processes using SAP BODS and Azure Data Factory
- Create and document technical specifications, data flows, and integration patterns
- Collaborate with SAP Data Analysts, SMEs, and IT teams to align technical solutions with business requirements
- Review, debug, test, and deploy ETL enhancements supporting SAP and cloud integrations
- Manage and review deliverables from System Integrators and MSPs to ensure compliance with Perrigo’s standards
- Provide guidance to external partners on ETL design and integration best practices
- Maintain project documentation, validation records, and change control documentation in a validated cGMP environment
Experience Required
- Extensive experience with SAP BusinessObjects Data Services (BODS) is required
- Hands-on experience with Azure Data Factory (ADF) is required
- Experience with Databricks is a plus
- Strong knowledge of Master Data Management and ETL activities
- Familiarity with SQL, SAP SLT, data modeling concepts, and ETL development lifecycle
- Ability to design and document data flows, mappings, and integration patterns
- Python scripting and API integration experience are a plus
- Strong analytical and communication skills
- Ability to translate business processes into technical requirements
- Comprehensive understanding of SAP master data elements (Material, Customer, Vendor, Finance)
- Ability to read and interpret process flow documentation for mapping, harmonization, and cleansing
- Experience managing and reviewing System Integrators and MSPs for compliance with internal standards
- These skills are typically acquired through the completion of a Bachelor's degree in Business Information Systems, Computer Science, or closely related field; combined within 5-10 years of experience in ETL development and data integration roles
Benefits
We believe our people are our greatest asset. Alongside competitive compensation, we offer benefits tailored to supporting you and your family, as well as career development opportunities to ensure you feel valued and supported, both professionally and personally.
Find out more about Total Rewards at Perrigo.
Hybrid Working Approach
We love our offices and the setting they provide for in-person collaboration and celebration. But we also appreciate the opportunity to work remotely can energise you too, so we promote flexibility with the ability to work two days a week from home in many roles.
We are proud to be included in the Forbes list of "America's Best Employers by State 2024". Find out more here
Applicants please note: To apply to this position please click the APPLY button at the bottom of the application. (The SAVE button will only save your profile information but not submit an application for this open position.) Thank you.
We are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or other characteristics protected by law. #weareperrigo
Nearest Major Market: Grand Rapids