Niagara Bottling · 2 months ago
Sr BI Developer - Data Engineering ETL
Corp-Main - Diamond Bar, CA
Full-time
Onsite
Senior Level
$112K/yr - $159K/yr
7+ years expNiagara Bottling is seeking a Senior Business Intelligence (BI) Developer to join their team. This role is responsible for designing, developing, implementing, and supporting enterprise Business Intelligence solutions, focusing on data integration and ETL processes to enhance data processing capabilities.
Food and BeverageSports
Responsibilities
Design, build, and maintain robust ETL/ELT pipelines using Incorta and Databricks (PySpark, SQL, Delta Lake)
Develop and optimize Spark transformations for processing large-scale datasets
Enhance Databricks SQL performance by troubleshooting and tuning slow-running queries and reports
Optimize data storage, partitioning, and retrieval for scalability and performance using Z-Ordering, OPTIMIZE, Auto Compaction, and file size tuning
Configure and manage Databricks infrastructure components, including Serverless SQL Warehouses and Interactive Clusters
Collaborate with BI developers and analysts to design and implement data models supporting reporting and analytical needs
Maintain data quality and integrity through validation, cleansing, and transformation routines
Enforce data governance, access controls, and compliance standards using Unity Catalog
Ensure proper configuration management and change control processes are followed
Partner with offshore teams and actively participate in scrum calls for coordinated delivery
Work closely with Oracle ERP analysts to identify and resolve data quality or integration issues
Participate in and manage activities across the entire Software Development Life Cycle (SDLC)
Qualification
Required
7-10 years – Proven experience in data engineering or enterprise data platform development, including the design and implementation of complex data pipelines and integration frameworks
7-10 years – Strong expertise in advanced SQL development, including complex transformations, query tuning, and performance optimization across large datasets
7-10 years – Experience in troubleshooting and resolving ETL/ELT failures, performance bottlenecks, and end-to-end BI solution issues
7-10 years – Expertise in data modeling, dimensional modeling (Star/Snowflake), data mart design, and semantic layer development to support enterprise BI and analytics
5-7 years – Hands-on experience in PySpark, Spark SQL, and Databricks SQL, building scalable data transformations and lakehouse solutions
5-7 years – Proven ability to process and optimize large-scale datasets (terabytes to petabytes) with a focus on partitioning, Z-ordering, and data compaction
5-7 years – Experience with cloud platforms like Microsoft Azure, Google Cloud and OCI Platform
5-7 years – Experience with Finance, Supply Chain, Manufacturing, Procurement, EAM processes and data elements
3-5 years – Hands-on experience implementing data quality frameworks, schema evolution handling, and data validation controls in Databricks or similar ecosystems
3-5 years – Hands-on experience with Azure Databricks, including cluster management, workflows, and SQL performance tuning
0-2 year(s) – Experience in Oracle Analytics Cloud Services (OACS) or PowerBI
Bachelor's Degree in Computer Science or Engineering
Preferred
10+ years – Proven experience in data engineering or enterprise data platform development, including the design and implementation of complex data pipelines and integration frameworks
10+ years – Strong expertise in advanced SQL development, including complex transformations, query tuning, and performance optimization across large datasets
10+ years – Expertise in data modeling, dimensional modeling (Star/Snowflake), data mart design, and semantic layer development to support enterprise BI and analytics
10+ years – Experience in troubleshooting and resolving issues in ETL jobs and BI solutions
7-10 years – Experience in understanding Finance, Supply Chain, Manufacturing, Procurement and EAM modules of an ERP application
5-7 years – Experience in understanding Fusion ERP cloud, OTM cloud, WMS (Manhattan)
2-4 years – Experience with Incorta
2-4 years – Experience in Oracle Hyperion/EPM
2-4 years – Experience in Oracle Analytics Cloud Services (OACS) or PowerBI
Master's Degree in Computer Science or Engineering
Databricks, Azure Cloud
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
And more!
Company
Niagara Bottling
Niagara Bottling provides bottled water and bottled sports drinks.
5001-10000 employees
H1B Sponsorship
Niagara Bottling has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (85)
2024 (88)
2023 (115)
2022 (64)
2021 (80)
2020 (81)
Funding
Current Stage
Late StageLeadership Team
Abigail Kimball
Senior Talent Acquisition Partner
Afif Saade
Senior TA Partner
Recent News
Hartford Business Journal
2025-12-04
Company data provided by crunchbase