Business Intelligence Senior Analyst in Marysville, OH at Hawthorne Gardening Co.

Date Posted: 10/25/2019

Job Snapshot

Job Description

At the Hawthorne Gardening Company (HGC) we want our people to empower more people to garden no matter where and how they choose to grow. We accomplish this by encouraging people to live happier, healthier lives through gardening. If you also feel this way then you’d fit in great with us!

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? Check out our other career opportunities and learn more about what it’s like to work at Hawthorne Gardening Company by accessing our Talent Network: HGC Talent Network

The Hawthorne Gardening Company is a start-up company focused on hydroponic gardening. Dedicated to creating high quality products founded in social and environmental responsibility. Backed by the largest lawn and garden company in the U.S. (Scotts Miracle-Gro, NYSE: SMG) we bring new ideas, values, and culture to our endeavors without the constraints of a large corporation. We are an energetic, progressive-minded, sustainability-focused group of highly-motivated individuals, eager to share our love of gardening with the world.

The brands and products within our portfolio include: Sunlight Supply, General Hydroponics, General Organics, Vermicrop, Botanicare, AeroGarden, CanFilters and Gavita Lighting.

Hawthorne Gardening Company 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 Hawthorne Gardening 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 Hawthorne Gardening Company will not consider or approve payment regarding recruiter fees or referral compensations.


  1. Business Analyst Jobs
  2. Systems Analyst Jobs