Oracle Business Intelligence Developer – ETL, OBIA
They are committed to deploying cutting edge solutions to deliver business objectives and want to add to their team an Oracle Business Intelligence Developer to be the owner for the OBIA Oracle BI Stack. You’ll be reporting to the Technology & Solutions Manager this is initially a 2 year fixed term engagement.
Responsibilities will include:
- The internal owner for the OBIA Oracle BI Stack, with responsibility for Administration, monitoring and maintaining the applications.
- Supporting the BICC Manager in providing technical and process direction and support for the technical team of ETL (ODI) and BI (OBIEE / OBIA) developers in all phases of the delivery process: requirements / scoping, prototyping / design, development, testing, release and support.
- Co-ordinate with internal and external service providers and projects teams to ensure that current and future BI IT requirements are satisfied.
- Participate in the development of project plans to implement data warehouse solution and identify resource requirements.
- Provide OBIA Application support and administration
- Functional and Technical Design reviews
- ODI monitoring, configuring, Maintaining, Deployment .ODI, OBIA Technical support and hands on development as required.
- Work with source system owners to automate deliver information to the landing area.
- Be the “hands-on, end-to-end” expert in all layers of the OBIEE / OBIA / ODI stack with a proven track record of successful delivery in complex environments.
- Identify, recommend and best practices on ETL / OBIEE / OBIA architecture and repository development.
- Support and guide the cast of teammates performing ancillary roles within the BI teams.
- Lead future in-house system analysis, ETL design and development and system testing to create an integrated data warehouse based on custom and Oracle BI Applications mappings and reports.
- Maintain high level of proficiency in appropriate modern technologies.
- Work in such a manner to develop and promote a progressive, professional and positive working environment within the applications team.
- Working within the Application team to ensure appropriate process are implemented, in place and updated if required.
- Liaise with Operations, and application team to support each business unit to establish, track and monitor business requirements. Communicate effectively with business customers, line manager and peers
- Proactively participate in the Performance Management process to ensure delivery of own, and the wider teams, objectives.
Ideally you will possess the following qualification, skills, knowledge and attributes:
- Experience of working within a technology development environment, preferably with an emphasis on utilities and Oracle BI applications
- Proven ODI ETL development in a data warehousing environment
- Proven OBIEE / OBIA architecture and repository and report developments using best practices
- Experience maintaining / modifying existing ETL code (not just new development)
- Ability to understand business requirements and develop software solutions
- Strong experience with data warehousing and ETL tools and with the SDLC and BI tools mainly with OBIEE / OBIA
- Must have experience with STAR ( SNOWFLAKE) schema techniques and experience performing user acceptance testing for applications
- Strong data analysis skills and ability to present the findings to business users
- Strong documentation skills and experience using OBIEE / OBIA as a report writing tool
- Proficiency in verbal and written communications (including presentation skills) and interpersonal skills
- Negotiation skills and ability to prepare proper documentation and building of a knowledge base
- Confident and comfortable interacting with people in various disciplines and at various levels of an organization
- Ability to think outside the box and come up with new/innovative ways of doing things when the opportunity presents itself
- Bachelor’s degree and/or college equivalent (preferred engineering, computer science or business degrees)
- SOA skills would be an advantage.