Title: Manager - IT Business Intelligence Business Analyst
Family: Enterprise Information Warehouse Team / Business Intelligence
Berkeley Heights, NJ
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
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.
solution designs to ensure stability of processes, consistent data quality,
reusable solutions and optimal usability.
Develop Business requirements:
requirements from business partners of all levels and document the information
requirements in formal requirement documents.
detailed flow charts, diagrams and other documentation outlining system
capabilities and processes.
the quality, availability and relevance of information in systems, including
demand planning, manufacturing and SAP MM/WM for use in analytical
business rules for handling transactional and master data from these systems
for use in BI solutions.
meetings with business partners across the organization to understand
requirements and develop solutions, anticipating emerging needs as the business
the needs of business units with the capabilities delivered by the business
intelligence team and serve as liaison between those groups.
the resolution of conflicting needs and ensure that solutions adhere to L’Oreal
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.
requirements and systems impact to other BI Team members and develop time
estimates for effort completion.
relationship with external vendor(s) and data providers to ensure timely and
accurate information delivery.
business requirements into a proposed solution, reviewing the design and
requirements with solution delivery teams.
projects from estimation to completion, developing detailed project plans and
providing accurate status updates to management.
solution and coordinate user acceptance testing, ensuring that solution
performs to expectations and meets all requirements for accuracy, clarity and
ease of use.
that all standards for data quality, compliance and L’Oreal norms are upheld in
solution. Design repeatable processes
with little manual intervention required.
business user training sessions, both in classroom setting and 1-1 training.
and maintain training materials, Wiki material and user documentation.
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
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
security access to business data, ensuring confidentiality of sensitive
opportunities to improve both the business and technical processes to increase
efficiency, accuracy or functionality of our solutions.
Bachelor’s degree or equivalent work experience required
understanding of the supply chain and inventory management processes and the
key performance indicators used to manage the business.
understanding of sales processes and SAP SD information.
thinking and the ability to analyze complex business and information
environments a must.
to identify business drivers and define control mechanisms to improve
efficiency and performance.
Presence, Innovation / Creativity, Strong Communication Skills (Both Written
and Verbal), Entrepreneurial, Strong Integrity, Results driven, ability to
negotiate and influence
status reporting, time management and ability to multi task, team player. Project management experience.
to use reporting functions of Excel and Analyzer against cubes and other data
BI stack (SSRS, SharePoint, SSAS, etc) knowledge a plus.
Dashboard knowledge a plus
years’ using / analyzing businesses information cubes and databases and
creating reports to support business processes and support.
using Excel and Analyzer to develop reports needed.
in defining processes for managing prioritization of issues and requests and
working with internal and external solutions delivery resources.
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.