McLaren IT sits at the heart of McLaren’s operations and is an essential part of our brand, ensuring that Applied Technologies, Racing and Automotive have the resources they need to function at the highest level. We work at the forefront of innovation and offer a fast paced, cutting edge and challenging environment for those driven by ambition and a desire to win!
Purpose of the Role:
Reporting to the Reporting Lead, the Data Analytics Engineer will be part of team responsible for the specification, building and maintenance of our data engineering platforms. This includes the integration and management of the various data sources that feed into our existing warehouse solution as well as availability of data to visualisation platforms for pre-defined or self-service BI reporting.
You will work closely with key business users and IT colleagues to provide a high-quality data engineering solution, in addition provisioning SME best practice guidance across the domain.
Close liaison with IT Extended Leadership team and business sponsors within each of McLaren’s businesses, IT SME’s and domain functional experts across the company.
Works with suppliers, project managers, technical architects and technical delivery teams to specify, build, and maintain data engineering platforms for Business Intelligence and Analytics.
Works with data scientists, domain functional experts and business stakeholders to catalogue, explore, enable access to, prepare, and visualize internal and external data sources.
Provide functional expertise and guidance around leveraging the capabilities of data engineering platforms to business stakeholders
Act as liaison between business key users and the CoE for investigating, analysing, and implementing data warehouse (including documenting, mapping business requirements, analysing processes and developing system modifications to satisfy business needs)
Produce end-to-end solutions for new and existing projects
Deliver configuration enhancements from concept to solution (change requests)
Manage complex incident resolution (root-cause analysis, problem statements)
Provide excellent responsiveness for level 2 and 3 business support requests
Run proof of concepts and investigate opportunities for use of innovative cloud solutions
Assists in the definition of the data engineering strategy, solutions and roadmaps, ensuring they meet McLaren business requirements and performance goals in line with McLaren Technology Group IT strategy.
Responsible for ensuring the production services are optimally configured and aligned to best practices to protect production data.
Part of team performing the development of data consumption and data storage platforms
Development of data manipulation services (e.g. machine learning, stored procedures, USQL, TSQL, ETL, scripting (Python or R) etc)
Creation of reports and dashboards on behalf of IT and in conjunction with business stakeholders.
Essential Knowledge, Skills and Experience:
Proven production experience and best practice knowledge, working in an Azure Data Factory v1 and v2 environment
Best practice principles behind taking various data sources (such as SAP) and loading into warehouse with associated data transformation to present to Power BI platform
Designing solutions around re-usability and for ad-hoc reporting usage.
Hands on usage of linked services, datasets and pipelines within Azure environment
Knowledge of multi-tier, high availability, cloud and on premise data engineering solutions in a complex multi-cloud, multi-site enterprise environment
Knowledge of cloud platforms, features, and capabilities with previous experience of integrating cloud services to work with on premise data sources and clients.
Strong SQL knowledge to include common table expressions
Previous experience of creating dashboards and data visualization elements within a Power BI or Business Objects front end
Ability to develop functional specifications for business requirements
Proven experience working with offshore teams to utilize resources to meet deliverables
Demonstrable experience of ETL technologies
Desirable Knowledge, Skills and Experience:
Azure Machine Learning for predictive analytics
Azure LogicApps and Event Hubs
SAP Business Objects and functional exposure
Experience with scripting languages such as Python, R, REST and PowerShell
Demonstrates creativity and self-motivation in identifying opportunities and finding solutions
Establishes credibility in order to work as a results driven and collaborative team player
Flexible approach to continually adapt within a dynamic workplace
Business knowledge and process design skills
Ability to analyse problems and provide clear recommendations
Excellent interpersonal, communication skills, written and verbal combined with effective technical presentation skills
Organised, methodical and able to multi-task whilst working under tight deadlines
The Work Environment:
We offer a flexible working environment across our South-East sites including the world-renowned McLaren Technology Centre. Our campus includes a subsidised restaurant, a café, a gym with a pool, break-out spaces, bicycle storage facilities and more. Our environments are designed to encourage collaborative working across all teams. You will be amongst specialists within their field, whether it’s in design, modelling and simulation, software development, data analytics, electronics hardware, finance and marketing.
The Recruitment Process:
If your application is successful, you’ll be invited for a phone interview with one of our experienced technical recruiters.
Following successful review, you will then partake in a 30-minute telephone interview with the Hiring Manager.
The final stage will be an onsite face to face interview at the McLaren Technology Centre in Woking, Surrey with the Hiring Manager and wider team.
Please note: you must hold the Right to Work in the UK.
McLaren Racing has one single mission: To win Grands Prix and World Championships. To design, build and operate a Formula One car at race-winning levels requires focus, ambition, imagination, dedication and attention to detail.
We're looking for an exceptional data scientist to help us take our bespoke data analysis and software applications to the next level. You'll need an obvious passion for analytics and a significant interest in new technologies. You could be exploring and visualizing vast data sets in MATLAB, Python or D3; building a data-driven model using machine learning; or modelling uncertainty in a process using Bayesian techniques. The role will be involved in all stages of the development life cycle from initial analysis to deployment, so you'll need to be able to elicit requirements and see them through to delivery using best practice agile techniques.
You’re an excellent analyst and can develop simple analytical solutions to complex engineering problems
You have demonstrable expertise in the particular field of machine learning. You understand how to write clean, maintainable code
You recognise the importance of continuous learning and sharing that knowledge with others
Knowledge, Skills and Experience
Strong academic background with MSc or PhD in relevant discipline
Proven mathematical knowledge and research capability; understanding of machine learning, deep learning, statistics,
Relevant post-doctoral or industrial development experience in delivering data-driven projects using programming tools such as Python, R, MATLAB
Experience in handling large amounts of data in a high throughput environment
High competency in written and oral English language
MSc or PhD in relevant discipline
Experience working with agile methodologies
Previous experience developing data analysis/visualisation applications
Purpose of the Role:
Input and maintain data
Monitor and track resource utilization
Produce relevant metrics and reports
Provide support with all workforce planning and forecasting activity
Input and maintain resource data
Generate weekly, monthly and annual metrics
Present comprehensive MI information to senior leaders
Create and maintain a utilisation report for ongoing development
Implement resource allocation and utilisation processes and systems
Chase managers for critical data to ensure reporting is accurate
Partner with the Finance team to understand rate cards for budgeting
Identifying risks with resource allocation and escalate accordingly
Analyse and report on trends within the business around resource allocation and utilisation
Provide analysis and reports on skills gaps identified
Identify improved ways of working and make recommendations
Build relationships with key stakeholders across the business
Work on ad hoc workforce planning projects
Liaise with the HR team to ensure alignment around resource processes
Manage third party relationships
Provide meaningful data to the project and programme teams so they can manage their resource budgets
Knowledge, Skills and Experience:
Mathematical with a keen eye for accuracy and detail
Data analysis expertise and competency is essential
Advanced excel skills including functions such as calculations, pivot tables, VLOOKUP, manipulating data and production of graphs
Accuracy in managing data and associated information
Have a flair for data and analysis and be relied upon to highlight long-term resourcing budget and scheduling requirements
Confident presentation skills when demonstrating data
Personal Attributes :
Open and honest
A desire to try things a new way and challenge the status quo
Thinks outside of the box in terms of solutions
Enjoys working at a pace and under pressures
A willingness to find a balance between industry best practice and a pragmatic approach to find the most appropriate way
Customer focused and driven – an enabler to the business
Confident and a proven ability to overcome setbacks and think in a solution focused way
Data and metrics driven and a passion for getting things right first time
Strong team player