Business Intelligence Developer

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. BI DeveloperAs 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 Functions• 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 noticeWork Experience/KSA’sRequired:• 7-10 years – Experience in OBIEE, BI Apps, OTBI, ODI, Informatica• 7-10 years – Experience building complex reports/dashboards• 5-7 years – Experience with OBIEE repository (RPD) for all layers• 5-7 years – Experience with Data Modeling, Data Mart design, ETL Architecture• 5-7 years – Experience with ODI Mappings, Interfaces, Packages, Knowledge modules• 5-7 years – Experience with Finance, Supply Chain, Manufacturing, Procurement, EAM modules in BI Apps• 5-7 years – Experience with implementing security in OBIEE• 2-4 years – Experience in performance tuning of ETL process, reports/dashboards• 2-4 years – Experience with PL/SQL to support ETL processes• 2-4 years – Experience with Java programming• 0-2 year(s) – Experience in Oracle Analytics Cloud Services (OACS)Preferred:• 10+ years – Experience in OBIEE, BI Apps, OTBI, ODI, Informatica• 10+ years – Experience building complex reports/dashboards• 7-10 years – Experience with OBIEE repository (RPD) for all layers• 7-10 years – Experience with Data Modeling, Data Mart design, ETL Architecture• 5-7 years – Experience with ODI Mappings, Interfaces, Packages, Knowledge modules• 5-7 years – Experience with Finance, Supply Chain, Manufacturing, Procurement, EAM modules in BI Apps• 5-7 years – Experience with implementing security in OBIEE• 3-5 years – Experience in performance tuning of ETL process, reports/dashboards• 3-5 years – Experience with PL/SQL to support ETL processes• 3-5 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• 0-2 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 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 priority• Keeps alert for safety issues and escalates immediately• Effectively prioritizes tasks based on department goals• Shows respect to others and confronts interpersonal issues directly• Prioritizes resolution of customer issues effectively• Responds promptly and honors commitments to internal and external customers• InnovACT• Makes recommendations to continuously improve policies, methods, procedures, and/or products• Demonstrates adaptability by reacting appropriately to unexpected changes in situations or circumstances• Increases performance through greater efficiency• Find a Way• Seeks to develop technical knowledge through learning from other experts• Understands interdepartmental impact of individual decisions and actions• Seeks solutions rather than placing blame• Empowered to be Great• Consistently looks for ways to improve one’s self through growth and development opportunities• Communicates clearly and promptly up, down, and across• Communicates effectively to manage expectationsEducation• Minimum Required:• Bachelor's Degree in Computer Science or Engineering• Preferred:• Master's Degree in Computer Science or EngineeringCertification/License:• Required: NA• Preferred: NAForeign Language• Required: NA• Preferred: NATypical Compensation RangePay Rate Type: Salary$107,143.99 - $150,001.60 / YearlyBenefitshttps://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 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.Niagara Plant NameCORP-MAIN