Report Modeller & Developer

About us

At Mercedes-Benz Financial Services, our employees are at the heart of our business. We provide financial solutions designed around the changing needs of our diverse customers and are committed to inclusion, development and equal opportunity.

How you’ll play your part

As Report Modeller & Developer, you will work with Finance, MI, Data Governance, IT and wider business stakeholders to translate requirements into robust data models, semantic layers, calculations, measures, KPIs and reporting outputs. You will support operational interfaces, aggregated data files, regulatory and operational reporting, and analytical use cases.

You will contribute to the migration from the existing data warehouse and Cognos reporting environment into the new Azure Data Lake, creating scalable, trusted and reusable data assets. The role also includes line management, coaching and mentoring of one Data Apprentice.

Main accountabilities

• Design and deliver data models and schemas for new data sources within the strategic Data Lake solution.
• Define calculations, measures, Critical Data Elements, KPIs and data quality criteria.
• Develop scalable and reusable models for Finance dashboards.
• Support migration of data sources and Cognos reports to the Azure Data Lake.
• Create and maintain semantic layers for business users and data analysts.
• Work with Data Governance on modelling standards, ownership and common components.
• Enable advanced analytics, machine learning and AI through high-quality data models.
• Develop and maintain Finance and Controlling MI reports using Power BI, Power BI Report Builder, Cognos or other agreed tools.
• Use Databricks, Azure Data Factory and SQL to support data engineering delivery.
• Contribute to data architecture and solution design.
• Provide line management, mentoring and guidance to a Data Apprentice.

About you

• Expert-level experience with Databricks, Azure Data Factory and SQL.
• Strong experience in data modelling, schema design and semantic layer creation.
• Practical understanding of medallion architecture and scalable Data Lake solutions.
• Strong working knowledge of Power BI, Power BI Report Builder and DAX.
• Experience with Power Automate, Power Pivot, Teams, SharePoint and OneDrive.
• Understanding of database management systems, ETL frameworks, Azure Data Lake design, dimensional modelling and reporting architecture.
• Knowledge of Cognos is desirable but not essential.
• Ability to translate business needs into practical data and reporting solutions and to coach and influence stakeholders.

What’s in it for you?

The benefits include a competitive salary and discretionary bonus structure, colleague car schemes, a pension scheme, a flexible benefit pot, wellbeing resources, development opportunities and flexible working options.

What’s next?

Applications require a current CV and application questions, including current salary information. Candidates must have the right to work in the United Kingdom. Applications are reviewed on an ongoing basis and the vacancy may close before the advertised closing date.