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 *
1. Collaborate with cross-functional teams and analysts to gather and understand business requirements, ensuring alignment between the business and BICC.
2. 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.
3. 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.
4. 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.
5. 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.
6. 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.
7. 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 ensure data security and compliance.
- Data Modeling & Reporting: Building and maintaining data models from diverse sources, creating visually appealing dashboards, and publishing reports.
- Continuous Improvement: Engaging in self-education, training, and continuous learning to improve BI, data analysis, and SQL skills.
The Hillman Group is an Equal Employment Opportunity and Affirmative Action Employer and will not discriminate against an applicant or employee on the basis of race, color, religion, creed, national origin or ancestry, sex, age, physical or mental disability, protected veteran or military status, genetic information, citizenship status, sexual orientation, gender identity, marital status, or any other legally recognized protected basis under federal, state or local laws, regulations or ordinances. The information collected by this application is solely to determine suitability for employment, verify identity and maintain employment statistics on applicants.
