Enterprise Data Foundation & Intelligent Automation Engineer II

Niagara Water•Diamond Bar, CA

About The Position

The Enterprise Data Foundation & Intelligent Automation Engineer II is responsible for developing, maintaining, and optimizing analytical data models, data pipelines, and automation solutions. This role contributes to strengthening the organization's data foundation, improving data maturity, and supporting data-driven decision-making across the enterprise.

Requirements

2 years of experience in technology consulting, data analytics, or related fields.
2 years of experience supporting operations or strategy functions.
Proficiency in ELT, SQL, and at least one programming language (e.g., Python, R).
Experience in developing and maintaining data warehouses and big data solutions (e.g., Snowflake, Hadoop, Spark, BigQuery).
Understanding of cloud computing services for data and analytics solutions.
Experience working with relational, NoSQL, and cloud-based databases.
Knowledge of data governance, dimensional modeling, and structured/unstructured data management.
Exposure to machine learning, artificial intelligence, and statistical methodologies.
Familiarity with agile methodologies and experience in cross-functional teams.
Strong problem-solving skills with the ability to simplify technical concepts for broader organizational understanding.
Passion for technology, innovation, and continuous learning.
Ability to foster a culture of collaboration, transparency, and trust.
Bachelor's Degree in Supply Chain/Information Technology/Business Analytics/Systems Engineering/Data Science or other related field.

Nice To Haves

4 years of experience in technology consulting, data analytics, or related fields.
4 years of experience in operations or strategy functions.
2 years of experience managing projects
Master's Degree in Supply Chain/Information Technology/Business Analytics/Systems Engineering/Data Science or other related field.
APICS CPIM/CSCP, PMP PMI certification/license.

Responsibilities

Develop and maintain high-quality data pipelines, models, and automation solutions in alignment with Analytics Modeling ELT principles.
Implement data quality frameworks and data governance best practices to ensure reliable and trusted data assets.
Solve data engineering challenges to enhance business intelligence and operational efficiency.
Build reusable data products to support product managers, data scientists, and business teams in decision-making processes.
Collaborate with data engineers, machine learning engineers, and solution architects to support scalable and optimized enterprise data solutions.
Contribute to AI-first initiatives and Robotic Process Automation (RPA) to improve efficiency across the analytics data value chain.
Partner with key stakeholders to support automation and optimization of business processes through Business Process Automation (BPA).
Research and evaluate emerging data technologies and automation tools to improve data engineering efficiency.
Promote a culture of continuous learning, innovation, and collaboration within the data engineering domain.

Benefits

Paid Time Off for holidays, sick time, and vacation time
Paid parental and caregiver leaves
Medical, including virtual care options
Dental
Vision
401(k) with company match
Health Savings Account with company match
Flexible Spending Accounts
Expanded mental wellbeing benefits including free counseling sessions for all team members and household family members
Family Building Benefits including enhanced fertility benefits for IVF and fertility preservation plus adoption, surrogacy, and Doula reimbursements
Income protection including Life and AD&D, short and long-term disability, critical illness and an accident plan
Special discount programs including pet plans, pre-paid legal services, identity theft, car rental, airport parking, etc.
Tuition reimbursement, college savings plan and scholarship opportunities