BI & Data Analytics Consultant

Description

Digital marketing has evolved from a single line item in a budget into the growth engine for brands. Yet, amid countless tools, data points, and channels, many companies need a trusted partner to connect all the pieces: strategy, technology, execution, and results. Adsmurai has become that partner. We are a **Growth\-Tech Partner.** We combine proprietary technology, data, artificial intelligence, and expert judgment to transform marketing into a scalable growth system. We design, build, and optimize the complete system that enables brands to grow more effectively—because we believe growth does not come from running more campaigns, but from better connecting the pieces. Our platform, the **Adsmurai Marketing Platform**, serves as the brain of it all. It centralizes campaign management, data, audience segmentation, and feeds—enabling brands and agencies to scale results through automated, intelligent strategies. It integrates multiple sources, platforms, and KPIs in real time, automates catalogs and creatives, and analyzes e\-commerce, CRM, and media data to optimize advertising effectiveness. With a culture rooted in excellence, agility, and collaboration, we foster an environment where bold innovation and efficiency drive transformative outcomes. Our team of over 460 experts is pivotal to this technological revolution. We are an official partner of Meta, Google, Pinterest, and TikTok—and a trusted reference for leading brands in retail\-fashion, luxury, education, and sports. With offices in Barcelona, Málaga, Bogotá, and Madrid, we set the global standard for efficiency and excellence in digital marketing. We are seeking a **BI \& Data Analytics Consultant**, combining strong strategic consulting, technical implementation, and client communication skills. **Key responsibilities:** * **Data Modeling & Data Engineering:** Design, optimize, and maintain robust SQL data models to support evolving environments. You will be responsible for data cleaning, structuring, and loading—ensuring high performance standards. * **Data Visualization & Data Storytelling (Looker/LookML):** Build advanced data products and dashboards based on technical requirements. You will ensure consistent aesthetic and usability principles in dashboard front\-ends to maximize adoption. * **Data Quality & Governance (Data Quality):** Lead data quality control—identifying anomalies, auditing information flows, and resolving issues within complex data processes. * **Technical Consulting & Documentation:** Translate business requirements into product\-oriented technical solutions. You will respond to questions about data architectures/flows and maintain up\-to\-date technical documentation following best practices. **You're a great fit if:** * **Advanced SQL proficiency:** You bring at least 2 years of experience writing, optimizing, and auditing complex SQL code for data preparation and transformation. * **Looker & LookML experience:** You know how to model data in LookML and create clear, interactive, decision\-oriented visualizations. * **Analytical mindset & technical rigor:** You possess a methodical approach to detecting data errors, performing root\-cause analysis, and designing homogenization rules. * **Documentation culture:** You value clarity and ensure every development or model is properly documented to guarantee team scalability. * **Business orientation:** You can understand complex technical briefs and translate them into end\-to\-end operational data products. **Highly valued plus skills:** * **Orchestration & transformation tools:** Prior experience with dbt or similar data pipeline construction tools. * **Industry expertise:** Knowledge of analytics applied to media/marketing investment, financial metrics, or sustainability/ESG measurement projects. **What we offer:** * Permanent contract. * Flexible start and end times. * Hybrid office\-remote model with 2 remote workdays per week. * Reduced working hours on Fridays, pre\-holidays, and during July and August. * 23 vacation days (\+1 additional day per year of seniority). * *Adsmubirthday*—a paid day off on your birthday. * In\-house active training and professional growth through our Career Development Plan. * AdsmuAcademy (a customized learning platform for employees). * Team activities and *afterworks*. * English classes. * Gym partnership (WellHub). * Flexible compensation plan: meal vouchers, transportation allowance, and private health insurance. **Our core values:** * **Make things happen:** We apply reason to decision\-making, grounded in data. We manage initiatives end\-to\-end with a results\-oriented focus. * **Walk, run, fly:** We fuel proactivity by executing ideas. We set ambitious goals, stay curious, and aren’t afraid of failure. * **Passionate players:** We work with positivity and passion in everything we do—persevering with pride in our work. * **Work together:** We build trust\-based relationships founded on honesty. We listen, empathize, and respect others. Our culture aligns with universal values of freedom, cooperation, and self\-actualization. Every day, we strive to ensure equal opportunities for everyone—regardless of gender, ethnicity, nationality, sexual orientation, political or religious beliefs—and we will never endorse any discriminatory action. Adsmurai was founded in 2014 from a conversation among friends—and we continue striving to preserve and convey that positive spirit, turning it into a foundational pillar of our culture.