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 business processes, particularly in Finance and Operations
- Experience delivering end-to-end application and reporting solutions
- Strong problem-solving and analytical skills
What We Do
Dentsu Creative is a global creative agency network designed to unlock exponential growth for clients. We use Transformative Creativity as a differentiating, driving force to bring our capabilities together to positively impact people, business and society. Established in 2022, Dentsu Creative is integrated with dentsu’s Media and CXM businesses in over 145 countries and regions, to offer Integrated Growth Solutions.
