Data engineer in creative agency

We are Dragons, a global creative agency working with bold brands to build cultural relevance, connection, and long-term impact through strategy-led creativity. We are looking for a freelance Data Engineer focused on data integration to build and maintain the pipelines that connect our many source systems into a unified, trustworthy data foundation. You will design ETL/ELT processes, integrate APIs and third-party platforms, model data for reporting, and ensure data quality across the organization. This is a fully remote role working closely with analytics, finance, and engineering stakeholders.

• Design, build, and maintain scalable ETL/ELT pipelines that move and transform data between systems.
• Integrate data from diverse sources — APIs, databases, SaaS platforms, flat files, and spreadsheets — into a central warehouse.
• Develop and maintain connectors and reconciliation logic across business systems (e.g., project management, time-tracking, finance, and invoicing tools).
• Model and structure data for analytics, reporting, and downstream applications.
• Implement data validation, quality checks, monitoring, and alerting to ensure accuracy and reliability.
• Optimize queries, storage, and pipeline performance for cost and speed.
• Document data flows, schemas, mappings, and transformation logic.
• Collaborate with analysts, finance, and engineering teams to understand requirements and deliver clean, usable datasets.
• Support data governance, security, and privacy best practices.

• 3+ years of experience in data engineering, data integration, or a closely related role.
• strong SQL skills and experience with relational databases (PostgreSQL, MySQL, SQL Server).
• proficiency in Python (or a comparable language) for data processing and automation.
• hands-on experience building ETL/ELT workflows and orchestration (e.g., n8n, or similar).
• experience integrating REST APIs, webhooks, and third-party SaaS data sources.
• Experience with data warehouses (BigQuery, Snowflake, or similar).
• Understanding of data modeling, warehousing concepts, and data quality practices.
• Comfort working with messy, real-world data across formats (CSV, Excel, JSON, XML).
• Strong problem-solving skills and clear communication in a remote team.
• To be eligible for this role, you must be based in Spain or have the legal right to work in Spain.
• Будет плюсом: Experience with cloud data platforms (AWS, or Azure); Exposure to finance or operational data and cross-system reconciliation; Experience with BI/visualization tools (Looker, Power BI, Tableau); Experience in an agency or multi-entity, multi-currency environment

• 3-month part-time contract, with the possibility of extension into a permanent position based on business needs and performance.
• Fully remote working with 9 a.m. to 1 p.m. working hours.
• Exposure to high-profile global brands and varied, meaningful projects.
• Free English & Spanish classes to boost your global communication skills.
• Access to Wellhub, a wellness platform offering a wide range of fitness and wellbeing options.
• Flexible retribution plan for meals, transport and childcare.
• Holidays: 22 working days a year + 3 days established by the collective agreement + national and local public holidays.
• Bright, spacious offices in the heart of Barcelona, with unlimited premium coffee.
• Competitive pay & room to grow.
• Global playground, cutting-edge tools and trend-driven culture.