Senior Data Insights Consultant
On-siteMadrid, Madrid, Spain
Job Summary
Architect and deliver complex data solutions and integrations for enterprise-scale campaign platforms, serving as a key advisor to clients on leveraging data assets to optimize communication strategies. Perform advanced analysis to uncover actionable patterns that inform client strategy, while designing test-and-learn programs across channels to measure impact and continuously optimize performance. Partner with senior stakeholders to translate strategic business questions into robust analytical frameworks and data roadmaps, supporting large-scale projects with globally recognized brands. Drive agentic AI adoption by embedding solutions into workflows and provide insights via automated reporting and ad-hoc analyses within marketing platforms like Adobe and Salesforce. Mentor junior team members and collaborate with Account Managers, Architects, and Data Scientists to coherently service clients.
Required Qualifications
- A minimum of 5 years of experience in a consultant/business liaison role related to data, BI, analytics or reporting solutions
- Can independently design, build, and optimize modern analytics solutions that are scalable, maintainable, and ready for real-world production use
- Write, debug, and optimize complex SQL queries, ensuring clarity, efficiency, and production readiness
- Design and build scalable dimensional data models from raw source systems (fact/dimension structures, performance-aware design)
- Apply strong data modelling principles, governance standards and practices that ensure data accuracy, consistency, and security
- Develop and manage DBT transformations using layered architecture, including testing and documentation best practices
- Build production-ready Power BI semantic models and dashboards, including advanced DAX measures, performance optimization, and secure data access (RLS)
- Work collaboratively using GitHub, following structured branching, pull request, and code review workflows
- Familiarity with or a strong interest in the application of AI and agentic frameworks, and machine learning principles to generate conversational analytics, predictive and advanced marketing insights
- Comfortable working in modern cloud data environments (e.g., Snowflake, BigQuery, Databricks, Fabric)
- Understanding the data structures and reporting capabilities within major marketing and martech platforms (e.g., Adobe Campaign/AJO, Salesforce Marketing Cloud)
- Technical stakeholder management and influence: A proven ability to build trust and act as a strategic partner to senior-level clients and internal leaders
- Exceptional written and verbal communication skills in English, with the ability to articulate complex data concepts and insights into clear, compelling narratives for both technical and senior business audiences
- The ability to critically assess complex business challenges, ask probing questions to uncover root causes, and propose robust, data-driven solutions
- Proven experience in coaching and mentoring junior team members
- You are a self-starter who can think critically, identify issues and opportunities autonomously, and take the initiative to propose and implement corrective actions
Desired Qualifications
- It's an advantage if you have consulting, agency experience or marketing domain knowledge, but it's not a requirement
- Ability to build and deliver reports and insights dashboards natively within these tools is a strong advantage
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.