BI Engineer II - (OBIEE/OAC)
Diamond Bar, CA 
Share
Posted 10 days ago
Job Description

At Niagara, we're looking for Team Members who want to be part of achieving our mission to provide our customers the highest quality most affordable bottled water.

Consider applying here, if you want to:

  • Work in an entrepreneurial and dynamic environment with a chance to make an impact.
  • Develop lasting relationships with great people.
  • Have the opportunity to build a satisfying career.

We offer competitive compensation and benefits packages for our Team Members.

BI Engineer II - (OBIEE/OAC)

As an integral member of our team, the Business Intelligence (BI) Developer is responsible for the design, development, implementation and support of mission-critical enterprise Business Intelligence reports/dashboards. Working with cross-functional teams, this person will participate to gather and document reporting requirements to meet business needs. Using skills and experience as a BI Developer, this person will then use those requirements to design, develop, test and implement ETL, reports and dashboards that utilize the underlying data source(s)/data warehouse(s)/data mart(s). The person in this role may assist with the preparation of detailed specifications and will be responsible for the technical design, development, documentation, testing, implementation and support of various Data Models.
  • Participate in business meetings to gather reporting and dashboard requirements
  • Translate business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources
  • Transition developed reports and dashboards to the Operations & Support team
  • Provide support as required to ensure the availability and performance of developed reports and dashboards for both external and internal users
  • Ensure proper configuration management and change controls are implemented
  • Work closely with offshore team(s) and participate in scrum calls
  • Provide technical assistance and cross training to other team members
  • Provide training, user documentation and assistance to end users as required
  • Design and implement technology best practices, guidelines and repeatable processes
  • Understanding Data Sources and Data Modeling concepts to develop and enhance the existing Data Warehouse
  • Experience with a variety of sources (XML, Oracle, flat file, excel spreadsheets, transactional (OLTP) sources, etc.)
  • Knowledge of logical and physical database modeling concepts and techniques
  • Understand normalized and star-schema physical models and logical modeling concepts
  • Follow and implement Business Intelligence best practices and architectural standards
  • Collaborate with Oracle ERP Analyst to identify and resolve data quality issues
  • Participate and handle full Software Development Life Cycle (SDLC)
  • Participate with ERP development team to convert legacy reports (Oracle Discoverer reports)
  • Provide guidance on best practices for setting up and deploying reporting solution
  • Coach/mentor other team members as appropriate to facilitate their professional development
  • Please note that this job description is not designed to contain a comprehensive list of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without prior notice

Qualifications

  • Required:
    • 6-8 years - Experience in OBIEE or OBIA, BI Apps, OTBI, ODI, Informatica
    • 6-8 years - Experience building complex reports/dashboards
    • 6-8 years - Experience with OBIEE repository (RPD) for all layers
    • 2-3 years - Experience with Data Modeling, Data Mart design, ETL Architecture
    • 2-3 years - Experience with ODI Mappings, Interfaces, Packages, Knowledge modules
    • 6-8 years - Experience with Finance, Supply Chain, Manufacturing, Procurement, EAM modules in BI Apps
    • 6-8 years - Experience with implementing security in OBIEE
    • 2-3 years - Experience in performance tuning of ETL process, reports/dashboards
    • 6-8 years - Experience with PL/SQL to support ETL processes
    • 1-3 years - Experience with Java programming
    • 6-8 years - Experience in Oracle Analytics Cloud Services (OACS)

  • Preferred:
    • 8-10 years - Experience in OBIEE, BI Apps, OTBI, ODI, Informatica
    • 8-10 years - Experience building complex reports/dashboards
    • 7-10 years - Experience with OBIEE repository (RPD) for all layers
    • 4-5 years - Experience with Data Modeling, Data Mart design, ETL Architecture
    • 4-5 years - Experience with ODI Mappings, Interfaces, Packages, Knowledge modules
    • 8-10 years - Experience with Finance, Supply Chain, Manufacturing, Procurement, EAM modules in BI Apps
    • 8-10 years - Experience with implementing security in OBIEE
    • 3-4 years - Experience in performance tuning of ETL process, reports/dashboards
    • 8-10 years - Experience with PL/SQL to support ETL processes
    • 2-4 years - Experience with Java programming
    • 2-4 years - Experience in understanding Oracle ERP (R12), OTM, WMS (Manhattan)
    • 2-4 years - Experience in Oracle Hyperion/EPM
    • 2-4 year(s) - Experience in integrating OBIEE with MapViewer and geospatial analysis
    • 0-2 year(s) - Experience using Oracle Data Mining to create predictive models
    • 0-2 year(s) - Experience in Oracle Analytics Cloud Services (OACS)
    • 0-2 year(s) - Experience with Snowflake database

Competencies

  • Listens and responds constructively to other team member's ideas
  • Proven leadership qualities
  • Pays close attention to detail, accuracy and completeness
  • Promptly notifies his/her manager about any problems that affect his/her ability to accomplish planned goals
  • Expresses pride in the group and encourages people to feel good about their accomplishments

*experience may include a combination of work experience and education

Education

  • Minimum Required:
    • Bachelor's Degree in Computer Science or Engineering
  • Preferred:
    • Master's Degree in Computer Science or Engineering

Typical Compensation Range

Pay Rate Type: Salary

$95,301.00 - $138,186.00 / Yearly

Benefits

Any employment agency, person or entity that submits a resume into this career site or to a hiring manager does so with the understanding that the applicant's resume will become the property of Niagara Bottling, LLC. Niagara Bottling, LLC will have the right to hire that applicant at its discretion without any fee owed to the submitting employment agency, person or entity.

Employment agencies that have fee agreements with Niagara Bottling, LLC and have been engaged on a search shall submit resume to the designated Niagara Bottling, LLC recruiter or, upon authorization, submit resume into this career site to be eligible for placement fees.


Niagara Bottling LLC is an Equal Opportunity Employer that does not discriminate on the basis of race, color, religion, sex, age, sexual orientation, gender identity and/or expression, national origin, veteran status or disability in relation to our recruiting, hiring, and promoting practices.

 

Job Summary
Start Date
As soon as possible
Employment Term and Type
Regular, Full Time
Required Education
Bachelor's Degree
Required Experience
6 to 8 years
Email this Job to Yourself or a Friend
Indicates required fields