BI Developer Analyst

Job content

Role Purpose:

• Accountable for the support of ETL & ELT technologies, Oracle BI Applications (OBIA), OBIEE integrated with Hyperion Essbase and datawarehouse, big data and related reporting applications used by Experian.
• To ensure system availability by proactive system support and speedy resolution of application errors.
• Assist users to understand and leverage the capabilities of the data warehouse(s).
• Provide knowledge of data and data warehouse design in support of projects and enhancements.

Functional Responsibilities

• Manage the administration, maintenance, and continued development of Oracle BI Applications suite (OBIA) regionally and globally.
• Ensure system stability and functionality.
• Responsible for understanding the global business processes associated with Sales Analysis and reporting applications.
• Define specifications and develop programs, modify existing programs, prepare test data, and prepare functional specifications.
• Identify and resolve application, database software, and programming problems.
• Support integrated applications with an understanding of system integration, test planning, scripting, and troubleshooting.
• Assess the health and performance of BI reporting applications, ETL & ELT tools and databases.
• Establish, participate, and maintain relationships with business units, customers, and IT subject matter experts in order to remain apprised of direction, project status, architectural and technology issues, risks, and function/integration issues.
• Identify potential process improvement areas and suggest options and recommend approaches.

Internal Relationship Management

• Interact daily with internal customers and GCSS managers.
• Faciliate periodic status meetings with internal customers.
• Develop and maintain effective working relationships with EITS/GCSS colleagues.
• Maintain effective working relationships with other regions peers/teams.

External Relationship Management

• Liaison with third party suppliers such as Oracle.
• Creation and management of third party service requests.

Application of Processes, Controls, Standards and Measures

• Maintain Experian Service Management documentation and change standards, following the prescribed software development life cycle.
• Provide service meeting Service Level Agreements for incident, problem, and change management.
• Adhere to information security and audit requirements.
• Work to continuously improve efficiency and effectiveness of systems.

Role Dimensions:

• Support users in multiple countries with different cultural and business environments.
• Have the ability and flexibility to travel internationally.
• Maintain a flexible approach to working arrangements across different time zones and a follow the sun support process.
• Work within different cultural and multi-lingual environments.
• Be available to work weekend and off-hours at short notice.
• Possess strong strategic process and procedure methodology with attention to maintaining robust audit controls.

Competencies

• Customer Focus
• Continuous Improvement
• Information Monitoring
• Managing Work
• Building Strategic Work Relationships
• Collaboration
• Driving for Results
• Quality Orientation

Skills:

• Extensive hands-on technical expertise with ETL & ELT technologies (Admin & Developer), Oracle BI Application (OBIA), OBIEE reporting (Admin & Developer), data modelling techniques as well as solid knowledge of Data Warehousing concepts.
• Sound functional knowledge with Oracle eBS ERP and SF.Com CRM applications and assist in any transitioning of data sets to big data platform as our requirements evolve in future.
• Extensive knowledge of Oracle Business Intelligence integrated with Hyperion Essbase and relational database (OBIEE 12c, Essbase 11.x)
• Extensive experience in supporting the Oracle BI Application (OBIA) prebuilt ERP models in the area of finance and procurement and various ETL phases SDS, SDE, SIL & PLP.
• Experience in supporting the Oracle BI application upgrades
• Ability to provide application production support as well as design & develop.
• Ability to translate business requirements to high quality set of technical requirements
• Effective management of Support tickets with hand offs/exchanges with peers on team working in global time zones.
• Extensive Client/User interaction and expanding globally as we evolve our big data platform and analytics tool portfolio
• 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 UK 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

Experience:

• 6+ years of progressive IT professional experience
• 4+ years of experience supporting BI applications, preferably 12c version in a global environment.
• 4+ years of experience providing customer support in a technical environment
• Experience with OBIA, OBIEE, Hyperion Essbase, SQL, PL/SQL, ETL (Informatica) and ELT (ODI) tools, Unix and Windows