Sr. BI Developer (Data Engineer) - ODI/Informatica - Niagara Bottling

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 Developer (Data Engineer) - ODI/Informatica

As a key member of our team, the Senior Business Intelligence (BI) Developer will be responsible for designing, developing, implementing, and supporting essential enterprise Business Intelligence solutions. The ideal candidate will possess a strong background in data integration, ETL processes, and business intelligence to deliver scalable and efficient data solutions. This role involves collaborating with cross-functional teams to gather requirements and leveraging skills and experience to create end-to-end solutions, from data acquisition and modeling to reporting and visualization. The candidate will continuously assess and adopt new technologies, methodologies and practices to enhance data processing capabilities. This position is crucial in ensuring high-quality data operations and providing valuable insights to support the organization’s decision-making processes.

• Design, develop, and maintain robust ETL processes to extract, transform, and load data from various sources into our data warehouse
• Collaborate with analysts and BI developers to design and implement data models that support reporting and analytical requirements
• Monitor and optimize ETL jobs for performance, reliability, and scalability, implementing best practices for data processing
• Ensure high levels of data quality and integrity through data validation, cleansing, and transformation processes
• Implement data governance best practices to maintain data accuracy and compliance with organizational standards
• Troubleshoot and resolve ETL job failures and data quality issues, documenting solutions and maintaining technical documentation
• Participate in business meetings to gather requirements and translate them into technical specifications for ETL/data pipelines and data models
• 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

• Design and implement technology best practices, guidelines and repeatable processes

• Understand Data Sources and Data Modeling concepts to develop and enhance the existing Data Warehouse
• Understand normalized and star-schema physical models and logical modeling concepts
• Collaborate with Oracle ERP Analyst to identify and resolve data quality issues
• Participate and handle full Software Development Life Cycle (SDLC)
• 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 notice

Work Experience

• Required:
  • 7-10 years  – Experience Tools like INCORTA/ Azure Data Factory/ Databricks/ ODI/ Informatica
  • 5-7 years  – Experience with Data Modeling, Data Mart design, Data Pipeline/ETL Architecture
  • 5-7 years  – Experience in troubleshooting and resolving issues in ETL jobs and BI solutions
  • 3-5 years  – Experience with Finance, Supply Chain, Manufacturing, Procurement, EAM processes and data elements
  • 3-5 years  – Experience in performance tuning of ETL process, Reports/Dashboards
  • 2-4 years  – Experience with cloud platforms like OCI, Microsoft Azure, Google Cloud Platform
  • 2-4 years  – Experience with PL/SQL to support ETL processes
  • 2-4 years  – Experience with Data Analysis using Python or R programming
  • 0-2 year(s)  – Experience in Oracle Analytics Cloud Services (OACS) or PowerBI
  • 0-2 year(s)  – Experience in Cloud databases like Snowflake, Delta Lake, Big Query, Oracle ADW

• Preferred:
  • 10+ years  – Experience with tools like INCORTA/ Azure Data Factory/ Databricks/ ODI/ Informatica
  • 10+ years  – Experience in designing and building complex Data Pipelines
  • 7-10 years  – Experience with Data Modeling, Data Mart design, ETL Architecture
  • 7-10 years  – Experience in troubleshooting and resolving issues in ETL jobs and BI solutions
  • 5-7 years  – Experience in understanding Finance, Supply Chain, Manufacturing, Procurement and EAM modules of an ERP application
  • 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 Fusion ERP cloud, OTM cloud, WMS (Manhattan)
  • 2-4 years  – Experience in Oracle Hyperion/EPM
  • 2-4 years  – Experience in Oracle Analytics Cloud Services (OACS) or PowerBI
  • 2-4 years  – Experience in Cloud databases like Snowflake, Delta Lake, Big Query, Oracle ADW
  • 0-2 year(s)  – Experience with MapViewer and geospatial analysis
  • 0-2 year(s)  – Experience using Oracle Data Mining to create predictive models

Competencies

• Strong analytical and problem-solving skills with the ability to troubleshoot complex issues
• Excellent communication and interpersonal skills to work with cross-functional teams and business stakeholders
• Ability to manage multiple tasks and priorities in a fast-paced environment
• Attention to detail and a commitment to delivering high-quality, error-free data solutions
• A strong sense of ownership and accountability, promptly notifying management of any issues that affect his/her ability to accomplish planned goals
• Proven leadership qualities
• Fosters a sense of pride within the team and encourages individuals to take pride in their accomplishments

Education

• Minimum Required: 
  • Bachelor's Degree in Computer Science or Engineering

• Preferred: 
  • Master's Degree in Computer Science or Engineering

Certification/License:

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

Typical Compensation Range

$107,143.99 - $150,001.60 / Yearly

Benefits

https://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.