Sr. BI Developer

$107,144 - $150,002/Yr

Niagara Bottling - Diamond Bar, CA

Full-time - Mid Level

Diamond Bar, CA

Beverage and Tobacco Product Manufacturing

About the position

The Sr. BI Developer at Niagara Bottling is a key role responsible for the design, development, implementation, and support of critical Business Intelligence reports and dashboards. This position involves collaborating with cross-functional teams to gather reporting requirements and translating them into technical specifications. The BI Developer will utilize their expertise to create ETL processes, reports, and dashboards, ensuring data quality and performance while adhering to best practices in Business Intelligence.

Responsibilities

• Participate in business meetings to gather reporting and dashboard requirements.
• Translate business requirements into specifications for reports and dashboards.
• Transition developed reports and dashboards to the Operations & Support team.
• Provide support to ensure the availability and performance of reports and dashboards.
• Implement proper configuration management and change controls.
• Work closely with offshore teams and participate in scrum calls.
• Provide technical assistance and cross-training to team members.
• Design and implement technology best practices and repeatable processes.
• Understand data sources and data modeling concepts to enhance the existing Data Warehouse.
• Collaborate with Oracle ERP Analyst to resolve data quality issues.
• Handle the full Software Development Life Cycle (SDLC).
• Provide guidance on best practices for reporting solutions.
• Coach and mentor team members for their professional development.

Requirements

• 7-10 years of experience in OBIEE, BI Apps, OTBI, ODI, Informatica.
• 7-10 years of experience building complex reports/dashboards.
• 5-7 years of experience with OBIEE repository (RPD) for all layers.
• 5-7 years of experience with Data Modeling, Data Mart design, ETL Architecture.
• 5-7 years of experience with ODI Mappings, Interfaces, Packages, Knowledge modules.
• 5-7 years of experience with Finance, Supply Chain, Manufacturing, Procurement, EAM modules in BI Apps.
• 5-7 years of experience implementing security in OBIEE.
• 2-4 years of experience in performance tuning of ETL processes, reports/dashboards.
• 2-4 years of experience with PL/SQL to support ETL processes.
• 2-4 years of experience with Java programming.

Nice-to-haves

• 10+ years of experience in OBIEE, BI Apps, OTBI, ODI, Informatica.
• 10+ years of experience building complex reports/dashboards.
• 7-10 years of experience with OBIEE repository (RPD) for all layers.
• 7-10 years of experience with Data Modeling, Data Mart design, ETL Architecture.
• 5-7 years of experience with ODI Mappings, Interfaces, Packages, Knowledge modules.
• 5-7 years of experience with Finance, Supply Chain, Manufacturing, Procurement, EAM modules in BI Apps.
• 5-7 years of experience implementing security in OBIEE.
• 3-5 years of experience in performance tuning of ETL processes, reports/dashboards.
• 3-5 years of experience with PL/SQL to support ETL processes.
• 3-5 years of experience with Java programming.

Benefits

• Competitive compensation and benefits packages.
• Educational reimbursements.
• Ongoing training courses.
• Career advancement opportunities.