BI Developer - (OBI/OAC)

Company: Niagara Bottling
Location: Diamond Bar
Posted on: April 23, 2024

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 Developer - (OBI/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 requirementsTranslate business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sourcesTransition developed reports and dashboards to the Operations & Support teamProvide support as required to ensure the availability and performance of developed reports and dashboards for both external and internal usersEnsure proper configuration management and change controls are implementedWork closely with offshore team(s) and participate in scrum callsProvide technical assistance and cross training to other team membersProvide training, user documentation and assistance to end users as requiredDesign and implement technology best practices, guidelines and repeatable processesUnderstanding Data Sources and Data Modeling concepts to develop and enhance the existing Data WarehouseExperience with a variety of sources (XML, Oracle, flat file, excel spreadsheets, transactional (OLTP) sources, etc.)Knowledge of logical and physical database modeling concepts and techniquesUnderstand normalized and star-schema physical models and logical modeling conceptsFollow and implement Business Intelligence best practices and architectural standardsCollaborate with Oracle ERP Analyst to identify and resolve data quality issuesParticipate 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 solutionCoach/mentor other team members as appropriate to facilitate their professional developmentPlease 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 noticeQualificationsRequired:7-10 years
Experience in OBIEE or OBIA, BI Apps, OTBI, ODI, Informatica7-10 years
Experience building complex reports/dashboards5-7 years
Experience with OBIEE repository (RPD) for all layers5-7 years
Experience with Data Modeling, Data Mart design, ETL Architecture5-7 years
Experience with ODI Mappings, Interfaces, Packages, Knowledge modules5-7 years
Experience with Finance, Supply Chain, Manufacturing, Procurement, EAM modules in BI Apps5-7 years
Experience with implementing security in OBIEE2-4 years
Experience in performance tuning of ETL process, reports/dashboards2-4 years
Experience with PL/SQL to support ETL processes2-4 years
Experience with Java programming2-4 years
Experience in Oracle Analytics Cloud Services (OACS)Preferred:10+ years
Experience in OBIEE, BI Apps, OTBI, ODI, Informatica10+ years
Experience building complex reports/dashboards7-10 years
Experience with OBIEE repository (RPD) for all layers7-10 years
Experience with Data Modeling, Data Mart design, ETL Architecture5-7 years
Experience with ODI Mappings, Interfaces, Packages, Knowledge modules5-7 years
Experience with Finance, Supply Chain, Manufacturing, Procurement, EAM modules in BI Apps5-7 years
Experience with implementing security in OBIEE3-5 years
Experience in performance tuning of ETL process, reports/dashboards3-5 years
Experience with PL/SQL to support ETL processes3-5 years
Experience with Java programming2-4 years
Experience in understanding Oracle ERP (R12), OTM, WMS (Manhattan)2-4 years
Experience in Oracle Hyperion/EPM0-2 year(s)
Experience in integrating OBIEE with MapViewer and geospatial analysis0-2 year(s)
Experience using Oracle Data Mining to create predictive models0-2 year(s)
Experience in Oracle Analytics Cloud Services (OACS)0-2 year(s)
Experience with Snowflake databaseCompetenciesListens and responds constructively to other team member s ideasProven leadership qualitiesPays close attention to detail, accuracy and completenessPromptly notifies his/her manager about any problems that affect his/her ability to accomplish planned goalsExpresses pride in the group and encourages people to feel good about their accomplishments*experience may include a combination of work experience and educationEducationMinimum Required:Bachelor's Degree in Computer Science or EngineeringPreferred:Master's Degree in Computer Science or EngineeringTypical Compensation RangePay Rate Type: Salary$95,301.00 - $138,186.00 / YearlyBenefitshttps://careers.niagarawater.com/us/en/benefitsAny employment agency, person or entity that submits a rsum into this career site or to a hiring manager does so with the understanding that the applicant's rsum 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 rsum to the designated Niagara Bottling, LLC recruiter or, upon authorization, submit rsum into this career site to be eligible for placement fees.Niagara Plant NameCORP-MAIN

Keywords: Niagara Bottling, Covina , BI Developer - (OBI/OAC), IT / Software / Systems , Diamond Bar, California