Data Analyst

Job description

Segment

Downstream
Role synopsis

One of BP's key strategies is to become a more data driven business. We have an opportunity for a Data Analyst to join our newly created Downstream IT&S Big Data & Analytics team. The role will combine elements of traditional business and systems analysis as well as hands on data analysis facing off to business stakeholders and other IT teams.
Req ID

81464BR
Location

United Kingdom - South East - Sunbury, United States - Illinois - Chicago
Is this a part time position?

No
Relocation available

No
Travel required

Yes - up to 25%
Key accountabilities

The analyst will provide insight, partnering closely with business stakeholders to realize benefits and align the overall technology and business strategy. By using data and information analytical tools, this role will support the development of prototypes through the identification and extraction of the right data and manipulation of the data into suitable formats. This may include the creation of specialist interfaces and transformation routines so that the data can be used by data scientists and other data specialists. This would include:

·  Investigating operational requirements, problems, and opportunities by seeking effective solutions through improvements in data dependent components of new or changed business processes.
·  Assisting in the analysis of stakeholder objectives and the underlying issues arising from investigations into business requirements and problems, identifying options for consideration.
·  Applying a variety of analytical and visualisation techniques, in consultation with experts if appropriate, and with sensitivity to the limitations of the techniques.
Responsibilities include:

·  Refining requirements to eliminate ambiguity, conflict and duplication.
·  Modelling requirements using a structured approach.
·  Producing high quality analysis deliverables.
·  Understanding system constraints and opportunities to inform design.
·  Working with design and architecture on design options and potential systems and process solutions.
·  Co-ordinating/high level direction of the end to end of the data flow from use case, ingestion, wrangling to visualizations/insight
·  Maintaining the data feed catalogue.
·  Supporting key design decisions documents to identify and select appropriate feed design.
·  Writing feed definition documents (features/epics) describing feed requirements, design and implementation.
·  Writing feed data dictionaries describing data lifecycle and contents (table/file/attributes).
·  Elaborating feed epics into product backlog items (stories) with acceptance criteria
·  support of development and test activity.
·  Data analysis to produce initial data cuts and define data extract patterns.
·  Development of SQL to define data extract design.
·  Managing relationships in a global team with a global user community.
Essential Education

·  SQL skills in Oracle and SQL Server for data analysis.
·  Excel and Access as data analysis, cataloguing and specification tools.
Desirable criteria and qualifications

·  Data migration delivery experience
·  Java development experience
·  Data analysis skills including entity relationship diagrams and object graph mapping.
·  Use of MS Excel and Access for data analysis.
·  Use of MS Excel/Word /Wiki for documentation of architecture/design/implementation.
·  Development and maintenance of build scripts and use of Jenkins for build automation.
·  Familiarity with ETL concepts and solutions.
·  Familiarity with scheduling and orchestration tools.
·  Familiarity with data extraction from 3rd party APIs.
About BP

Our business is the exploration, production, refining, trading and distribution of energy. This is what we do, and we do it on a truly global scale. BP operates with business activities and customers in more than 80 countries across six continents. Every day, we serve millions of customers around the world. We are continually looking for talented, committed and ambitious people to help us shape the face of energy for the future.

The Downstream Segment is responsible for the supply and trading, refining, marketing and transportation of crude oil and petroleum products to wholesale and retail customers. We market our products in over 100 countries, operating primarily in Asia, Europe and North America but also in Australia, Africa and Central and South America.
Application close date

22-Jun-2017
Sub-category

Business Analysis & Consulting
Job category

Information Technology & Services
Countries (State/Region)

United Kingdom - South East, United States - Illinois
Disclaimer

If you are selected for a position in the United States, your employment will be contingent upon submission to and successful completion of a post-offer/pre-placement drug test (and alcohol screening/medical examination if required by the role) as well as pre-placement verification of the information and qualifications provided during the selection process. The drug screen requires a hair test for which BP must be able to obtain a sufficient hair sample for analysis (~4 cm/1 ½” scalp, or > 2 cm/¾” body – arms & armpits/legs/chest).

BP is an equal employment opportunity and affirmative action employer. View ourpolicy statement .

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.

If you are a US-based applicant or you are applying to a position in the US and you are an individual with disability or a disabled veteran, and would like any type of assistance to apply or to access or to attend any recruitment or selection event, system or process, we would like to help you to ensure that your application process goes as smoothly as possible. If you need assistance, information, or answers to your questions, and you are an individual with disability or a disabled veteran, feel free to contact us or have any of your representatives contact us at BP US Application ,Telephone: 281.366.1999.

Read theEqual Employment Opportunity is the Law poster and theposter supplement - for more information about Equal Employment Opportunities. (Spanish version )

An equal opportunity employer/disability/vet.

Desired profile

Essential experience and job requirements

·  Ability to work with demanding users in a fast-paced environment.
·  Solid grounding in Big Data technologies: HDFS, SQOOP, cluster management.
·  Unix shell scripting in bash / ksh.
·  Python development.
·  Windows batch script.
·  Experience in unit test automation.
·  Experience in continuous integration and development techniques.
·  Exposure to Scrum/Agile delivery methodologies.
·  Strong data analysis skills including entity relationship diagrams and object graph mapping.
·  Demonstrable experience of requirements elicitation and documentation carried through to design and implementation.
Other Requirements (eg Travel, Location)

N/A
Eligibility Requirements

If you are applying for a position in the United States, you must be at least 18 years of age, legally authorized to work in the United States; and not require sponsorship for employment visa status (e.g., TN, H1B status), now or in the future.