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

Date Posted: 10/17/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 who will join our Business Intelligence, Senior Analyst team in Information Technology.

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


This position's main responsibilities involve the analysis, design, development and configuration of reports for business users leveraging SAP Business Warehouse & other BI tools.  Activities also include working with business users to establish requirements for new reports and modify existing reports; design, configure and test reports to business specifications; troubleshoot issues on scheduled reports in order to diagnose and provide resolution; 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.

  • Prepares and reviews 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

What you’ll need to be successful:

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

  • 3 years of experience desired with SAP BW/BI tools (BW, BEx, BOBJ, HANA, etc.).

  • 3 years of experience desired with database technologies.

  • Experience building Tableau dashboards.

  • Basic understanding of project management is a plus.

  • Good knowledge of business analysis and systems design.

  • Ability to translate business requirements into technical requirements.

  • Experience using data warehouse or analytical tools.

  • Solid understanding of software development lifecycle processes and methods.

  • Strong relational and dimensional data modeling and database design skills.

  • Proficient understanding of data and reporting methodologies.

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.