Analyst, Business Intelligence in Marysville, OH at ScottsMiracle-Gro

Date Posted: 11/21/2020

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 an Analyst, Business Intelligence who will join our Business Warehouse & Intelligence team in Marysville, OH.

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 Analyst Business Intelligence’s main responsibilities involve the analysis, design, development and configuration of reports for business users leveraging SAP Business Warehouse and other BI tools. Activities also include working with business users to establish requirements for new reports and to modify existing reports; design, configuring and testing reports to business specifications; troubleshooting issues on scheduled reports in order to diagnose and provide resolution; and production support of existing BW and reporting functionality.

What you’ll do in this role:

  • Requirements gathering, system analysis, design, development/configuration of new reports.

  • Document functional and technical design specifications. Configuration, data modeling and report writing using SAP BEx and BOBJ tools.

  • Liaison with R/3 process teams and other application teams to understand how data that is sourced from these systems is processed and what business rules have been applied so it can be effectively utilized to enhance reporting and analytical solutions and resolve issues.

  • Assist in installation, upgrades and maintenance of BOBJ and Tableau software.

  • Prepare and review procedures and documentation.

  • Research, diagnose and resolve issues with data loads, and report failures.

  • Ensure on-time delivery and accuracy of Daily, Weekly and Monthly scheduled reports and data loads to different targets.

  • Production support of existing BW and reporting functionality.

  • Minimum BA/BS in Computer Science or Management Information Systems.

  • Experience working in a corporate environment.

  • Experience desired with database technologies.

  • Experience using a reporting tool (particularly Business Objects and Tableau is a plus).

  • Basic understanding of project management is a plus.

What you’ll need to be successful:

  • Entry level knowledge of the field.

  • Good knowledge of business analysis and systems design.

  • Ability to translate business requirements into technical requirements.

  • Good understanding of data and reporting methodologies.

  • Problem Solving & Analysis

  • Business Acumen

  • Communication & Leadership

  • Relationship Building

  • Creativity & Innovation

  • Organizational Savvy

  • Planning & Organizing

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

  • A place on an engaged team of passionate colleagues in a growing and dynamic industry.

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

  • First day of hire, 401K match (up to 7.5%) and discounted stock purchasing program (15% discount).

  • 12 paid holidays and generous vacation policy.

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

  • Nutrition reimbursement program (up to $200 per associate and per spouse)

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

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

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.