SAP Business Intelligence Manager

Job description

Responsibilities

• Strong ability to lead discussions with the business to analyze reporting needs, configure and model data into SAP BW and SAP BOBJ and develop reports in BI.
• Develop, implement and manage the ETL process to bring data from SAP ECC into BW.
• Develop and maintain processes to load data from non-SAP source systems.
• Develop options for data access (e.g. Web Solution, ECC drill-through, DSO reporting, master data reporting, etc.)
• Create and maintain data structures (DSOs, Infocubes & Multi-providers, etc.)
• Create and maintain process chain load schedules.
• Work with the Basis and Network teams to analyze and tune the BI environment.
• Build and enhance BI reports and dashboards.
• Conduct user requirements gathering and documentation designs.
• Develop functional and technical specifications, and complete object development and testing.
• Design and execute testing plans to validate the data loading process, data integrity and that report data elements are meeting business requirements.
• Work closely with end users to prioritize and manage completion of support tickets. Track and report BI support metrics.
• Manage projects assigned through the full project lifecycle including managing and coordinating the work of consultants when necessary.
• Document and control all changes made to productions systems via change control process.
• Stay current with SAP’s BI technology, business and industry issues and drivers.

Requirements

• Some off shift work will be necessary to support project implementation, application changes and/or conversions that are required to be done during hours that do impact normal business operation. Typically these are scheduled at night and/or weekends.
• Travel: 10% - varies based on project requirements
• Minimum Education: Bachelor’s Degree
• 7+ years of experience data processing and modeling and report development in SAP BW/BI version 3.5 or higher.
• 1 year of experience on SAP BI 7.0 is desired.
• Knowledge and experience with Business Objects is a plus.
• Knowledge and experience with BPC v10 integration with BW is a plus.
• Knowledge of core SAP Modules (SD, MM, FICO, PP, and QM)
• ABAP Programming experience is a plus.
• In-depth knowledge of SAP BW Data Architecture.
• Strong systems architecture and design skills.
• Knowledge and experience with data warehouse logical modeling Star Schema, Fact, Dimension, Snow-flake, Lookup, Staging, cube
• Experience with BI Administrator Workbench
• Two or more full project life cycle SAP implementations including blueprinting, design of the data warehouse architecture, data structure and report development, testing, end user training and post implementation support.
• Understanding and use of SDLC methodology good practice.
• Experience with business case development, project planning and estimation is a must.
• Strong Word, Excel and PowerPoint skills are required.
• Experience working for a Consumer Packaged Goods (CPG) company.

Success Factors

• Analytical Ability: superior analytical skills to evaluate new business requirements, issues, think through complex, multidimensional problems and propose appropriate solutions.
• Highly Collaborative: highly accountable and naturally works well with the team to seek innovative solutions and can identify, design and configure the system to meet the company’s business users’ requirements
• Multi-Task: ability to work on a number of deadline driven projects simultaneously with a sense of urgency.
• Detail Oriented: keen attention to detail.
• Self-Motivated: able to thrive in a fast paced environment with minimal direction.
• Excellent Verbal & Written Communication Skills to interface with business customers on a daily basis as well as related to project work
• Good presentation skills to articulate ideas, options and solutions to business and IT team
• Demonstrated ability to work in (virtual) teams to provide support and business solutions
• Strong presentation skills with experience conducting workshops to facilitate continuous improvement in the implemented design and training.

The Sun Products Corporation is a leading North American manufacturer and marketer of fabric care and household products with annual net sales of approximately $2 billion. Headquartered in Wilton, Connecticut, Sun Products was formed in September 2008 from the combination of Unilever's North American fabric care business and Huish Detergents, Inc, a leading manufacturer of private label laundry and dish products. The Company’s portfolio of products are sold under well-known brands that include all®, Snuggle®, Sun®, Wisk®, Surf®, and Sunlight®. In addition, Sun Products is the leading manufacturer of retailer brand laundry and dish products in North America.

The Company employs 2,500 associates and maintains offices and Research & Development facilities in Fairfield County, Connecticut; Salt Lake City, Utah and Toronto, Canada. The Company also operates manufacturing facilities in Salt Lake City, Utah; Bowling Green, Kentucky; Dyersburg, Tennessee and Houston, Texas. For more information visit: www.sunproductscorp.com

All qualified applicants will receive consideration for employment without regard to 
race, color, religion, sex, national origin, disability or protected veteran status.