BI Developer - OBIA/ODI @ Niagara Bottling - Diamond Bar, CA

Job Overview

2 months ago

BI Developer - OBIA/ODI

Niagara Bottling - Diamond Bar, CA

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 Developer - OBIA/ODI

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 projects. Working with cross-functional teams, this person will be responsible for preparation of detailed specifications, technical design, development, documentation, testing, implementation and support of large-scale projects in the cloud, with a firm grasp of emerging technologies, platforms, and applications, and ability to customize them to help our business become more secure and efficient. Extensive knowledge of cloud maintenance and advanced industry knowledge is key to keeping us on the cutting edge. From day one, this role will have an immediate impact on the day-to-day efficiency of our IT operations, and an ongoing impact on our overall growth.
  • Participate in creation of a well-informed cloud strategy and administer the adaption process
  • Regularly evaluate cloud applications, hardware, software and propose best practices to optimize cloud presence, performance, security, and cost
  • Build and Manage Azure DevOps pipelines for CI/CD and Release Management workflows
  • Manage Azure DevOps repos and branch policies
  • Proficient with Microsoft Azure Cloud and/or Amazon Web Services
  • Carrying out deployment, maintenance, monitoring, and management tasks within this implemented cloud structure
  • Working with business to understand their needs and to implement the cloud strategies designed to meet those needs
  • Translating project-specific needs into a cloud structure that will suit those needs and considering the project needs in terms of resource usage and scalability
  • Work closely with IT security to monitor the cloud privacy
  • Employ exceptional problem-solving skills, with the ability to see and solve issues before they affect business productivity
  • Respond to technical issues in a professional and timely manner
  • Identify the top cloud architecture solutions to successfully meet the strategic needs
  • 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
  • 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
  • Participate and handle full Software Development Life Cycle (SDLC)
  • Participate with ERP development team to convert legacy reports (Oracle Discoverer reports)
  • 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

Work Experience/KSA’s

  • Required:
    • 5-7 years – Experience in AI/ML projects, Azure ML Studio, DevOps
    • 5-7 years – Experience in Python/R, Jupyter, Spark technologies
    • 3-5 years – Experience with ODI/Informatica/Azure Data Factory/Databricks/Confluent
    • 3-5 years – Experience with Data Modeling, Data Mart design, ETL Architecture
    • 3-5 years – Experience in OBIEE/Power BI/OAC/Tableau
    • 3-5 years – Experience in performance tuning of ETL process, reports/dashboards
    • 3-5 years – Experience with PL/SQL to support ETL processes
    • 2-4 years – Experience with Java programming

  • Preferred:
    • 7-10 years – Experience in AI/ML projects, Azure ML Studio, DevOps
    • 7-10 years – Experience in Python/R, Jupyter, Spark technologies
    • 5-7 years – Experience with ODI/Informatica/Azure Data Factory/Databricks/Confluent
    • 5-7 years – Experience with Finance/Supply Chain/MFG/Proc/EAM modules in BI Apps
    • 5-7 years – Experience with Data Modeling, Data Mart design, ETL Architecture
    • 3-5 years – Experience in OBIEE/Power BI/OAC/Tableau
    • 3-5 years – Experience with PL/SQL to support ETL processes
    • 3-5 years – Experience with Java programming
    • 2-4 years – Experience with Snowflake/Synapse/ADW
    • 2-4 years – Experience in understanding Oracle ERP (R12), OTM, WMS (Manhattan)
    • 0-2 year(s) – Experience in Oracle Analytics Cloud Services (OACS)


  • 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



  • Preferred: Oracle Business Intelligence Foundation Suite 11g/12c

Typical Compensation Range

Pay Rate Type: Salary

$92,976.00 - $134,816.00 / Yearly


Any employment agency, person or entity that submits a résumé into this career site or to a hiring manager does so with the understanding that the applicant's résumé 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 résumé to the designated Niagara Bottling, LLC recruiter or, upon authorization, submit résumé into this career site to be eligible for placement fees.

Similar Jobs

Data Warehouse / Business Intelligence / ETL Developer

Orange County's Credit Union

Santa Ana, CA

Data Warehouse/Business Intelligence /ETL Developer. Must reside in the state of CA, AZ, NV or TX. Generous benefits include paid health insurance, time-off…

Business Intelligence Data Manager

Planned Parenthood of the Pacific Southwest

San Diego, CA

As the Business Intelligence Data Manager you will have the opportunity to be the critical linkage and liaison between the “front-end” (clinical quality and…

Senior Technical Support Engineer


San Diego, CA

Any bi-directional, automated integration between two systems. Ability to work closely with high-value customer administrators and developers that have a…

Power BI Developer

Purple Drive Technologies

Irvine, CA

Min 4+ years extensive hands-on experience in developing Intuitive visualization, Dashboards, KPI scorecards, Charts, Graphs usingPower BI.

Senior Analyst

Netchemistry, Inc.

Newport Beach, CA

Primary developer for data integration, writing efficient SQL queries, performing advanced database and query tuning, automating work/jobs where appropriate,…

Data Product Manager, Asst.

Mercury Insurance Services, LLC

Brea, CA

Collaborate with cross-functional teams, including data scientists, data/analytics engineers, software developers and 3rd party data vendors to design and build…

Power BI Developer


Irvine, CA

Irvine, CA 92602: Reliably commute or planning to relocate before starting work (Required). Power BI Developer: 8 years (Preferred).

BI Developer, Revenue Cycle, Remote


Irvine, CA

The Rev Cycle BI Developer supports the organization and its strategic affiliates in the development of meaningful reporting and analytic visualization…

Power BI Developer with Alteryx

Nextra Inc

Irvine, CA

Min 4+ years extensive hands-on experience in developing Intuitive visualization, Dashboards, KPI scorecards, Charts, Graphs using Power BI.

Consultant – Canada Only - Campus Recruiting 2023


Ontario, CA

Programmers and developers are responsible for programming and developing software using various programming languages and related tools and frameworks,…

Sr. Backend Engineer

Everytable Inc

Vernon, CA

Culture of feedback and coaching (bi-annual performance appraisals). Experience working with developers, QA, product managers and other resources that are on…

Senior CRM Manager


Newport Beach, CA

Experience working with both internal and external designers and developers. The Sr. CRM Manager is responsible for managing CRM campaigns from conception to…

Data Engineer


El Segundo, CA

The Application Development and Support Team consists of both analysts and developers that provide critical support for all applications and its integration…

Paid Bootcamp- STEM Entry Level Data Analyst and Visualization

PCS Global Tech

Riverside, CA

Help write and optimize in-application SQL statements. Ensure performance, security, and availability of databases. Managing users and user roles.

SQL Database Administrator

Kawasaki Motors Corp., U.S.A.

Foothill Ranch, CA

Builds and maintains strong partnerships with developers and application management to provide database technical leadership, support, and to identify…

SQL Database Administrator


Foothill Ranch, CA

Builds and maintains strong partnerships with developers and application management to provide database technical leadership, support, and to identify…

EPIC Business Intelligence Developer Advisor

Elevance Health

Cerritos, CA

This position will take part in Elevance Health’s hybrid work model and is eligible for a remote work schedule.

Principal Data Integration Architect - FT/Remote

MemorialCare Health Services

Fountain Valley, CA

They analyze and provide resolutions to all EDW related data issues and coordinate with developers or subject matter experts (SME) to validate all requirements.

Software Engineer

J. Paul Getty Trust, The

Los Angeles, CA

Perform code reviews and provide feedback to peer developers. Many positions have bi-weekly Off-Fridays. At Getty Digital, we're re-imagining how we can use…

Senior BI Developer


Carlsbad, CA

From setting the standard for drive-thru headsets and timer systems in the quick service restaurant (QSR) industry to developing professional audio equipment…

BI & Data Visualization Developer

Citizens Business Bank

Rancho Cucamonga, CA

The DW-BI & Visualization developer must drive the completion of projects within the established scope, while simultaneously plan for and manage the unknown…

Sr. Full Stack Developer


Los Angeles, CA

8+ years of experience as a developer supporting a headless ecommerce architecture in a production environment. Familiar with Figma or equivalent.

IT Business System Analyst


Vernon, CA

Work closely with developers to create, enhance, and maintain bolt-on applications. Under the administrative direction of the Director of IT, the IT Business…

Project Manager

York Telecom Corporation

Anaheim, CA

Collaborates with cross-functional teams including architects, software engineers, developers and technical leads to ensure timely delivery of project.