At a Glance
- Tasks: Design and build data pipelines to deliver high-quality data for analytics.
- Company: Join Sojern, a global leader in travel marketing solutions.
- Benefits: Competitive pay, stock options, flexible work, and wellness resources.
- Other info: Dynamic team culture with growth opportunities and a focus on wellbeing.
- Why this job: Make an impact in the travel industry with cutting-edge data engineering.
- Qualifications: Experience in ETL, SQL, Python, and cloud platforms required.
The predicted salary is between 60000 - 80000 £ per year.
We are searching for a talented and motivated Staff Data Engineer to join our growing data team. In this role, you will play a key role in designing, building, and maintaining data pipelines that deliver high-quality data to our data warehouse and other analytics platforms. You will work closely with data scientists, analysts, and other engineers to ensure that our data infrastructure meets the needs of the business.
What you will do:
- Design, develop, and implement scalable data pipelines using ETL (Extract, Transform, Load) processes.
- Write and execute complex SQL queries to extract and transform data from various sources.
- Develop and maintain Python scripts for data manipulation, automation, and data quality checks.
- Design and implement data models to optimize data storage and retrieval.
- Monitor and maintain the data pipelines to ensure data quality, accuracy, and timeliness.
- Collaborate with data scientists and analysts to understand data needs and develop solutions.
- Document data pipelines and processes for future reference and maintainability.
- Stay up-to-date on the latest data engineering tools and technologies.
- Attend communities of practice to keep the team up-to-date on best practices and org-wide initiatives.
- Unblock or mentor developers to keep stories moving.
- Participate in the entire Agile development lifecycle, including sprint planning, stand-ups, and retrospectives.
What you bring to the table:
- Experience in designing, developing, and implementing ETL pipelines.
- Proficiency in SQL and experience with relational databases (e.g., MySQL, PostgreSQL).
- Strong programming skills in Python, including libraries like Pandas and NumPy.
- Extensive knowledge of agile methodologies.
- Ability to work independently and as part of a team.
- Strong knowledge of cloud computing platforms, such as AWS, Azure, or Google Cloud.
- Experience with CI/CD practices for data engineering workflows.
Nice To Have:
- Experience with Google Cloud, BigQuery, CloudSQL, gGRPC, Kubernetes.
- Experience with orchestration/scheduling tools such as Apache Airflow, Prefect, or similar.
- Experience in AdTech. Knowledge about Ad networks, ad exchanges, programmatic advertising, DMPs, DSPs, Audiences, etc.
What we have for you:
- Competitive compensation packages, stock options offered to every employee, Bonusly program to reward and recognize team wins and performance, plus employees can take up to 40 hours of paid time per year to volunteer and give back to the community.
- Flexi-Friday benefit, hybrid or remote work options for most roles, time-zone friendly work hours with async collaboration.
- Team offsites planned annually, six employee resources groups, regular virtual and in office team building events, monthly company All Hands & leadership Q&As.
- PTO allowance to recharge, comprehensive healthcare options, paid parental leave (16 weeks for birthing parents; 12 weeks for non-birthing parents), retirement contributions and investment options (for applicable locations), travel benefits (hotel stay benefit & IATA membership), plus mental health, wellness & financial health resources.
- Learning & development stipend, mentorship program, career development programs, leadership training.
- Home office tech set up (laptop, monitor, keyboard, mouse), monthly internet and phone allowance, modern tools to communicate and collaborate (Slack, Google Suite).
Our Sojernista First workplace philosophy is designed to take a flexible approach, recognizing that the needs of our employees may differ depending on their role, team, or location. What does not differ is our focus on building genuine connections, increasing global collaboration, and providing programs, tools and resources centered around the needs and wellbeing of our employees, regardless if you are working in an office, hybrid, or fully remote.
About Sojern:
At Sojern, we believe in the power of travel as a way to bring the world together. It is that passion that drives Sojern to build smart digital solutions that help travel marketers reach travelers efficiently, and increase long-term growth, customer loyalty and profitability. Our customers include hotels, attractions and tourism boards, and they use the power of machine learning, data science and real-time traveler data in Sojern’s products to build direct relationships with travelers across social, mobile and the web. Now, more than ever, our thousands of customers rely on Sojern to drive visits, bookings, and ticket sales by engaging with travelers as they plan their travel.
As a globally distributed company, we are headquartered in San Francisco with employees based in 14 countries and counting. Our team is passionate about travel and the core values that define our culture: Win as a Team, Embrace Inclusion, Be Genuine, Deliver Wow, and Center Around the Customer.
Staff Data Engineer employer: Sojern
Sojern is an exceptional employer that prioritises the well-being and growth of its employees, offering competitive compensation packages, flexible work options, and a strong focus on team connection and collaboration. With a commitment to personal development through mentorship programmes and learning stipends, Sojern fosters a culture where every employee can thrive both professionally and personally, all while being part of a globally distributed team passionate about travel.
StudySmarter Expert Advice🤫
We think this is how you could land Staff Data Engineer
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, and connect with current employees at Sojern. A friendly chat can sometimes lead to job opportunities that aren't even advertised!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data pipelines, SQL queries, and Python scripts. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for those interviews! Brush up on your ETL processes, SQL, and cloud platforms. Practise common interview questions and be ready to discuss how you've tackled challenges in your previous roles.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you're genuinely interested in joining the Sojern team!
We think you need these skills to ace Staff Data Engineer
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Staff Data Engineer role. Highlight your experience with ETL processes, SQL, and Python. We want to see how your skills match what we're looking for!
Showcase Your Projects:Include any relevant projects or experiences that demonstrate your ability to design and maintain data pipelines. We love seeing real-world applications of your skills, so don’t hold back!
Be Clear and Concise:When writing your application, keep it clear and concise. Use bullet points where possible to make it easy for us to read through your qualifications and experiences quickly.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Sojern
✨Know Your ETL Inside Out
Make sure you can confidently discuss your experience with designing and implementing ETL pipelines. Be ready to share specific examples of challenges you've faced and how you overcame them, as this will show your problem-solving skills and technical expertise.
✨SQL Skills on Display
Brush up on your SQL knowledge before the interview. Prepare to write and explain complex queries on the spot. Practising with real-world data scenarios can help you articulate your thought process clearly during the interview.
✨Python Proficiency is Key
Since Python is a crucial part of the role, be prepared to discuss your experience with libraries like Pandas and NumPy. You might even be asked to solve a coding challenge, so practice writing clean, efficient code that demonstrates your understanding of data manipulation.
✨Show Your Collaborative Spirit
This role involves working closely with data scientists and analysts, so highlight your teamwork experiences. Share examples of how you've collaborated in Agile environments and how you’ve mentored others, as this will demonstrate your ability to contribute positively to the team dynamic.
