BI Developer - OBIEE

Company: Niagara Bottling
Location: Diamond Bar
Posted on: January 19, 2023

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 - OBIEEAs 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.Detailed DescriptionParticipate 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 noticeWork Experience/KSA sRequired:7-10 years Experience in OBIEE, 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 programming0-2 year(s) 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 accomplishmentsAdditionally, the IT Developer is expected to demonstrate:Accuracy, completeness and pay close attention to detailAbility to work independently and multi-task effectivelySolid problem solving and analytical capabilitiesFlexible and willing to accept a change in priorities as necessaryPromptly notifies his/her manager about any problems that affect his/her ability to accomplish planned goalsMust be a resourceful and innovative problem solverAbility to work in a professional manner, be flexible, and handle interactions with all levels of the organizationDemonstrate ability to communicate well with other members of the IT departmentSelf-directed, organized, and motivatedGood written and verbal communications skills are requiredExcellent team playerEducationMinimum Required:Bachelor's Degree in Computer Science or EngineeringPreferred:Master's Degree in Computer Science or EngineeringCertification/License: Required: None RequiredPreferred: Oracle Business Intelligence Foundation Suite 11g/12cBenefitshttps://careers.niagarawater.com/us/en/benefitsThis job is intended to be performed entirely outside of ColoradoAny 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.

Keywords: Niagara Bottling, Diamond Bar , BI Developer - OBIEE, Other , Diamond Bar, California