Temporary BI and Applications Analyst

Job Description:

We Dream. We Do. We Deliver.

At Merkle, a dentsu company, we power the experience economy. Whether we’re building the next great app, running CRM at scale for global brands, delivering technology architectures that support millions of users, or providing world-class data, identity, and insights solutions, it’s all in the name of crafting experiences that set brands apart from the competition. Backed by dentsu's legacy of innovation and creativity originating in Japan, we’ve spent over 35 years helping brands build loyalty, drive growth, and connect meaningfully with their audiences.

We’ve been named a global “Leader” by top industry analyst firms in categories as wide-ranging as digital transformation and commerce, experience design, engineering and technology integration, digital marketing, data science, CRM and loyalty, and customer data management.

Role Overview

Temporary Position – Maternity Cover

The BI and Applications Analyst is responsible for designing, delivering, and maintaining data solutions that support business operations, financial reporting, and client management across Merkle EMEA.

The role combines solution architecture, development, and process optimisation, with a strong focus on the Microsoft ecosystem (Power Platform, Power BI, SharePoint, Fabric).

Key Responsibilities

Application Development & Ownership

Design and build business applications using Power Apps and integrated solutions within Power BI environments

Ensure applications follow best practices for:

Security and access control

Data validation and error handling

Scalability and maintainability

Automation & Process Optimisation

Lead automation initiatives using Power Automate

Standardise and improve processes such as:

Invoice generation and email workflows

Data integration between systems (e.g., finance platforms, reporting tools)

Data & Reporting Solutions (Power BI / Fabric)

Develop and manage Power BI reports and semantic models supporting finance and operations

Work with complex data architectures including:

SQL databases, dataflows , SharePoint and external sources

Deliver reporting solutions focused on:

Revenue, cost tracking, and forecasting

Client performance and financial KPIs

Troubleshoot and optimise dataflows and reporting issues across environments.

Knowledge, Skills & Experience

Proven experience in Power Platform (Power Apps, Power Automate)

Strong expertise in Power BI, including data modelling and DAX

Experience working with SQL, dataflows, and enterprise data sources

Strong understanding of business processes, particularly in Finance and Operations environments

Experience delivering end-to-end application and reporting solutions

Strong problem-solving and analytical skills

Location:

Barcelona

Brand:

Merkle

Time Type:

Full time

Contract Type:

Temporary