Lead Data Pipeline Engineer - (Snowflake: Snowpipe, Streams, Tasks, Time Travel)

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.

• Design, develop, and maintain robust ETL processes to extract, transform, and load data from various sources into Snowflake
• Optimize data storage and retrieval mechanisms for performance and scalability
• Configure and manage Snowflake data infrastructure components
• 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
• Ensure proper configuration management and change controls are implemented
• Work closely with offshore team(s) and participate in scrum calls
• 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 in Snowflake
  • 7-10 years - Experience in designing and building complex Data Pipelines
  • 7-10 years - Experience with cloud platforms like Microsoft Azure or Google Cloud Platform
  • 7-10 years - Experience Tools like Databricks/Azure Data Factory
  • 7-10 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 in performance tuning of ETL process, Reports/Dashboards
  • 2-4 years - Experience with PL/SQL to support ETL processes
  • 2-4 years - Experience with Data Analysis using Python or R programming
  • 2 year(s) - Experience in Oracle Analytics Cloud Services (OACS) or PowerBI

• Preferred:
  • 10+ years experience in Snowflake
  • 10+ years - Experience in designing and building complex Data Pipelines
  • 10+ years - Experience with cloud platforms like Microsoft Azure or Google Cloud Platform
  • 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
  • 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 with tools like Databricks/Azure Data Factory
  • 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

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 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.