Business Intelligence Competency Center; BICC Developer

Position: Business Intelligence Competency Center (BICC) Developer I
Job Summary

The Business Intelligence Competency Center (BICC) Developer I is a key member of the Business Intelligence Competency Center (BICC), responsible for ensuring the effective use of business intelligence (BI) tools and practices across the organization. Reporting to the BICC Manager, this role will assist in implementing BI strategies, standards, and procedures to deliver maximum value to the business. The position involves designing and developing data models and infrastructure in various BI platforms (e.g., Power BI, Oracle Transactional Business Intelligence (OTBI), Oracle BI Publisher), building and maintaining Extract, Transform, Load (ETL) processes using Power Query, Structured Query Language (SQL), and other ETL tools, and developing and maintaining BI applications and tools to ensure regular reporting.

The developer will gather reporting and analytical requirements from stakeholders, maintain standardizations in BI platforms, and work in a sprint agile environment. Additionally, the role focuses on ensuring data security and compliance, troubleshooting and resolving technical issues, and engaging with stakeholders to deliver comprehensive dataset solutions and analytical dashboards through various BI tools including Power BI, Oracle Fusion, OTBI, Essbase, Oracle BI Publisher, and Microsoft Fabric.

Essential Job Functions
* Collaborate with cross-functional teams and analysts to gather and understand business requirements, ensuring alignment between the business and BICC.
Develop and deliver enterprise and ad hoc Business Intelligence solutions, utilizing SQL, Server Views, Power Query, Power BI, Excel, and other approved tools to extract, transform, and load (ETL) data and drive business success.
Design and develop data models and datasets from diverse sources such as APIs, SQL, Microsoft Excel, SharePoint, ERPs, Data Warehouses, Oracle Fusion, CRMs, WM, and PKMS, requiring a complex knowledge of each system and ability to work with IT and stakeholders to extract appropriate data for KPIs and reporting needs.
Support the BICC Manager in maintaining the governance structure for BI and analytical programs, projects, practices, software, and architecture through following best practices and industry guidelines and through the development of critical reporting used for leadership KPIs and critical decision making.
Maintain data governance standardizations in business intelligence platforms while working in a sprint agile environment, ensuring that security and Data Governance best practices are applied.
Ensure daily runs, scheduling, and upkeep of reporting datasets in various Business Intelligence platforms, including Power BI, Oracle, and any other business intelligence platform required by the organization.
Engage with stakeholders to ensure comprehensive dataset solutions and effective communication, leveraging BI tools such as Power BI, Oracle Fusion, OTBI, Essbase, and Microsoft Fabric to deliver analytical dashboards and Business Intelligence solutions.

* This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Duties, responsibilities and activities may change, or new ones may be assigned at any time with or without notice.

Employees are expected and encouraged to participate in safety and health program activities including immediately reporting hazards, immediately reporting unsafe work practices and incidents to supervisors, wearing required personal protective equipment, and participating in and supporting safety committee activities.

Education & Experience

Education:

A bachelor's degree in computer science, information technology, business analytics, or a related field. Alternatively, a combination of related education and equivalent work experience may be considered.

Experience:

A minimum of 2-4 years of professional experience in business intelligence, analytics, or a related field.
Practical experience with BI tools and environments, including SQL, Power Query, Power BI, Oracle Transactional Business Intelligence (OTBI), and other relevant platforms.

Certifications:

Relevant certifications such as Microsoft Certified:
Data Analyst Associate, Certified Business Intelligence Professional (CBIP), or other recognized BI certifications are highly desirable.

Competencies - Knowledge, Skills, and Abilities

Knowledge, Skills, and Abilities

Data Analysis & Management:
Proficiency in Oracle Products, Microsoft Power BI, MS SQL scripting, DAX, and data models.
ETL Processes:
Strong understanding and ability to build and maintain ETL processes using SQL, Power Query, and other tools.
Data Validation & Governance:
Ensuring accuracy and reliability of data, following standards and guidelines for data governance.
Stakeholder

Collaboration:

Working with stakeholders to drive success, implement feedback, and develop BI solutions.
Data Security & Compliance:
Collaborating with IT to create solutions for data issues and…