IT Supply Chain Planning Applications, Senior Analyst in Marysville, OH at ScottsMiracle-Gro

Date Posted: 9/15/2019

Job Snapshot

Job Description

Here at Scotts Miracle-Gro there is no such thing as a typical day.  Our culture is constantly energized by new and exciting growth opportunities and at a rapid pace.  Every Associate plays an important role in providing innovative solutions for today’s gardeners and growers and contributing new ideas to improve operations. In our company you need grit, it is what we were founded on over 150 years ago and is what keeps us growing. Regardless of your level in the organization there is a platform for your voice to be heard and the ability to influence change. Family, community and hard working values are weaved into all that we do. Come grow with us, where we develop and nurture the next generation of leaders. ​

We are looking for a Sr Analyst who will join our IT Supply Chain Planning Application team in Marysville, Ohio.

This position will be based at The Scotts Miracle-Gro world headquarters in Marysville, a suburb of Columbus, OH. Not familiar with Columbus? Visit

The IT Supply Chain Planning Applications, Senior Analyst is part of the team responsible for maintaining and enhancing business applications viz. SAP R/3 Production Planning (PP), JDA /Manugistics Supply chain planning suite.

This position is expected to work with users to define business requirements, design solutions, configure the system, define and develop Oracle scripts/programs, execute test scripts to validate the solution, create end user and technical support documentation in order to implement the solution. Experience in developing scripts (code) with Oracle PL/SQL or SQL is necessary to successfully perform this role.

What you’ll do in this role:

  • Configure JDA Supply chain suite to meet business requirements.
  • Develop Oracle PL/SQL Scripts to meet business requirements within JDA.
  • Design, Develop integration with SAP and JDA using Business Object Data services ETL tool
  • Conduct Unit testing and cross-functional integration testing for solutions
  • Provide timely production support for break-fix issues, provide nightly batch support
  • Support production environment by trouble-shooting system issues and providing system solutions or process improvement options
  • Assist in gathering requirements, design, and developing minor and major system enhancements
  • Ensure Technical documentation is up to date
  • Ensure the Business systems are secure and reliable in supporting continuous operation of the company. Ensure software is current and install patches to keep application up-to-date.
  • Collaborate with internal Business Partners and works cross-functionally with departmental team members
  • Drives continuous improvement by collaborating with business and department associates in areas of opportunity

What you’ll need to be successful:

  • Strong analytical, problem-solving, and conceptual skills
  • 4-5 Years of experience in Oracle databases, Windows and Unix (including Linux) operating environments.
  • 4-5 Knowledge of Unix Shell & Windows scripting, Oracle PL SQL, SQL skills
  • 3-4 years of JDA development experiences. Exposure to JDA modules of Demand Planning. Fulfillment / Master planning is preferred.

What we do for you (just to list a few cool ones)

  • Offer extremely competitive benefits including: Health, Dental and Vision coverage.

  • Onsite wellness center which includes: 2,400 sq. ft. fitness center, Walgreens pharmacy and Doctor’s office. 

  • Beautiful campus and corporate offices designed like a log cabin offering free coffee, chef-run cafe and the best crushed ice! 

  • Unbelievable 401K match (up to 7.5%) and discounted stock purchasing program (15% discount).

  • Our commitment to diversity and inclusion includes four employee resource groups: Scotts Women’s Network, Scotts Black Employee Network, Scotts Veterans Network and Scotts Young Professionals.

  • Generous holiday and vacation days.

Not interested in this role? Stay up to date on future opportunities by joining our ScottsMiracle-Gro and Hawthorne Gardening talent networks.

Scotts is an EEO Employer, dedicated to a culturally diverse, drug free workplace.

EEO/AA Employer/Minority/Female/Disability/Veteran/Sexual Orientation/Gender Identity

Notification to Agencies:

Please note that the Scotts Miracle-Gro company does not accept unsolicited resumes from recruiters or employment agencies. In the absence of a signed Master Service Agreement, and specific approval to submit resumes to an approved requisition, the Scotts Miracle-Gro company will not consider or approve payment regarding recruiter fees or referral compensations.