Description: Work Schedule This is a remote U.S. position. Candidates may sit in any U.S. time zone. Most of the core team is on the West Coast, but the project works across U.S. and global time zones. Training can generally be accommodated during late-morning/midday hours. Candidates should have some flexibility with their schedules. Overtime / Weekend Work Some overtime and occasional weekend work may be required due to aggressive project timelines and critical deliverables. The team is working to minimize this, but candidates need to be comfortable with schedule flexibility when project needs require additional support.
The ideal candidate is a strong, hands-on Business Analyst with advanced Excel and data-analysis skills who can work through large, complex datasets, perform data validation and reconciliation, and quickly prepare information for business review. The manager wants someone who is proactive, learns quickly, and is comfortable working with ambiguity, changing priorities, and aggressive timelines. SAP/S/4HANA, data migration, testing, and supply chain experience are highly desirable, with Clinical Supply Chain experience being a significant plus. Above all, the candidate needs to be a flexible, resourceful go-getter who can come into a fast-moving transformation project, learn the business, and start adding value quickly.
Development Supply Chain (DSC) is responsible for the end-to-end delivery of products, process knowledge, and technology solutions that enable client’s accelerated product commercialization. DSC is actively supporting the transition from SAP ECC to S/4HANA, including testing activities across the clinical supply chain. The Business Analyst Principal will provide project-based analytical support for S/4HANA clinical testing, with a primary focus on managing and simplifying large, complex data sets provided. The role will use advanced Excel and analytical capabilities to transform raw testing data into clear, manageable outputs that enable the direct manager to quickly assess results, identify issues and trends, and make informed decisions.
Role Overview The team is looking for two Business Analysts to provide additional support for a large S/4HANA transformation project. The immediate priority is data migration/data review, with resources helping prepare and analyze large Excel datasets before they are reviewed by business SMEs. The role may expand to include testing, test script support, documentation revisions, training materials, and other project-related activities as priorities evolve.
Highly Desired Skills
Advanced Excel skills are the top priority
Experience working with large, complex datasets
Strong Excel formulas, lookups, comparisons, and data consolidation skills
Data migration, data validation, reconciliation, and data review experience
Ability to compare information across multiple files/tables and identify missing or inconsistent data
SAP/S/4HANA or other large ERP transformation experience strongly preferred
Testing/UAT and test script experience preferred
Strong analytical and problem-solving skills
Ability to quickly learn new business processes
Comfortable working with ambiguity and rapidly shifting priorities
Strong communication and stakeholder collaboration skills
Proactive, flexible, and able to work in a fast-paced project environment
Preferred Business Background
Supply chain experience is preferred but not required. Clinical Supply Chain experience would be a major plus. Other relevant backgrounds include Plan-to-Stock, Order-to-Cash, planning, customer service/order management, manufacturing, distribution, or similar end-to-end supply chain processes. Candidates from other industries can still be considered if they have exceptional Excel/data skills and relevant ERP/transformation experience.
Basic Qualifications Doctorate degree or Master degree and 3 years of experience or Bachelor degree and 5 years of experience or Associate degree and 10 years of experience or high school diploma / GED and 12 years of experience and previous managerial experience directly managing people and/or experience leading teams, projects, programs or directing the allocation of resources
Top 3 Must Have Skill Sets:
Advanced Excel skills, including experience working with large and complex data sets.
Strong analytical and data-management skills with the ability to translate complex data into actionable insights.
SAP experience; S/4HANA and/or supply chain experience preferred.
Day to Day Responsibilities:
Manage and analyze large, complex Excel data sets generated through S/4HANA clinical testing.
Consolidate, clean, structure, and simplify provided data into decision-ready outputs.
Develop clear summaries, trackers, and analyses that highlight key findings, exceptions, trends, and areas requiring management attention.
Support S/4HANA clinical testing activities through data analysis, reconciliation, and issue/defect tracking as needed.
Perform ad hoc analysis to support testing progress and management decision-making.
Possible Extension: Yes
Red Flags: Limited advanced Excel experience; limited experience manipulating large/complex datasets; inability to independently translate raw data into decision-ready outputs; no SAP experience.
Interview Process:
Phone Interview asap
Applicant Notices & Disclaimers
For information on benefits, equal opportunity employment, and location-specific applicant notices, click here
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position's pay range is $35.71/hr - $45.35/hr.
