Niagara Bottling
BI Developer II - (Power BI & SQL)
Niagara Bottling - Diamond Bar, California, United States, 91765
Work at Niagara Bottling
Overview
- View job
Overview
At Niagara, we're looking for Team Members who want to be part of achieving our mission to provide our customers with 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 Developer II - (Power BI & SQL)
The BI Developer II will be responsible for developing scalable dashboards, data models, and analytical datasets using Power BI and Databricks SQL. This role requires strong SQL skills, a solid understanding of dimensional modeling, and the ability to translate business requirements into efficient BI solutions. The developer will work with cross-functional teams to deliver end-to-end analytics solutions, from data acquisition and modeling to reporting and visualization. Administer Power BI service, including workspace management, user access, and licensing. Design, develop, and deploy 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. Design and implement data transformation pipelines using Power Query (M), Databricks SQL, and PySpark to prepare clean, optimized data for reporting and analytics. Write and optimize SQL queries in Databricks or similar platforms to support reporting needs. Troubleshoot data and performance issues across BI Stack. 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. Document data models, workflows, and business logic for transparency and collaboration. Participate in agile development processes and coordinate with offshore teams. Please note this job description is not designed to contain a comprehensive list of activities, duties or responsibilities that are required of the team member for this job. Duties, responsibilities and activities may change at any time with or without prior notice. Qualifications
Minimum Qualifications: 3-5 years experience in delivering end-to-end BI solutions, including requirement gathering, data modeling, reports, and dashboards. 3-5 years experience in data visualization principles and user experience design for dashboards. 2-4 years experience in writing & analyzing complex SQLs, views, and Materialized views to manage large volume data for reporting and dashboarding. 2-4 years experience in Power BI development and administration within enterprise environments. 2-4 years hands-on experience in DAX, Power Query (M), and advanced data modeling in Power BI. 2-4 years experience in SQL performance tuning on platforms like Databricks, Snowflake, Oracle, or SQL Server. 0-2 years experience in Python/Scala and Spark Framework. 0-2 years exposure to ERP systems as a data source with understanding of Finance, Supply Chain, Manufacturing, Procurement processes and data elements. Preferred Qualifications: 5-7 years experience in Power BI development and administration within enterprise environments. 5-7 years experience working with data engineers on data ingestion, storage, and retrieval frameworks. 2-4 years experience in Python and Spark Framework supporting complex transformations. 2-4 years exposure to Oracle Fusion ERP cloud, OTM cloud, Manhattan, 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. 0-2 years experience in Azure DevOps for version control, CI/CD pipelines. 0-2 years experience with INCORTA. 0-2 years experience with data governance tools like MS Purview or Collibra. Competencies Strong analytical and problem-solving skills. Effective communication with technical and non-technical stakeholders. Ability to manage multiple priorities in a fast-paced environment. Attention to detail and quality in data delivery. Ownership mindset and proactive issue resolution. Additionally, the IT Developer is expected to demonstrate: Accuracy, completeness, and attention to detail. Ability to work independently and multi-task effectively. Strong problem-solving and analytical skills. Flexibility and willingness to adapt to changing priorities. Promptly notify management of issues affecting goals. Resourcefulness and innovative problem-solving skills. Professionalism, flexibility, and effective communication skills. Self-directed, organized, and motivated. Good written and verbal communication skills. Team player attitude. Education
Minimum Required:
Bachelor's Degree in Computer Science or Engineering. Preferred:
Master's Degree in Computer Science or Engineering. Certification/License
Required: N/A Preferred: PowerBI, Databricks, Azure Cloud. Compensation Range
Pay Rate: Salary $96,309.20 - $139,648.35 / Yearly Benefits
https://careers.niagarawater.com/us/en/benefits Note:
Qualified applicants with arrest or conviction records will be considered in accordance with applicable laws. Employment agency submissions are considered property of Niagara Bottling, LLC, and subject to specific policies. Niagara Plant Name:
CORP-MAIN #J-18808-Ljbffr
The BI Developer II will be responsible for developing scalable dashboards, data models, and analytical datasets using Power BI and Databricks SQL. This role requires strong SQL skills, a solid understanding of dimensional modeling, and the ability to translate business requirements into efficient BI solutions. The developer will work with cross-functional teams to deliver end-to-end analytics solutions, from data acquisition and modeling to reporting and visualization. Administer Power BI service, including workspace management, user access, and licensing. Design, develop, and deploy 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. Design and implement data transformation pipelines using Power Query (M), Databricks SQL, and PySpark to prepare clean, optimized data for reporting and analytics. Write and optimize SQL queries in Databricks or similar platforms to support reporting needs. Troubleshoot data and performance issues across BI Stack. 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. Document data models, workflows, and business logic for transparency and collaboration. Participate in agile development processes and coordinate with offshore teams. Please note this job description is not designed to contain a comprehensive list of activities, duties or responsibilities that are required of the team member for this job. Duties, responsibilities and activities may change at any time with or without prior notice. Qualifications
Minimum Qualifications: 3-5 years experience in delivering end-to-end BI solutions, including requirement gathering, data modeling, reports, and dashboards. 3-5 years experience in data visualization principles and user experience design for dashboards. 2-4 years experience in writing & analyzing complex SQLs, views, and Materialized views to manage large volume data for reporting and dashboarding. 2-4 years experience in Power BI development and administration within enterprise environments. 2-4 years hands-on experience in DAX, Power Query (M), and advanced data modeling in Power BI. 2-4 years experience in SQL performance tuning on platforms like Databricks, Snowflake, Oracle, or SQL Server. 0-2 years experience in Python/Scala and Spark Framework. 0-2 years exposure to ERP systems as a data source with understanding of Finance, Supply Chain, Manufacturing, Procurement processes and data elements. Preferred Qualifications: 5-7 years experience in Power BI development and administration within enterprise environments. 5-7 years experience working with data engineers on data ingestion, storage, and retrieval frameworks. 2-4 years experience in Python and Spark Framework supporting complex transformations. 2-4 years exposure to Oracle Fusion ERP cloud, OTM cloud, Manhattan, 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. 0-2 years experience in Azure DevOps for version control, CI/CD pipelines. 0-2 years experience with INCORTA. 0-2 years experience with data governance tools like MS Purview or Collibra. Competencies Strong analytical and problem-solving skills. Effective communication with technical and non-technical stakeholders. Ability to manage multiple priorities in a fast-paced environment. Attention to detail and quality in data delivery. Ownership mindset and proactive issue resolution. Additionally, the IT Developer is expected to demonstrate: Accuracy, completeness, and attention to detail. Ability to work independently and multi-task effectively. Strong problem-solving and analytical skills. Flexibility and willingness to adapt to changing priorities. Promptly notify management of issues affecting goals. Resourcefulness and innovative problem-solving skills. Professionalism, flexibility, and effective communication skills. Self-directed, organized, and motivated. Good written and verbal communication skills. Team player attitude. Education
Minimum Required:
Bachelor's Degree in Computer Science or Engineering. Preferred:
Master's Degree in Computer Science or Engineering. Certification/License
Required: N/A Preferred: PowerBI, Databricks, Azure Cloud. Compensation Range
Pay Rate: Salary $96,309.20 - $139,648.35 / Yearly Benefits
https://careers.niagarawater.com/us/en/benefits Note:
Qualified applicants with arrest or conviction records will be considered in accordance with applicable laws. Employment agency submissions are considered property of Niagara Bottling, LLC, and subject to specific policies. Niagara Plant Name:
CORP-MAIN #J-18808-Ljbffr