Domaine: Systèmes & Technologies de l'Information

Type d‘emploi: Temps plein

Ville: New Jersey - Berkeley Heights

Pays: USA

Job Title: Manager - IT Business Intelligence Business Analyst

Job Family: Enterprise Information Warehouse Team / Business Intelligence

Location: Berkeley Heights, NJ


Job Summary:

As a member of the Business Intelligence team, the Business Analyst is responsible for determining the requirements for BI solutions to optimize inventory and forecasting processes, managing the relationship between the BI team and business partners and for providing on-going support for business solutions.  This person will also work closely with both internal and external solutions providers to manage workflow and solution quality.

Solution Delivery Management

Design and improve workflow processes to manage priorities and delivery of BI solutions that optimize the productivity of external support resources and BI team.  Collaborate with BI management on a front end strategy for data warehouse objects that will enable new and advanced analytical capabilities. 

Improve solution designs to ensure stability of processes, consistent data quality, reusable solutions and optimal usability.

Develop Business requirements:

  • Elicit requirements from business partners of all levels and document the information requirements in formal requirement documents.
  • Prepare detailed flow charts, diagrams and other documentation outlining system capabilities and processes.
  • Analyze the quality, availability and relevance of information in systems, including demand planning, manufacturing and SAP MM/WM for use in analytical applications.
  • Document business rules for handling transactional and master data from these systems for use in BI solutions.
  • Conduct meetings with business partners across the organization to understand requirements and develop solutions, anticipating emerging needs as the business evolves.
  • Align the needs of business units with the capabilities delivered by the business intelligence team and serve as liaison between those groups.
  • Facilitate the resolution of conflicting needs and ensure that solutions adhere to L’Oreal norms.
  • Provide Subject matter expertise on the processes, technology and information involved in producing business intelligence solutions around inventory and supply chain reporting and guide the business partners in their decision making to ensure that the information can support their business needs.
  • Communicate requirements and systems impact to other BI Team members and develop time estimates for effort completion.
  • Manage relationship with external vendor(s) and data providers to ensure timely and accurate information delivery.

Deliver Solutions:

  • Translate business requirements into a proposed solution, reviewing the design and requirements with solution delivery teams. 
  • Manage projects from estimation to completion, developing detailed project plans and providing accurate status updates to management.
  • Test solution and coordinate user acceptance testing, ensuring that solution performs to expectations and meets all requirements for accuracy, clarity and ease of use.
  • Ensure that all standards for data quality, compliance and L’Oreal norms are upheld in solution.  Design repeatable processes with little manual intervention required.


  • Conduct business user training sessions, both in classroom setting and 1-1 training.
  • Develop and maintain training materials, Wiki material and user documentation.
  • Respond to and determine priority of incident reports and requests from Business Users.  Communicate status of issue resolution to business users and management and manage tickets to reflect current status.
  • Research issues and Identify root cause of information issues and work with appropriate resources to design a solution that will prevent the problem from re-occurring.   Where business processes need to be adjusted to ensure stability, work with business leaders to define better processes.
  • Manage security access to business data, ensuring confidentiality of sensitive information.
  • Identify opportunities to improve both the business and technical processes to increase efficiency, accuracy or functionality of our solutions.


Education: Bachelor’s degree or equivalent work experience required

Business Skills:

  • Strong understanding of the supply chain and inventory management processes and the key performance indicators used to manage the business.
  • Strong understanding of sales processes and SAP SD information.
  • Critical thinking and the ability to analyze complex business and information environments a must.
  • Ability to identify business drivers and define control mechanisms to improve efficiency and performance.

Interpersonal Skills:

·         Professional Presence, Innovation / Creativity, Strong Communication Skills (Both Written and Verbal), Entrepreneurial, Strong Integrity, Results driven, ability to negotiate and influence

Management Skills:

  • Timely status reporting, time management and ability to multi task, team player.  Project management experience. 

Technical Skills:

  • Ability to use reporting functions of Excel and Analyzer against cubes and other data sources
  • Microsoft BI stack (SSRS, SharePoint, SSAS, etc) knowledge a plus.
  • Spotfire Dashboard knowledge a plus

Experience Guideline:

  • 5+ years’ using / analyzing businesses information cubes and databases and creating reports to support business processes and support. 
  • Experience using Excel and Analyzer to develop reports needed.
  • Experience in defining processes for managing prioritization of issues and requests and working with internal and external solutions delivery resources.
  • Full understanding and experience with SDLC and documentation techniques.

We are an Equal Opportunity Employer and take pride in a diverse environment. We do not discriminate in recruitment, hiring, training, promotion or other employment practices for reasons of race, color, religion, gender, sexual orientation, national origin, age, marital or veteran status, medical condition or disability, or any other legally protected status.