Supply Chain Analyst (S&OP)

Location
Rensselaer, New York, US
Posted
Jul 13, 2018
Ref
13567BR
Required Education
Bachelors Degree
Position Type
Full time
Position Summary

Known for its scientific and operational excellence, Regeneron is a leading science-based biopharmaceutical company that discovers, invents, develops, manufactures, and commercializes medicines for the treatment of serious medical conditions. Regeneron commercializes medicines for eye diseases, high LDL-cholesterol, atopic dermatitis and a rare inflammatory condition and has product candidates in development in other areas of high unmet medical need, including rheumatoid arthritis, asthma, pain, cancer and infectious diseases.

Summary: Responsible for executing data analytics that impact overall supply chain projects. Generate tools and content to build data functionality supporting Sales and Operations Planning (S&OP) processes. Participates in S&OP processes and standardization initiatives. Monitors Supply Chain metrics to identify gaps in current processes, improve service levels to internal and external customers, reduce waste, and improve the value chain efficiency.

Essential Duties and Responsibilities include, but are not limited to, the following:

• Perform data analysis to design and build ways to consolidate data associated with the S&OP process; provide oversight of systems that facilitate transfer of demand and production requirement information across Demand Planning, Supply Planning, Material Planning and S&OP.

• Support S&OP systems through the development of databases and/or utilization of data entry forms and reports (potentially combined with Excel based spreadsheets and charts) to
oEfficiently upload all planning information.
oBuild and/or interpret queries and reports to provide ready-to-use excel / powerpoint friendly information from Microsoft Access.
oSupport the S&OP team to incorporate these queries and reports into day-to-day planning, scheduling, monitoring and reporting needs.

• Build ad-hoc queries and reports to gather and present information effectively to support resolution of urgent supply chain issues.

• Design novel Excel models, tools and templates by leveraging advanced formulae and programming (VBA, SQL)

• Develop analytics to identify and improve reporting efficiency.

• Develop and administer SharePoint sites to allow access to the routine reports and ad hoc information requests for all the supply chain stakeholders.

• Develop and track metrics to measure the timeliness, accuracy and integrity of data from stakeholders. Align across teams to improve reporting integrity.

• Provide support and tool or subject matter expertise to develop additional databases / reports. Document user requirements associated with development.

• Build front-end applications to SQL Server databases for end-user data entry and record management.

• Create and maintain entity relationship diagrams, user guides, and other system documentation.

Knowledge, Skills, and Abilities:

• Advanced proficiency in Microsoft Access, Excel and SharePoint

• Ability to interpret complex data and communicate recommendations

• Proficiency in VB/VBA, SQL, HTML, CSS, and one of: ASP.Net, PHP, or JSP.

• C# and web development experience are a plus.
Education and Experience:

• For Associate Supply Chain Analyst level - BS/BA in business or scientific discipline and 0-2 years of relevant experience or equivalent combination of education and experience.

• For Supply Chain Analyst level - BS/BA in business or scientific discipline and 2-5 years of relevant experience or equivalent combination of education and experience.

• For Sr Supply Chain Analyst level - BS/BA in business or scientific discipline and 5+ years of relevant experience or equivalent combination of education and experience.

*Level will be determined based on skills and related experience.*

This is an opportunity to join our select team that is already leading the way in the Pharmaceutical/Biotech industry. Apply today and learn more about Regeneron's unwavering commitment to combining good science & good business.

To all agencies: Please, no phone calls or emails to any employee of Regeneron about this opening. All resumes submitted by search firms/employment agencies to any employee at Regeneron via-email, the internet or in any form and/or method will be deemed the sole property of Regeneron, unless such search firms/employment agencies were engaged by Regeneron for this position and a valid agreement with Regeneron is in place. In the event a candidate who was submitted outside of the Regeneron agency engagement process is hired, no fee or payment of any kind will be paid.

Regeneron is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability status, protected veteran status, or any other characteristic protected by law.