Staff Data Engineer

Position summary:

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:

Essentials

• 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:

We take a whole-person approach to create a Sojernista Experience 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:

• Rewards & Recognition: 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
• Flexibility: Flexi-Friday benefit, hybrid or remote work options for most roles, time-zone friendly work hours with async collaboration
• Connection: Team offsites planned annually, six employee resources groups, regular virtual and in office team building events, monthly company All Hands & leadership Q&As
• Wellbeing: 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
• Growth: Learning & development stipend, mentorship program, career development programs, leadership training
• Productivity: 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. Check out our Glassdoor reviews

Hiring Locations:

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.

CA residents: For information on the personal information that Sojern collects when you apply for this job, and how that information is handled, please see the Sojern Privacy Policy.

#LI-Remote

#LI-RC1

Disclosure - Pre-Employment Requirements:

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.

Our Commitment to Diversity Equity and Inclusion:

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.

• SoEmpowered: Supporting, developing, and empowering those who identify as women at Sojern
• SoProud: Celebrating Sojern's LGBTQIA+ community while creating an inclusive and safe space for community members
• SoWell: Advocating for balance in life and overall wellbeing and providing space and resources for Sojernistas with different needs
• SoConnected: Creating space, connection and resources for Sojern's young and rising professionals
• Parents & Caregivers: Helping families thrive with our community of parents and caregivers
• Sojern Gives Back: 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.

At Sojern, we value diversity and always treat all employees and job applicants based on merit, qualifications, competence, and talent. We do not discriminate on the basis of race, religion, color, national origin, gender, gender orientation, sexual orientation, age, marital status, veteran status, or disability status.

Sojern is committed to providing reasonable accommodation for individuals with disabilities. Please inform your TA Partner if you are requesting a reasonable accommodation.