data engineer for business analytics

Enfint; Barcelona; Presencial; EUR 55.000 - 85.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flexible vacation

Parental leave

Wellbeing programs

Office attendance two days a week (hyb

Discounts and perks

Descripción de la vacante

The Knot Worldwide is seeking a data engineer to design, build and maintain scalable data pipelines for large datasets. You will collect, process, and analyze website behavior, customer, and transactional data using Airbyte, Python, and dbt.

Join a collaborative data team, apply dimensional modeling, develop ETL infrastructure, and mentor junior engineers while ensuring data governance and security across enterprise pipelines.

Formación

• Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related field.
• Advanced SQL and dbt modeling skills; strong Python abilities.
• Experience building data models, data pipelines, and data warehouses.

Responsabilidades

• Design, build, and maintain scalable end-to-end data pipelines for large and complex datasets.
• Collect, process, and analyze website behavior, customer, transactional, and other data using Airbyte, Python, and dbt.
• Write SQL-based data transformations and ensure data is clean and ready for analysis.
• Apply dimensional modeling techniques to design tables and views for an enterprise data model.
• Develop and support complex ETL infrastructure.
• Mentor Data Engineering team members and provide technical leadership and guidance.

Conocimientos

SQL

Python

dbt

Data modeling

Data pipelines

Cloud data integration

English

Stakeholder comms

Educación

Bachelor’s degree

Herramientas

Airbyte

Airflow

Qlik

Tableau

Power BI

Looker

Streamlit

JIRA

Descripción del empleo

Описание:

The Knot Worldwide helps people plan meaningful celebrations and supports small business owners in growing and scaling their businesses. Its data team builds data foundations that power trusted analytics, intelligent ML/AI systems, and scalable business growth.

Задачи:

• Design, build, and maintain scalable end-to-end data pipelines for large and complex datasets
• Collect, process, and analyze website behavior, customer, transactional, and other business data using Airbyte, Python, and dbt
• Write SQL-based data transformations and ensure data is clean and ready for analysis
• Apply dimensional modeling techniques to design tables and views for an enterprise data model
• Develop and support complex ETL infrastructure
• Participate in the architecture and strategy for end-to-end data pipeline deployment
• Partner with Data Platform Engineering Teams to define business logic and move data pipelines into production
• Partner with Managers and Leads to define best practices, templates, and scalable dbt code
• Improve the performance of existing models, pipelines, and data applications
• Foster data governance practices, ensure data privacy and security, and document pipelines, transformations, and models
• Understand business processes and apply this knowledge to solve problems
• Work with end users and stakeholders to understand their needs
• Provide insights and train users on Information Mart models, data applications, and actionable results
• Scope, track, execute, and communicate projects in an Agile environment
• Mentor Data Engineering team members and provide technical leadership and guidance
• Oversee top-of-funnel metrics for at least one Business Domain and maintain consistency across models and reporting

Требования:

• Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related field
• 3+ Years of experience in data model, data pipeline, data management, administration, and support
• Experience building data models, data pipelines, and data warehouses
• Advanced SQL and dbt modeling skills
• Strong Python skills
• Solid understanding of modern data engineering and architecture concepts
• Knowledge of data warehousing, data pipelines, data marts, semantic layers such as Cube, and cloud data integration
• Solid understanding of Paid Media performance metrics
• Ability to convert marketing and business process requirements into data pipeline designs and models
• Ability to work independently and collaboratively
• Strong organizational, troubleshooting, interpersonal, and communication skills
• Attention to detail and ability to detect and explain data anomalies
• Ability to explain complex data insights to non-technical stakeholders
• Fluent spoken and written English
• Nice to have: Experience with Airbyte and Airflow, Qlik, Tableau, Power BI, Looker, or Streamlit, Agile methodology, and JIRA

Условия:

• Flexible vacation
• Generous parental leave
• Mental wellbeing, physical health, and financial planning offerings
• Perks and discounts
• Employee growth, development, and wellbeing initiatives
• Office attendance two days a week as part of the hybrid work model