BI Engineer

VML Alle Jobs anzeigen

  • Luxemburg
  • Unbefristet
  • Vollzeit
  • 2 Monate her
VML LuxembourgVML Luxembourg is one of the leading Amazon consulting agencies in Europe. Offering 360° services for Amazon, we have a diverse range of products and services in various sectors to ensure long-term sales growth, ranging from creating multilingual content and listings to all aspects of advertising, including sales promotion, PPC and programmatic campaigns. We are part of WPP, the world's largest digital media agency, and manage WPP's European Center of Excellence for Amazon (ACE) dedicated to maximising performance, driving sales and building brands on the Amazon platform.The opportunity:We are looking for a Business Intelligence Engineer to join our Data Services team in Luxembourg.In this role, you will work confidently with our cloud-native data spine (data lake and data warehouse) to independently access, combine, and transform data for the models, dashboards, and internal tools you build. You'll focus on data modeling, transformation, visualization, and light web applications that make data easy to use for non-technical stakeholders. A key aspect of the role is leveraging AI-assisted development and workflow tools (e.g. ChatGPT, Claude, GitHub Copilot, Cursor, n8n, LangGraph) to automate repetitive work, accelerate delivery, and ship production-ready solutions faster-while still applying proper code review, testing, and debugging practices. You'll collaborate closely with our Media and Content teams and work with advanced Amazon advertising data (AMC, DSP, retail signals) in a fast-paced, data-driven environment.What you'll be doing:Data Access & Modeling
  • Access and query data from our cloud-based data lake and warehouse using SQL and BI tools.
  • Build and maintain clean, reusable data models (e.g. using dbt) on top of existing datasets to support dashboards, analyses, and internal tools.
  • Ensure consistency of business logic across clients and use cases through well documented transformations and mappings.
Data Transformation & Pipelines
  • Develop and maintain dbt models and other transformation layers within our existing data infrastructure.
  • Implement data quality checks and validation steps to ensure the reliability of outputs.
  • Contribute to improving performance and maintainability of existing transformations (refactoring, standardization, documentation).
Analytics & Dashboard Development
  • Design, build, and maintain Looker Studio dashboards (and similar BI tools) to track Amazon performance (AMC, DSP, Impression Share, retail KPIs, etc.).
  • Run post-campaign analyses, recurring performance reports, and ad-hoc deep dives for key clients.
  • Translate stakeholder questions into clear analytical approaches and visualizations that drive actionable decisions.
Internal Tools & Web Applications
  • Develop lightweight internal web applications and tools that sit on top of our data models (e.g. self-service reporting interfaces, configuration tools, internal portals).
  • Build small utilities, scripts, or APIs to streamline tasks such as dashboard onboarding, data uploads/downloads, and recurring reporting workflows.
  • Ensure internal tools are intuitive, reliable, and aligned with stakeholder needs.
AI-Assisted Development & Automation
  • Use AI coding assistants (e.g. ChatGPT, Claude, GitHub Copilot, Cursor) to write, refactor, and optimize SQL, dbt models, scripts, and web components.
  • Leverage automation and orchestration tools (e.g. n8n, LangGraph, Make, Zapier or similar) to automate repetitive processes in data processing, reporting, and workflow management.
  • Apply best practices for AI-assisted development, including clear prompting, code review, automated and manual testing, and systematic debugging to maintain quality and reliability.
Collaboration & Stakeholder Management
  • Work directly with Media, Content, and Account teams to understand business needs and translate them into scalable data solutions.
  • Communicate data concepts and trade-offs clearly to non-technical stakeholders.
  • Troubleshoot and resolve data issues, including bug fixes, mapping corrections, and small enhancements to existing dashboards or models.
What we want from you:
  • 3+ years of experience in a BI Engineer, Data Analyst, or Data Engineering role (or similar).
  • Strong SQL skills, including complex joins, CTEs, window functions, and aggregations.
  • Hands-on experience with dbt or similar data transformation frameworks.
  • Proficiency with BI/visualization tools, especially Looker Studio (experience with other modern BI tools such as Power BI, Looker, or Qlik is also valued).
  • Comfortable working with cloud-native data lakes and warehouses, independently accessing and joining data for analysis and reporting.
  • Demonstrated ability to translate business requirements into data models, transformations, and dashboards.
  • Proven experience using AI coding assistants (e.g. ChatGPT, Claude, GitHub Copilot, Cursor) to write, test, debug, and ship production-quality code.
  • Strong communication skills, attention to detail, and a mindset focused on automation and efficiency, always looking to reduce manual work.
  • Fluent in English, both written and spoken.
If you know some of this, even better:
  • Experience with Amazon Marketing Cloud (AMC), Amazon DSP, or other Amazon advertising/retail data sources.
  • Python for data manipulation, automation, or web/backend development (e.g. FastAPI, Flask, Django).
  • Familiarity with AWS services such as Athena, Redshift, S3, Lambda, or Step Functions.
  • Experience building web applications or internal tools (e.g. JavaScript/TypeScript, React, Vue, or similar frameworks).
  • Experience with Jinja templating (e.g. in dbt or web frameworks).
  • Background in e-commerce, retail media, or digital advertising.
  • Additional language skills, especially French or German.
What we can offer you:Alongside the opportunity to work with some of the most exciting brands around the world, we'll also prioritise your career development and help you grow your skills. We'll empower you to make a difference, allow you to be yourself, and respect who you are.AT VML Enterprise SolutionsOur Enterprise Solutions division houses strategic consultants, creative and technical architects and skilled developers and operators that together help some of the world's leading organisations to deliver outstanding digital experiences across all major routes to market worldwide: marketplaces, online retailers, D2C, B2B and social platforms. With over 4,200 experts in 55 operational centres across 34 countries, our capabilities span the entire buying journey from customer acquisition, through engagement, to conversion and loyalty, driving multi-channel growth for world-leading brands.We work with some of the most exciting brands such as The Coca-Cola Company, EY, Bosch, Unilever, Ford, DFS, Mercedes-Benz, Johnson & Johnson, Nestlé, Sainsbury's, Selfridges, Shell and Tiffany & Co. We've built over 500 platforms for brands and retailers and generate in excess of $29bn annually for our clients and work with over 50 strategic partners including Adobe, SAP, Salesforce, HCL, Shopify, Sitecore, BigCommerce, commerce tools and Acquia. Our reputation is based on our people, and we believe we have some of the best in the business.As our business grows internationally, we're looking for new people to join us on our journey to inspire and take a key role in shaping some of the best commerce solutions, services, and websites in the world. Working as a team, no problem is insurmountable; we share in our client's successes and believe that anyone can show creative bravery no matter what their role is in the team.

VML