Staff Data Engineer: Build Scalable ETL Pipelines (Remote)

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:

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