BI Developer

Job description

·        Knowledge on GenAI solutions and Oracle Digital assistant will be a plus

·      Experience of Oracle Business Intelligence integrated with Hyperion Essbase and relational database (OAS, Essbase 11.x, 21c)

·        Experience in developing and supporting OAS repository model, reports and dashboards

·        Hands-on technical expertise with ETL & ELT technologies (Admin & Developer), Oracle BI Application (OBIA), OAS reporting (Admin & Developer), data modelling techniques as well as solid knowledge of Data Warehousing concepts.

·        Effective management of Support tickets with hand offs/exchanges with peers on team working in global time zones.

·        Develops rules and methodologies for data collection and analysis

·        Consolidates data from a broad spectrum of information systems and existing data repositories using Oracle Business Intelligence Tool

·        Development experience with physical and logical data models

·        Provide application analysis and data modeling design to collect data for centralized data warehouse.

·        Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems.

·        Proficient in the use of query and reporting analysis tools.

·        Standardize data collection by developing methods for database design and validation reports.

·        Critical Business operations and interactions during business hours catering to Sales Operations, Finance and Sourcing Business teams

·        Requires comprehensive knowledge of the principles, practices, and procedures used in all phases of full life cycle applications and systems development, engineering, programming, and analysis 

·        Knowledge of and experience with Oracle Business Intelligence tools, techniques and processes for complex data gathering, analysis and reporting on data for large organizations. 

·        Ability to analyze data, resolve issues using simple to complex SQL and understanding of end to end data flow from source to databases and reporting. 

·        Experience writing, testing and implementing complex SQL & PL/SQL & Unix scripts

·        Experience gathering end user requirements and translating into technical specification