Job Description

Company Description

Experian is the world's leading global information services company. During life's big moments - from buying a home or a car to sending a child to college to growing a business by connecting with new customers - we empower consumers and our clients to manage their data with confidence. We help individuals to take financial control and access financial services, businesses to make smarter decisions and thrive, lenders to lend more responsibly, and organizations to prevent identity fraud and crime.

We have 17,800 people operating across 44 countries, and every day we're investing in new technologies, talented people and innovation to help all our clients maximize every opportunity. We are listed on the London Stock Exchange (EXPN) and are a constituent of the FTSE 100 Index.

Learn more at or visit our global content hub at our for the latest news and insights from the Group



1. Job Title: BI Developer Analyst

2. 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.

3. Major Job Functions:

a. 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.

b. 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.

c. External Relationship Management

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

d. 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.

e. Region Specific Skills

• .N/A

4. Required Knowledge / Skills / Experience

5. 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.

6. Competencies

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

7. Organisation Data:

• Direct Supervisor: BI Manager
• Direct Subordinate: None
• Indirect Subordinate: None

8. Location:

Hyderabad, India

9. Salary:
TBC

Qualifications

Education:

Bachelor's degree, preferably IT-related.

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