BI Lead Developer

Company: Niagara Bottling, LLC
Location: Diamond Bar
Posted on: June 1, 2025

Job Description:

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.BI Lead DeveloperAs a key member of our team, the Business Intelligence (BI) Lead Developer will be responsible for leading the design, implementation, and management of enterprise-level BI solutions. This role demands strong expertise in data architecture and governance to generate actionable insights that drive informed decision-making across the organization. The ideal candidate will establish and enforce best practices, ensuring robust data governance and high data quality standards. 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.
  • Lead the end-to-end design and implementation of scalable, enterprise-grade BI solutions, ensuring alignment with business objectives and data strategy.
  • Work with business stakeholders to gather requirements and translate them into end-to-end technical solutions.
  • Lead the design, development, and deployment of Power BI reports and dashboards with interactive and user-friendly visualizations.
  • Collaborate with Data Engineers to design and implement data models that are scalable and optimized for performance and efficiency for reporting and visualizations.
  • Optimize Databricks SQL query performance and troubleshoot slow-running reports or data processes.
  • Design and implement advanced DAX measures, calculated columns, and tables to support complex business requirements.
  • Optimize DAX queries for performance and scalability, ensuring responsive and efficient reports.
  • Administer Power BI service, including workspace management, user access, and licensing.
  • Implement and manage object and row-level data security in data solutions.
  • Audit and monitor Power BI usage, ensuring compliance with organizational policies and standards.
  • Establish and enforce data governance policies, ensuring data accuracy, security, and consistency.
  • Conduct regular data audits to identify and address issues related to data quality and integrity.
  • Maintain documentation of data models, workflows, and business logic for transparency and collaboration.
  • Ensure proper configuration management and change controls are implemented.
  • Work closely with offshore team(s) and participate in scrum calls.
  • 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 - Proven experience in delivering end-to-end BI solutions, including requirement gathering, data modeling, reports and dashboarding
      • 7-10 years - Experience in visualization principles and user experience design for dashboards
      • 7-10 years - Experience in writing & analyzing complex SQLs, views, Materialized views to manage large volume data for reporting and dashboarding
      • 5-7 years - Proven experience in Power BI development and administration within enterprise environments
      • 5-7 years - Strong expertise in DAX, Power Query (M), and advanced data modeling in Power BI
      • 5-7 years - Experience in Power BI governance and security
      • 5-7 years - Experience in working with cloud data warehouse/lake house such as Databricks or Snowflake or any other similar platform
      • 5-7 years - Hands-on experience with SQL performance tuning and optimization techniques with Databricks SQL or Snowflake or Oracle or SQL Server
      • 5-7 years - Experience working ERP system as a data source with understanding of Finance, Supply Chain, Manufacturing, Procurement processes and data elements
      • 3-5 years - Experience in using Azure DevOps for version control, CI/CD pipelines.
      • 3-5 years - Experience in Python/Scala and Spark Framework
      • 0-2 year(s) - Experience in Leading a team of BI Developers
        • Preferred:
          • 7-10 years - Strong experience in Power BI development and administration within enterprise environments
          • 7-10 years - Experience in working with data engineers in designing data ingestion, storage, and retrieval frameworks
          • 5-7 years -Python and Spark Framework to support complex transformations
          • 3-5 years - Experience in understanding Oracle Fusion ERP cloud, OTM cloud, WMS (Manhattan)
          • 2-4 years - Experience in Oracle Hyperion/EPM
          • 2-4 years - Experience in Cloud databases like Delta Lake, Big Query, Oracle ADW
          • 2-4 years - Experience with Databricks Delta Lake, Spark jobs, Workflows
          • 2-4 years - Experience in Leading a team of BI Developers
          • 0-2 year(s) - Experience with INCORTA
          • 0-2 year(s) - Experience with data governance tools like MS Purview or CollibraCompetencies
            • 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 accomplishmentsEducation
              • Minimum Required:
                • Bachelor's Degree in Computer Science or Engineering
                  • Preferred:
                    • Master's Degree in Computer Science or EngineeringCertification/License:
                      • Required: None Required
                      • Preferred: PowerBI, Databricks, Azure Cloud Typical Compensation RangePay Rate Type: Salary$107,143.99 - $150,001.60 / YearlyBenefitshttps://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

Keywords: Niagara Bottling, LLC, San Clemente , BI Lead Developer, IT / Software / Systems , Diamond Bar, California