Data Analyst / BI Developer

Recruiter
MSXI recruitment
Location
Coventry
Salary
£40,000 depending on experience
Posted
05 Aug 2017
Closes
10 Sep 2017
Contract Type
Full Time
MSX International is the leading global provider of outsourced business solutions for the automotive industry. We have the hands-on experience of automotive best practices, the state-of-the-art technology and the in-depth information to boost company efficiency and profitability.

Currently we are looking to fill the position of

Data Analyst / B.I. Developer

Based in Midlands: Leamington spa

Main purpose of the role

The Data Analyst/B.I. Developer role will work with the Jaguar Land Rover Global Reporting and Analytics team, part of the Global Learning Services department. The Jaguar Land Rover Global Learning Services team play a pivotal role in the development of a fully competent, capable and formidable Global retail network for Jaguar Land Rover. The Learning Services team are part of the wider Global Network Learning and Development (GNL&D) Team and are responsible for the development, measurement and management of the Global learning standards, learning platforms and human capability. This involves working with the relevant cross-functional teams and International Regions and Markets.

The main purpose of the Data Analyst/B.I. Developer role is to support in the delivery of Global reporting/analysis of Learning and Development related data to the business, working alongside other team members (Business Analysts/Developers etc.) in designing, developing, testing and distributing key M.I/B.I reporting, whilst also undertaking analysis to provide value-added insights, enabling data driven decision making.

Candidate Responsibilities

- Responsibility for developing and delivering high quality M.I./B.I. reporting solutions to the GNL&D department and the wider business as necessary, in order to equip Management with the necessary data / analysis to enable timely, data driven decision making.
- Capture new M.I/B.I reporting and analysis stakeholder requirements, identify and source relevant data and develop the necessary reports / analysis / insights.
- Be able to write SQL to do initial data queries/extraction that can then be communicated to peers for further analysis/report development.
- Support with creation of new/migration of existing M.I reports in to Tableau (JLR approved data visualisation tool).
- Development and delivery of relevant weekly, fortnightly, monthly, quarterly and annual Global reporting requirements.
- Develop and deliver short term ad-hoc reporting, supporting functional leads in response to high-priority topical issues.
- Support development and delivery of mid/long-term correlation analysis between Global L&D metrics and wider business metrics, using statistical modelling techniques.
- To improve existing reporting and analysis processes where possible, in order to streamline tasks and minimise business continuity risks.
- Potential for candidate to support with the design, delivery and deployment of a green-field Operational Data Store (ODS) and Data Warehouse (DW) - the necessary B.I. Architecture to meet the needs of GNL&D / the wider JLR business' short-term, medium-term and long-term reporting requirements.

Candidate Requirements

- Proven experience in data manipulation / data analysis
- Ability to manage and interpret / query large quantities of data, understanding of multiple data sets
- Experience of working with data analysis / visualisation tools - ideally a minimum of 3 years M.I. / B.I. development experience
- Experience in SQL (queries, views, stored procedures, user defined functions, cursors, indexing etc)
- High standard of literacy in Excel features & functions in order to maintain existing reports if necessary as well as developing others (i.e.VLOOKUPs, IF statements, SUM statements, pivot tables, graphs & charts, VBA / Macros etc)
- Experience in the following B.I. / data visualisation tools advantageous; Tableau, Jaspersoft
- Technical knowledge and applied understanding of databases and systems architecture advantageous
- Experience in Google Cloud Services, BigQuery advantageous
- Experience in working with, development and / or maintenance of Databases (e.g. DBA), Operational Data Stores / Data Warehouses / Data Marts / OLAP cubes / Ad-hoc analysis tools.
- Statistical modelling techniques / data mining experience advantageous
- Education to degree level is an advantage but not essential

Desirable

- An understanding of Cloud Computing, in particular database and ETL integration into the Cloud / Data Lakes.
- Experience with Data Profiling tools
- Understanding of Github code management
- Experience in developing dashboards in multiple reporting platforms
- Experience of BI Development / Database Management within the Learning & Development industry
- Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for the reporting platform's server logons and security checks

Personal Characteristics

- Inquisitive in nature, likes to explore trends and patterns in data, undertake root cause analysis when issues are highlighted and natural problem solver
- Strong analytical ability
- Clear and concise communication skills
- Ability to work under minimal supervision, be pro-active and use initiative
- High level of self-organisation and structured delivery
- Can be relied upon to deliver within tight deadlines, remaining calm under pressure and promoting a professional 'Customer First' service
- Determination and resilience to get the job done
- Team player who is able to develop strong working relationships
- High level of accuracy and attention to detail, takes pride in their work
- Drive to continuously improve delivery and scope of role / impact on the department
- Willingness to adapt and be flexible

Reporting to

- MSXI Project Leader

Working hours

- Full time

What we offer

- Competitive salary (up to £40k p.a. depending on experience)
- Other company benefits: - o 25 days annual leave
- o Company contributory pension plan
- o Cash back health care scheme (benefit value approx. £675)
- o Life assurance
- o Permanent Health Insurance
- o 20 days full pay sick days (after three months service)
- o Salary exchange childcare vouchers
- o Car salary exchange scheme

MSXI is an equal opportunities employer and positively encourages applications from suitably qualified and eligible candidates regardless of sex, race, disability, age, sexual orientation, gender reassignment, religion or belief, marital status, or pregnancy and maternity.

Application

Email your CV to *********************