Staff Data Engineer

extra holidays - fully flexible
Remote: 
Full Remote
Contract: 
Work from: 

Offer summary

Qualifications:

10+ years of hands-on experience in data engineering and building scalable data systems., 4+ years of experience with DBT for managing transformation pipelines in cloud data warehouses., 5+ years of experience with Redshift, including management and optimization., Advanced SQL skills and a deep understanding of data warehousing principles..

Key responsabilities:

  • Design and implement scalable data pipelines using tools like Fivetran, Airbyte, or Python.
  • Oversee the management and optimization of the Redshift data warehouse.
  • Continuously monitor data pipelines to ensure uptime and data quality.
  • Collaborate with cross-functional teams to address data engineering needs and deliver solutions.

Swapcard logo
Swapcard Information Technology & Services SME https://www.swapcard.com
51 - 200 Employees
See all jobs

Job description

Our Mission
Swapcard is the leading AI-powered event platform designed to drive revenue growth and foster meaningful connections at in-person and hybrid events. We recognize the importance of teamwork in successful events; that's why Swapcard is fueled by a team of innovators who are passionate about helping organizers build future-proof events.

Our Vision
At Swapcard, we believe in the power of meaningful connections. This belief fuels our commitment to pioneering modern solutions that empower organizers to create engaging event experiences.
Guided by our commitment to excellence and collaboration, we aim to redefine the landscape of event technology, setting new standards for engagement, accessibility, and impact.

Our Beliefs
At Swapcard, diversity is at the core of our success. With 42 nationalities represented among our 180+ team members, we champion diversity as a catalyst for creativity, collaboration, and unparalleled innovation.

We believe that by embracing a multitude of backgrounds, cultures, and viewpoints, we can truly understand and cater to the needs of our global community of event organizers and participants.
Our full remote opportunities empower our team to thrive, no matter where they are in the world, fostering a culture of flexibility and inclusion.

As the Staff Data Engineer, you will play a pivotal role in designing and building robust, efficient data pipelines to process large volumes of data from internal databases and SaaS applications.

You will be responsible for:
Designing and implementing data pipelines: Build scalable and maintainable data pipelines using tools such as Fivetran, Airbyte, or Python, ensuring that data is efficiently moved from various sources to our cloud data warehouse.
Data transformation and modeling: Develop and optimize transformation models using tools like DBT, Redshift, and Dagster, ensuring high-quality and timely data for analysis.
Cloud Data Warehouse Management: Oversee the management and optimization of our Redshift data warehouse, ensuring smooth operations and data integrity.
Monitoring and troubleshooting: Continuously monitor the data pipelines and infrastructure, ensuring uptime, quality, and the timely availability of data for decision-making.
Team Collaboration: Collaborate cross-functionally with stakeholders (ML team, Infra team, Growth team, ...), and business teams to address their data engineering needs and deliver impactful solutions.
Setting Data Engineering Standards: Define, enforce, and improve data engineering standards, best practices, and processes across the organization.
Documentation: Create and maintain detailed documentation for pipelines, data models, and architecture to ensure transparency and knowledge sharing within the team and organization.




What You Should Have:
  • 10+ years of hands-on experience in data engineering, building scalable and reliable data systems in production environments.
  • 4+ years of experience with DBT, implementing, optimizing, and managing transformation pipelines in DBT for cloud data warehouses.
  • 5+ years of experience with Redshift, managing, optimizing, and troubleshooting Redshift in AWS.
  • Advanced SQL skills and a deep understanding of data warehousing principles, including performance tuning, indexing, partitioning, and query optimization.
  • Proven experience in ETL processes, from extracting data from various sources, transforming it, and loading it into cloud-based data warehouses.
  • Experience with data orchestration tools such as Airflow, Dagster, or Prefect, to design and manage data workflows.
  • Hands-on experience with Python for building custom data processing scripts and automation.
  • Data Governance: Establish and enforce data governance standards across the organization, ensuring data quality, consistency, security, and compliance. Collaborate with data privacy and legal teams to ensure that all data practices meet regulatory requirements.
  • Setting Data Engineering Standards: Define, enforce, and improve data engineering standards, best practices, and processes across the organization.
  • Fluency in English (both written and verbal).

  • Bonus Points:
  • Experience working with other AWS services such as S3, Lambda, etc.
  • Expertise in Dagster as an orchestration tool for data workflows.Experience with data visualization tools like Tableau, helping to bridge the gap between engineering and business teams.
  • Experience with Infra tools such as Docker, Terraform, and Helm, enhancing the scalability and portability of our data infrastructure.

  • Swapcard’s Interview process
    Our thorough interview process aims to identify exceptional talent to advance our mission while offering you a chance to explore your career potential at Swapcard.

    1. Screening Interview with a recruiter from our people team.
    2. A remote exercise to demonstrate and assess your skills.
    3. Manager review with your future reporting manager
    4. Leadership review with one of our department leaders
    5. Reference check conducted by our people team
    6. Offer

    Swapcard's Values
    🧠 Curious: We ask questions and try new things. We embrace new experiences and love to learn from others. We are curious about what something is and WHY something is.
    👽 Open-minded: We welcome change as well as ideas and feedback from others. We welcome people as they are and learn from each other's personal and professional experiences.
    ❤️ Human: No masking who we are. Empathy encourages a down-to-earth environment where we all feel comfortable and free to be human. Creating bonds makes it easier to share ideas, give feedback, and ask for help.
    ✊ Resilient: Our challenges in life have only made us stronger and wiser. We prefer the term “experiment” over “failure” because we always keep trying. We are solution-oriented and find innovative approaches to succeed.
    🏅 Ambitious: Nothing is impossible. We're always striving to get better, seize opportunities, and reach the top. We are encouraged to dream big and believe in ourselves.

    Benefits & Reasons to Join Swapcard
     - International team with 40+ nationalities (more on the way!) 🌍
    - Remote-first policy with headquarters in Paris 🗼
    - Thriving startup with career growth opportunities 🪴
    - Open-minded culture that appreciates differences 👽
    - Feedback-driven, supportive & curious team with a DIY mindset 🤔 🛠
    - Generous Paid Time Off to ensure you have time for what matters most ❤️🏡
    - Remote perks designed to optimize your working experience 🎁
    - In-person social gatherings to celebrate our achievements 🏝️
    - 100% of your health insurance contribution paid by Swapcard 🏥
    - Work-from-home budget (one-off contribution for equipment in addition to your initial equipment setup) 🖇️
    - Co-working space budget to support remote work in professional environments 💼
    - Learning budget to help you develop new and existing skills 🤓
    - Mental health care initiatives to support your well-being 🧘

    Equal Opportunity
    Swapcard is committed to upholding equal employment practices and making merit-based employment decisions. We welcome individuals from all backgrounds, abilities, and experiences to apply, regardless of race, nationality, religion, sexual orientation, gender identity, pregnancy status, age, marital status, and status as a veteran


    Required profile

    Experience

    Industry :
    Information Technology & Services
    Spoken language(s):
    English
    Check out the description to know which languages are mandatory.

    Data Engineer Related jobs