Monitor and optimize BI platform performance and ensure data quality across all reporting environments.
Collaborate with BI Architects to design logical and physical analytical data models for both transactional and analytical databases, based on data requirements gathered from the business.
Partner with business Data Stewards and IT Developers to implement and maintain data governance across systems and processes.
Create and maintain data dictionaries and data lineage documentation, resolving data anomalies (data quality issues and ambiguous data definitions), and establishing data integrity checks and controls.
Develop, monitor, and maintain efficient ETL processes to ensure timely and accurate data delivery; troubleshoot and resolve issues related to source system extracts, data mapping and loading.
Assists business subject matter experts (SMEs) in self-service reports and meaningful analytics.
Manage and execute production change requests related to Business Intelligence and Reporting platforms, ensuring proper documentation and minimal disruption.
Stay current with industry trends and emerging technologies to inform BI strategy and platform enhancements.
Participate in BI platform upgrades, migrations, and performance tuning initiatives to ensure scalability and reliability.
Minimum Qualifications
Bachelor’s degree in computer science, Information Technology, or a related field.
Minimum 7 years of experience in Information Technology, with a focus on Business Intelligence development.
At least 3 years of hands-on experience with Oracle Business Intelligence Applications (OBIA) in an Oracle E-Business Suite (EBS) environment.
Minimum 2 years of experience developing reports and dashboards using Microsoft Power BI or a comparable enterprise BI platform.
Minimum 3 years of experience with Oracle Data Integrator (ODI), including building and maintaining data integration processes.
Minimum 3 years of experience working with Oracle Analytics Server (OAS).
Proven experience in logical and physical data modeling for data warehouses and data marts.
Strong troubleshooting skills and experience resolving complex issues within ODI and related BI tools.
Demonstrated experience in Sales and Finance reporting, including the development of cubes, dashboards, and KPIs for these business domains.
Proficiency in SQL, PL/SQL, and scripting languages used in ETL development and maintenance.
Familiarity with IT systems and business processes in a manufacturing environment.
Excellent written and verbal communication skills, with the ability to interact effectively with business leaders and subject matter experts.
Good working knowing knowledge and experience in a Unix or Linux environment.
Preferred Education and Experience
Experience with Oracle E-Business Suite Financials and Supply Chain
Demonstrated ability to collaborate with business partners to analyze external data sources (e.g., Point-of-Sale, market data) for insights into product category performance and positioning.
Experience with Oracle Planning and Budgeting Cloud Services (PBCS), Hyperion Planning, and Essbase.
Strong database knowledge, Oracle, SQL Database
Familiarity with AI tools for BI analytics
