McLaren Woking, UK
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. Role Dimensions: 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. Principal Accountabilities: 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 Automotive experience Personal Attributes: 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.