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 CoverThe 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
- Approval flows and notifications
- 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:
BarcelonaBrand:
MerkleTime Type:
Full timeContract Type:
TemporarySkills Required
- 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
- Experience with SharePoint and Microsoft Fabric
- Strong understanding of Finance and Operations business processes
- Experience delivering end-to-end application and reporting solutions
- Strong problem-solving and analytical skills
dentsu Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about dentsu and has not been reviewed or approved by dentsu.
-
Parental & Family Support — Paid parental leave at full pay and caregiver supports (including backup care) are emphasized as standout elements. Feedback suggests family-oriented benefits are a strong part of the package.
-
Leave & Time Off Breadth — Flexible or unlimited PTO, extensive paid holidays, and a year-end office closure are established components. Feedback suggests time-off policies are generous and add meaningful flexibility.
-
Retirement Support — A large, established 401(k) plan with employer matching is clearly documented. Feedback suggests retirement benefits feel competitive and straightforward.
dentsu Insights
What We Do
We are dentsu. We team together to help brands predict and plan for disruptive future opportunities and create new paths to growth in the sustainable economy. We know people better than anyone else and we use those insights to connect brand, content, commerce and experience, underpinned by modern creativity. We are the network designed for what’s next
