AI & BI Engineer II

Enterprise AI & BI Engineer II

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.

Essential functions:

• Design, build, and maintain business intelligence dashboards, reports, and data visualizations aligned with business requirements
• Develop and manage curated datasets, semantic layers, and data marts to support consistent and scalable analytics
• Translate business requirements into well-structured analytics solutions with clear logic and performance considerations
• Optimize BI solutions for usability, performance, and scalability
• Design and implement analytics data models using dimensional modeling and ELT best practices
• Build and maintain data transformations and pipelines that support reporting and analytics use cases
• Partner with data engineering teams to ensure high-quality, reliable data pipelines for analytics consumption
• Ensure consistency of business logic, metrics, and definitions across analytics assets
• Develop and support AI-assisted analytics capabilities such as predictive models, automated insights, and natural language data interactions
• Apply basic machine learning techniques or integrate pre-built models into analytics workflows
• Support automation of reporting, data validation, and insight generation processes
• Collaborate with data science teams to operationalize model outputs into dashboards and business workflows
• Apply data quality validation, testing, and monitoring practices to ensure reliable analytics outputs
• Support implementation of data governance standards, including documentation, metadata, and metric definitions
• Contribute to the development of reusable data assets and standardized reporting frameworks
• Collaborate with business stakeholders to gather requirements and deliver analytics solutions that meet business needs
• Participate actively in agile delivery processes including sprint planning, backlog grooming, and demos
• Work cross-functionally with data engineers, analysts, and AI teams to deliver integrated solutions
• Continuously improve technical skills in BI tools, data engineering, and applied AI/ML
• Identify opportunities to improve existing analytics solutions through automation, optimization, or AI enhancements
• Begin contributing to team best practices and knowledge sharing

Qualifications:

• Minimum qualifications:
• 3 - 5 years of experience in business intelligence, data analytics, AI, or related fields (internships or academic experience included)
• Strong understanding of designing enterprise analytics data models, semantic layers, or BI platforms.
• *experience may include a combination of work experience and education
• Preferred qualifications:
• 5 - 7 years of experience in business intelligence, data analytics, AI, or related fields (internships or academic experience included)
• Strong skillset in data modeling concepts (e.g., star schema, dimensional modeling)
• Strong familiarity with Python, R, or other programming languages
• Strong exposure to AI/ML concepts or tools (e.g., basic modeling, notebooks, or AI-assisted tools)
• Familiarity with cloud data platforms or modern data tools
• *experience may include a combination of work experience and education

Competencies:

• Strong experience building scalable dashboards and reports
• Understanding of data visualization best practices and user experience
• Ability to independently deliver analytics solutions from requirements to deployment
• Solid understanding of data pipelines, transformations, and data warehousing concepts
• Experience implementing ELT patterns and optimizing data models
• Understanding of performance tuning and data optimization
• Basic hands-on experience with AI/ML integration or predictive analytics
• Understanding of how to operationalize model outputs into business workflows
• Familiarity with AI-assisted analytics tools and automation
• Strong problem-solving and analytical thinking
• Ability to work independently with minimal supervision
• Effective communication with both technical and business stakeholders
• Strong attention to detail and commitment to data quality

This position embodies the values of Niagara's LIFE competency model, focusing on the following key drivers of success:

• Lead Like an Owner
• Provides strategic input and oversight to departmental projects
• Skilled in reducing costs and managing timelines while prioritizing long run impact
• Leads/facilitates discussions to get positive outcomes for the customer
• Makes strategic and sustainable data driven decisions which prioritize the needs of the customer over departmental/individual goals
• InnovACT
• Continuously evaluates existing programs and processes, and develops new initiatives to increase efficiency and reduce waste
• Creates, monitors, and responds to departmental performance metrics to drive continuous improvement
• Communicates a clear vision, organizes resources effectively, and adjusts the strategy as needed when managing change
• Find a Way
• Demonstrates ability to think analytically and synthesize complex information
• Effectively delegates technical tasks to subordinates
• Works effectively with depts, vendors, and customers to achieve organizational success
• Identifies opportunities for collaboration in strategic ways
• Empowered to be Great
• Engages in long term talent planning
• Provides opportunities for the development of all direct reports
• Understands, identifies, and addresses conflict within own team and between teams

Education:

• Minimum required:
  • Bachelor's degree in Information Technology/Business Analytics/Systems Engineering/Data Science or other related field
• Preferred:
  • Master's degree in Information Technology/Business Analytics/Systems Engineering/Data Science or other related field

Certification/License:

• Required: N/A
• Preferred: Power BI, Tableau, or enterprise BI platform certifications, Cloud Data Platform certifications (AWS, Azure, GCP, Snowflake, Databricks), AI / Machine Learning or Advanced Analytics certifications.

Typical compensation range:

Pay rate type: Salary $100,464.14 - $145,673.02 / Yearly

Benefits:

Our total rewards package is thoughtfully designed to support both you and your family:

• 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
• And more!