Sr Data Engineer - ETL/ELT

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 - ETL/ELT

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 data modelling to support 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, build, and maintain robust ETL/ELT pipelines using Incorta and Databricks (PySpark, SQL, Delta Lake).

• Develop and optimize Spark transformations for processing large-scale datasets.

• Enhance Databricks SQL performance by troubleshooting and tuning slow-running queries and reports.

• Optimize data storage, partitioning, and retrieval for scalability and performance using Z-Ordering, OPTIMIZE, Auto Compaction, and file size tuning.

• Configure and manage Databricks infrastructure components, including Serverless SQL Warehouses and Interactive Clusters.

• Collaborate with BI developers and analysts to design and implement data models supporting reporting and analytical nee

• Maintain data quality and integrity through validation, cleansing, and transformation routines.

• Enforce data governance, access controls, and compliance standards using Unity Catalog.

• Ensure proper configuration management and change control processes are followed.

• Partner with offshore teams and actively participate in scrum calls for coordinated delivery.

• Work closely with Oracle ERP analysts to identify and resolve data quality or integration issues.

• Participate in and manage activities across the entire Software Development Life Cycle (SDLC).

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

Qualifications

• Minimum Qualifications:
  • 7-10 years  – Proven experience in data engineering or enterprise data platform development, including the design and implementation of complex data pipelines and integration frameworks
  • 7-10 years  – Strong expertise in advanced SQL development, including complex transformations, query tuning, and performance optimization across large datasets.
  • 7-10 years  – Experience in troubleshooting and resolving ETL/ELT failures, performance bottlenecks, and end-to-end BI solution issues.
  • 7-10 years  – Expertise in data modeling, dimensional modeling (Star/Snowflake), data mart design, and semantic layer development to support enterprise BI and analytics.
  • 5-7 years  – Hands-on experience in PySpark, Spark SQL, and Databricks SQL, building scalable data transformations and lakehouse solutions.
  • 5-7 years  – Proven ability to process and optimize large-scale datasets (terabytes to petabytes) with a focus on partitioning, Z-ordering, and data compaction.
  • 5-7 years  – Experience with cloud platforms like Microsoft Azure, Google Cloud and OCI Platform
  • 5-7 years  – Experience with Finance, Supply Chain, Manufacturing, Procurement, EAM processes and data elements
  • 3-5 years  – Hands-on experience implementing data quality frameworks, schema evolution handling, and data validation controls in Databricks or similar ecosystems.
  • 3-5 years  – Hands-on experience with Azure Databricks, including cluster management, workflows, and SQL performance tuning.
  • 0-2 year(s)  – Experience in Oracle Analytics Cloud Services (OACS) or PowerBI

                *experience may include a combination of work experience and education

• Preferred Qualifications:
  • 10+ years  – Proven experience in data engineering or enterprise data platform development, including the design and implementation of complex data pipelines and integration frameworks
  • 10+ years  – Strong expertise in advanced SQL development, including complex transformations, query tuning, and performance optimization across large datasets
  • 10+ years  – Expertise in data modeling, dimensional modeling (Star/Snowflake), data mart design, and semantic layer development to support enterprise BI and analytics.
  • 10+ years  – Experience in troubleshooting and resolving issues in ETL jobs and BI solutions
  • 7-10 years  – Experience in understanding Finance, Supply Chain, Manufacturing, Procurement and EAM modules of an ERP application
  • 5-7 years  – Experience in understanding Fusion ERP cloud, OTM cloud, WMS (Manhattan)
  • 2-4 years  – Experience with Incorta
  • 2-4 years  – Experience in Oracle Hyperion/EPM
  • 2-4 years  – Experience in Oracle Analytics Cloud Services (OACS) or PowerBI

*experience may include a combination of work experience and education

Additionally, the Sr. IT Developer is expected to demonstrate:

• 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

Education

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

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

Certification/License:

• Required:  NA      
• Preferred: Databricks, Azure Cloud

Typical Compensation Range

Pay Rate Type: Salary

$111,766.36 - $159,267.07 / 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.