Report Modeller & Developer in Milton Keynes

About us
At Mercedes-Benz Financial Services, our employees are at the heart of our business. Our colleagues provide a range of financial solutions designed around the changing needs of our diverse customers. It doesn’t matter the colour of your skin, the beliefs you value, the people you love or the tattoos you wear, we support you for being you. Through the doors of Mercedes-Benz Financial Services, you will find a passionate team working to support our customers and our colleagues. We ensure that everyone has an equal opportunity to learn and develop. We want to celebrate your individuality, embrace your personality and welcome you into our culture. It’s the differences of our colleagues that enable us to thrive. We believe our backgrounds, skills and cultures contribute to our shared culture and help us deliver outstanding Customer Experience. Inclusion is the driving force behind our ethos. At MBFS, we are proud to be a Menopause Friendly Accredited Employer, reflecting our ongoing commitment to creating a supportive and inclusive workplace. We offer wellbeing support options and resources for colleagues experiencing menopause and to those who are supporting someone through it.

How you’ll play your part
In this role, you will work closely with Finance, MI, Data Governance, IT and wider business stakeholders to translate business requirements and user stories into robust data models, semantic layers, calculations, measures, KPIs and reporting outputs. The role will support operational interfaces, aggregated data files, regulatory and operational reporting, and analytical use cases. We are looking for a hands-on data professional with strong expertise in Databricks, Azure Data Factory, SQL, Power BI, DAX and data modelling techniques. The role will contribute to the migration from the existing data warehouse and Cognos reporting environment into the new Azure Data Lake, helping to create scalable, trusted and reusable data assets for MBFS. The role will also provide line management, coaching and mentoring to one Data Apprentice, supporting their development while strengthening data capability across the MI team.

Main Accountabilities
Data Modelling Activity:

• Design and deliver data models and schemas for each new data source tranche selected for the strategic Data Lake solution, aligned to agreed user stories and business priorities.
• Define and build calculations, measures, Critical Data Elements, KPIs and data quality criteria that support trusted reporting, operational interfaces and analytical outputs.
• Develop data models and schemas for new Finance dashboards, ensuring consistency, scalability and reusability across the MI reporting landscape.
• Support the migration of relevant data sources and associated Cognos reports from the existing Data Warehouse to the new Azure Data Lake.
• Create and maintain semantic layers that enable business users and data analysts to consume data consistently and efficiently.
• Work with Data Governance to define, document and manage common data modelling components, standards and ownership principles.
• Identify opportunities to enable advanced analytics, machine learning and AI through well-structured, high-quality data models.

Finance & MI Team Reporting Activity:

• Partner with MI team members to improve reporting efficiency through enhanced data models, automation and common reporting logic.
• Review the current reporting catalogue to identify duplication, common Critical Data Elements and opportunities for simplification.
• Provide operational cover and technical support to the wider MI team where required.
• Develop and maintain Finance and Controlling MI reports using Power BI, Power BI Report Builder, Cognos or other agreed tools.
• Contribute to improvements in data governance, data quality, reporting standards, data literacy and user training across MBFS UK.

Data Engineering Activity:

• Use Databricks, Azure Data Factory and SQL to support data engineering delivery where required, working closely with the wider Data Engineering team.
• Contribute to, and influence, the overall data architecture and solution design for MI deliverables.
• Navigate the MBFS IT landscape to progress delivery, including data configurations, data networks, infrastructure, connectors and integration points across source systems.

Line Management:
Line Management of a Data Apprentice providing mentoring and guidance.

About you
Technical Skills and Experience:

• Expert-level experience with Databricks, Azure Data Factory and SQL, including SQL queries, stored procedures and integration patterns.
• Strong experience in data modelling, schema design and semantic layer creation, including measures, calculations, KPIs and Critical Data Elements.
• Practical understanding of medallion architecture and how to apply it to scalable Data Lake and reporting solutions.
• Strong working knowledge of Power BI, Power BI Report Builder and DAX for dashboard and report development.
• Experience using Microsoft productivity and automation tools, including Power Automate, Power Pivot, Teams, SharePoint and OneDrive.
• Good understanding of database management systems, ETL frameworks and data integration concepts.
• Understanding of Azure Data Lake design, dimensional modelling, data mining and reporting architecture.
• Knowledge of Cognos is desirable but not essential.

Business Skills and Behaviours:

• Able to translate business needs into practical, scalable data and reporting solutions.
• Proactive, curious and innovative, with a strong focus on continuous improvement.
• Strong analytical mindset with a structured approach to problem solving.
• Confident coaching, mentoring and influencing end users, business data analysts and less experienced team members.
• Comfortable working in agile delivery environments where requirements may evolve and not all facts are known up front.
• Collaborative, delivery-focused and able to build effective relationships with technical and non-technical stakeholders.

What’s in it for you?
We’ll offer you a competitive salary and discretionary bonus structure. We also hope you’ll love our products as much as we do, with access to our colleague car schemes. On top of that, you’ll be able to join our pension scheme and you’ll get a flexible benefit pot that can be used to find the benefits that are right for you. We’re here to support you – we offer access to colleague wellbeing resources, including an Employee Assistance Programme, Mental Health First Aiders and the Inclusion Advocates as well as flexible opportunities to support work life balance. We’ll also encourage your development, with the training and knowledge you need to reach your potential. Through the doors of Mercedes-Benz Financial Services, you’ll find a passionate team working to put our customers first. We know that to keep this team motivated, we need to ensure that everyone has equal opportunity to learn and develop. We celebrate a culture of appreciation and respect, where everyone is valued for who they are. We believe our backgrounds, experiences and cultures contribute to our shared experience and shape who we are and what we do. The diversity of our colleagues reflects the diversity of our customers. This diversity is the driving force behind our ideas.

What’s next?
When you apply, you’ll be asked to complete a short online application where we’ll ask that you include your current CV. You’ll also be asked some application questions, including your current salary information. The Mercedes-Benz recruitment process reflects our obligations under relevant UK legislation. Whilst all applications are carefully considered, we are only able to progress applications from candidates who have the right to work in the United Kingdom. Please be assured that we’re here to support you throughout the recruitment process and beyond, and reasonable adjustments are available to any candidates who need them. We’re also open to working flexibly and are happy to discuss flexible working options. As applications are reviewed on an ongoing basis, this vacancy may close before the advertised closing date. Early applications are encouraged.

Managing your data
We care about your personal data. The General Data Protection Regulation provides you with more control and by submitting an application to us, we consider this to be an agreement to process your personal data in support of our recruitment and selection process. Data categories that we process in relation to your application are the ones that you provided as part of the application process. We process your personal data in relation to the application, in accordance with the legal requirements. Recipients of your personal data within our company are the managers of the specialist unit in charge of filling the position and the responsible colleagues from HR. Your application data is held within our secure application tracking system called Taleo – you’ll be given access to a candidate zone in this system where you can monitor and manage your application and see status updates. We will communicate with you, by email or phone throughout the recruitment process so that we can keep you updated and inform you of your progress through the recruitment process. You can also seek ‘job alerts’ once you are registered in Taleo and it’s possible your details may be returned in searches we conduct for new positions and we may contact you by email to let you know about them. We limit the storage of your data to the necessary period. Contact us at careers@mercedes-benz.com for further information. If you have any questions about any matter relating to data protection or the personal data that we process about you for the purpose of personnel recruiting, please contact the Chief Officer of Corporate Data Protection for the Mercedes-Benz Group AG at the following address: Mercedes-Benz Group AG, HPC E600, 70546 Stuttgart, data.protection@mercedes-benz.com.