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.
- 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
- 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.
- 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.
We take a whole-person approach to create a that allows our people to thrive, not just as employees, but as humans. As an employee of Sojern, you would benefit from this in the following ways:
- 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 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.
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. Check out our Glassdoor reviews!
US Roles at Sojern based outside of our Omaha, NE or San Francisco, CA office can sit in any of the following states: AZ, CA, CO, CT, FL, GA, IL, IN, IA, KS, MA, MI, MN, MO, NE, NJ, NY, NC, PA, SD, TN, TX, UT, WA, and WI. Please only apply if you are able to live and work full-time in one of the states listed above. State locations and specifics are subject to change as our hiring requirements shift.
All candidates offered employment by Sojern may be subject to pre-employment requirements, including but not limited to a background check. Sojern is compliant with all federal and local laws with consideration to pre-employment requirements.
At Sojern, we work to create a brave space that seeks out, embraces, and promotes diverse thoughts, beliefs, and experiences of Sojernistas globally.
We are building a workforce that represents the customer base we are serving and the world we live in. A diversified workforce is an innovative workforce. Just as there is no one typical traveler, there is no one typical employee. We foster diversity and inclusion across the company, actively seeking to amplify underrepresented voices and apply diverse perspectives to ensure products, policies, and programs are relevant for our employees and clients alike.
Embracing our differences and celebrating them moves us towards our goal of making travel inclusive of all. Sojern’s S-Groups (employee resource groups) are a core aspect of our culture, fostering belonging and connection, inspiring learning, and creating opportunities for all Sojernistas across the globe.
- Supporting, developing, and empowering those who identify as women at Sojern
- Celebrating Sojern’s LGBTQIA+ community while creating an inclusive and safe space for community members
- Advocating for balance in life and overall wellbeing and providing space and resources for Sojernistas with different needs
- Creating space, connection and resources for Sojern’s young and rising professionals
- Helping families thrive with our community of parents and caregivers
- Supporting underrepresented communities and social causes, striving to make a global and local impact
We also have employee-run Slack channels for those with specific interests, for example plant lovers, pets and more.
Top Skills
What We Do
Sojern is built on more than a decade of expertise analyzing the complete traveler path to purchase. We drive travelers from dream to destination by activating multi-channel branding and performance solutions on the Sojern Traveler Platform for more than 10,000 travel companies around the globe.
Why Work With Us
Beyond the excellent health benefits and retirement savings options, we want our employees to enjoy what our business is built on: travel. We want them to experience new cultures and continents, or just enjoy more local pleasures that enrich their daily lives. As the saying goes, “Travel is an investment in yourself.”
Gallery
![Gallery](https://cdn.builtin.com/cdn-cgi/image/f=auto,fit=crop,w=255,h=145/https://builtinsf.com/sites/www.builtinsf.com/files/2023-04/sojern1.jpeg)
![Gallery](https://cdn.builtin.com/cdn-cgi/image/f=auto,fit=crop,w=255,h=145/https://builtinsf.com/sites/www.builtinsf.com/files/2023-04/sojern2.jpeg)
![Gallery](https://cdn.builtin.com/cdn-cgi/image/f=auto,fit=crop,w=255,h=145/https://builtinsf.com/sites/www.builtinsf.com/files/2023-04/sojern3.jpeg)
![Gallery](https://cdn.builtin.com/cdn-cgi/image/f=auto,fit=crop,w=255,h=145/https://builtinsf.com/sites/www.builtinsf.com/files/2023-04/sojern4.jpeg)
![Gallery](https://cdn.builtin.com/cdn-cgi/image/f=auto,fit=crop,w=255,h=145/https://builtinsf.com/sites/www.builtinsf.com/files/2023-04/sojern5.jpeg)
![Gallery](https://cdn.builtin.com/cdn-cgi/image/f=auto,fit=crop,w=255,h=145/https://builtinsf.com/sites/www.builtinsf.com/files/2023-04/sojern6.jpeg)
![Gallery](https://cdn.builtin.com/cdn-cgi/image/f=auto,fit=crop,w=255,h=145/https://builtinsf.com/sites/www.builtinsf.com/files/2023-04/sojern7.jpeg)
![Gallery](https://cdn.builtin.com/cdn-cgi/image/f=auto,fit=crop,w=255,h=145/https://builtinsf.com/sites/www.builtinsf.com/files/2023-04/sojern8.jpeg)
![Gallery](https://cdn.builtin.com/cdn-cgi/image/f=auto,fit=crop,w=255,h=145/https://builtinsf.com/sites/www.builtinsf.com/files/2023-04/sojern9.jpeg)
![Gallery](https://cdn.builtin.com/cdn-cgi/image/f=auto,fit=crop,w=255,h=145/https://builtinsf.com/sites/www.builtinsf.com/files/2023-04/sojern10.jpeg)
Sojern Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
Sojern supports employees who want to work in an office, remote or something in the middle. We have big goals for growth and want a team of dedicated, diverse employees to help us achieve that vision—no matter where they are logging in for the day.