Sr. Data Engineer - Incorta/ODI

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.Sr. Data Engineer - Incorta/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 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.

Essential FunctionsParticipate 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 databaseCompetenciesThis position embodies the values of Niagara's LIFE competency model, focusing on the following key drivers of success:Lead Like an Owner

Makes safety the number one priorityKeeps alert for safety issues and escalates immediatelyEffectively prioritizes tasks based on department goalsShows respect to others and confronts interpersonal issues directlyPrioritizes resolution of customer issues effectivelyResponds promptly and honors commitments to internal and external customers

InnovACT

Makes recommendations to continuously improve policies, methods, procedures, and/or productsDemonstrates adaptability by reacting appropriately to unexpected changes in situations or circumstancesIncreases performance through greater efficiency

Find a Way

Seeks to develop technical knowledge through learning from other expertsUnderstands interdepartmental impact of individual decisions and actionsSeeks solutions rather than placing blame

Empowered to be Great

Consistently looks for ways to improve one's self through growth and development opportunitiesCommunicates clearly and promptly up, down, and acrossCommunicates effectively to manage expectations

EducationMinimum Required:

Bachelor's Degree in Computer Science or Engineering

Preferred:

Master's Degree in Computer Science or Engineering

Certification/License:Required: NAPreferred: NAForeign LanguageRequired: NAPreferred: NATypical Compensation RangePay Rate Type: Salary $107,143.99 - $150,001.60 / Yearly

Benefitshttps://careers.niagarawater.com/us/en/benefits* *Los Angeles County applicants only** Qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers, the California Fair Chance Act, and any other applicable local and state laws.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 Plant NameCORP-MAIN