> Markdown version of [/jobs/ext/505962-business-intelligence-competency-center-bicc-developer-i](https://www.wearedevelopers.com/jobs/ext/505962-business-intelligence-competency-center-bicc-developer-i). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Business Intelligence Competency Center (BICC) Developer I

- **Company:** The Hillman Group, Inc.
- **Location:** Cincinnati, OH, United States
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Microsoft Excel, Application Programming Interfaces (APIs), Data Analysis, Data Validation, Data Governance, Extract Transform Load (ETL), Data Security, Data Warehousing, Oracle Essbase, Microsoft SQL Server, Oracle (Applications), Power BI, Standard Sql, Microsoft SharePoint, SQL Databases, Oracle Fusion Middleware, Scripting, Bi Publisher, Powerquery, Microsoft Fabric, Information Technology, PkMS
- **Published:** June 11, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=4727af6ed23e235b

## About the Role

Do you have experience in Stakeholder management?, Do you have a Bachelor's degree?, * 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., * 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.

## Description

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.


## Related Videos

- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [JavaScript? No. Java Scripts! - Scripting with Java](https://www.wearedevelopers.com/videos/2094-javascript-no-java-scripts-scripting-with-java)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [From Global Capability Centers to AI-Powered Command Centers](https://www.wearedevelopers.com/videos/100096-from-global-capability-centers-to-ai-powered-command-centers)

## Related Articles

- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know)