Niagara Bottling
Sr. BI Developer (Data Engineer) - INCORTA/ODI/Informatica
Niagara Bottling, Diamond Bar, California, United States, 91765
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) - INCORTA/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 warehouseCollaborate with analysts and BI developers to design and implement data models that support reporting and analytical requirementsMonitor and optimize ETL jobs for performance, reliability, and scalability, implementing best practices for data processingEnsure high levels of data quality and integrity through data validation, cleansing, and transformation processesImplement data governance best practices to maintain data accuracy and compliance with organizational standardsTroubleshoot and resolve ETL job failures and data quality issues, documenting solutions and maintaining technical documentationParticipate in business meetings to gather requirements and translate them into technical specifications for ETL/data pipelines and data modelsProvide 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 membersDesign and implement technology best practices, guidelines and repeatable processesUnderstand Data Sources and Data Modeling concepts to develop and enhance the existing Data WarehouseUnderstand normalized and star-schema physical models and logical modeling conceptsCollaborate with Oracle ERP Analyst to identify and resolve data quality issuesParticipate and handle full Software Development Life Cycle (SDLC)Coach/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 ExperienceRequired:
7-10 years - Experience Tools like INCORTA/ Azure Data Factory/ Databricks/ ODI/ Informatica5-7 years - Experience with Data Modeling, Data Mart design, Data Pipeline/ETL Architecture5-7 years - Experience in troubleshooting and resolving issues in ETL jobs and BI solutions3-5 years - Experience with Finance, Supply Chain, Manufacturing, Procurement, EAM processes and data elements3-5 years - Experience in performance tuning of ETL process, Reports/Dashboards2-4 years - Experience with cloud platforms like OCI, Microsoft Azure, Google Cloud Platform2-4 years - Experience with PL/SQL to support ETL processes2-4 years - Experience with Data Analysis using Python or R programming0-2 year(s) - Experience in Oracle Analytics Cloud Services (OACS) or PowerBI0-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/ Informatica10+ years - Experience in designing and building complex Data Pipelines7-10 years - Experience with Data Modeling, Data Mart design, ETL Architecture7-10 years - Experience in troubleshooting and resolving issues in ETL jobs and BI solutions5-7 years - Experience in understanding Finance, Supply Chain, Manufacturing, Procurement and EAM modules of an ERP application3-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 Fusion ERP cloud, OTM cloud, WMS (Manhattan)2-4 years - Experience in Oracle Hyperion/EPM2-4 years - Experience in Oracle Analytics Cloud Services (OACS) or PowerBI2-4 years - Experience in Cloud databases like Snowflake, Delta Lake, Big Query, Oracle ADW0-2 year(s) - Experience with MapViewer and geospatial analysis0-2 year(s) - Experience using Oracle Data Mining to create predictive models
CompetenciesStrong analytical and problem-solving skills with the ability to troubleshoot complex issuesExcellent communication and interpersonal skills to work with cross-functional teams and business stakeholdersAbility to manage multiple tasks and priorities in a fast-paced environmentAttention to detail and a commitment to delivering high-quality, error-free data solutionsA strong sense of ownership and accountability, promptly notifying management of any issues that affect his/her ability to accomplish planned goalsProven leadership qualitiesFosters a sense of pride within the team and encourages individuals to take pride in their accomplishmentsEducationMinimum Required:
Bachelor's Degree in Computer Science or Engineering
Preferred:
Master's Degree in Computer Science or Engineering
Certification/License:Required: None RequiredPreferred: Oracle Business Intelligence Foundation Suite 11g/12cTypical 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
Design, develop, and maintain robust ETL processes to extract, transform, and load data from various sources into our data warehouseCollaborate with analysts and BI developers to design and implement data models that support reporting and analytical requirementsMonitor and optimize ETL jobs for performance, reliability, and scalability, implementing best practices for data processingEnsure high levels of data quality and integrity through data validation, cleansing, and transformation processesImplement data governance best practices to maintain data accuracy and compliance with organizational standardsTroubleshoot and resolve ETL job failures and data quality issues, documenting solutions and maintaining technical documentationParticipate in business meetings to gather requirements and translate them into technical specifications for ETL/data pipelines and data modelsProvide 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 membersDesign and implement technology best practices, guidelines and repeatable processesUnderstand Data Sources and Data Modeling concepts to develop and enhance the existing Data WarehouseUnderstand normalized and star-schema physical models and logical modeling conceptsCollaborate with Oracle ERP Analyst to identify and resolve data quality issuesParticipate and handle full Software Development Life Cycle (SDLC)Coach/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 ExperienceRequired:
7-10 years - Experience Tools like INCORTA/ Azure Data Factory/ Databricks/ ODI/ Informatica5-7 years - Experience with Data Modeling, Data Mart design, Data Pipeline/ETL Architecture5-7 years - Experience in troubleshooting and resolving issues in ETL jobs and BI solutions3-5 years - Experience with Finance, Supply Chain, Manufacturing, Procurement, EAM processes and data elements3-5 years - Experience in performance tuning of ETL process, Reports/Dashboards2-4 years - Experience with cloud platforms like OCI, Microsoft Azure, Google Cloud Platform2-4 years - Experience with PL/SQL to support ETL processes2-4 years - Experience with Data Analysis using Python or R programming0-2 year(s) - Experience in Oracle Analytics Cloud Services (OACS) or PowerBI0-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/ Informatica10+ years - Experience in designing and building complex Data Pipelines7-10 years - Experience with Data Modeling, Data Mart design, ETL Architecture7-10 years - Experience in troubleshooting and resolving issues in ETL jobs and BI solutions5-7 years - Experience in understanding Finance, Supply Chain, Manufacturing, Procurement and EAM modules of an ERP application3-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 Fusion ERP cloud, OTM cloud, WMS (Manhattan)2-4 years - Experience in Oracle Hyperion/EPM2-4 years - Experience in Oracle Analytics Cloud Services (OACS) or PowerBI2-4 years - Experience in Cloud databases like Snowflake, Delta Lake, Big Query, Oracle ADW0-2 year(s) - Experience with MapViewer and geospatial analysis0-2 year(s) - Experience using Oracle Data Mining to create predictive models
CompetenciesStrong analytical and problem-solving skills with the ability to troubleshoot complex issuesExcellent communication and interpersonal skills to work with cross-functional teams and business stakeholdersAbility to manage multiple tasks and priorities in a fast-paced environmentAttention to detail and a commitment to delivering high-quality, error-free data solutionsA strong sense of ownership and accountability, promptly notifying management of any issues that affect his/her ability to accomplish planned goalsProven leadership qualitiesFosters a sense of pride within the team and encourages individuals to take pride in their accomplishmentsEducationMinimum Required:
Bachelor's Degree in Computer Science or Engineering
Preferred:
Master's Degree in Computer Science or Engineering
Certification/License:Required: None RequiredPreferred: Oracle Business Intelligence Foundation Suite 11g/12cTypical 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