Immediate Focus

  1. Need to facilitate daily, weekly, monthly updates to ensure data integrity.
    • Until fully on SAP, there will be constant data scrubbing requirements.
    • Must monitor system performance.
    • Master Data Czar: Ensure new customers, products, attributes etc. are maintained.
    • Ensure sync with SAP and other source systems
  2. Reporting and analysis.
    • Identify, develop, test and deploy new reports, views and extracts
  3. Participate in SAP Rollout and ongoing support to ensure integrity and functionality.
  • Define and implement source and use appropriate reporting.
  • Assist with Data Conversion from Legacy.
  • Assess future use of SAP's Business Warehouse tool vs. Cognos.

Ongoing Responsibilities:
This position works closely with the management and Information Technology team to develop and support business intelligence and reporting solutions providing access to critical data which will enable management to make informed decisions. This role has high visibility to, and engagement with, the business at the lead and management level.

The Business Intelligence (BI) Analyst role is responsible for:
  • Ongoing business reporting and analysis out of our operational and data warehouse systems.
  • Reviewing, analyzing, and modifying BI systems including coding, testing, debugging and documenting programs. Works within an existing data and systems framework, as well as expands the design and capabilities.
  • Developing a strong working relationship with the appropriate business users to understand the key business drivers and priorities.
  • Developing a broad understanding of systems (current and future) within the Company suite of applications and understanding their integration to the BI solutions.
  • Providing support to the BI user community.
  • Identifying and designing BI solutions. While primarily focused on internal operational data it is critical to coordinate BI efforts and solutions with the external consumer and customer analysis done through ACNielsen.
  • Create training materials and user documentation.


Experience
  • 3 to 5 years excellent track record working as a BI analyst or similar role.
  • 5 to 7 years BI development, implementation and support experience, preferably in a Cognos and Microsoft SQL Server environment.
  • A strong working knowledge of ERP and Financial applications. Previous experience with SAP is highly desirable.
  • Past experience in Consumer Packaged Goods sector, specifically Food and Beverage, is preferable. Experience with analysis of consumer or customer data a plus.
  • Strong understanding of distribution, sales reporting, inventory management, and finance processes in a manufacturing environment preferred.

Competencies
  • Strong analytical skills, especially as it relates to Business reporting and reconciliation requirements.
  • Strong problem solving skills
  • High self-motivation and strong delivery focus
  • Excellent team-working skills
  • Strong communicator with both Business users and technical staff
  • Pro-active ability to work with individuals at all levels, including executive management, to define Business requirements and obtain user sign-off
  • Rigorous attention to detail and application of standards and process

Technical Skills
  • Proficiency with BI tools; Cognos Impromptu and PowerPlay (both web and Windows) and/or SAP preferred.
  • Strong working knowledge of Microsoft SQL Server, including Data Transformation Services (DTS)
  • Advanced experience with Microsoft Excel, Access.
  • Deep understanding of logical and physical data modeling.
  • Appreciation of systems analysis methodologies, standards, tools and techniques

Experience: Cognos SAP SQL Access To Apply to this job go to http://www.GadBall.com or click here