Join Our Team as a Staff Data Engineer

Are you a talented and motivated data engineer looking for a new challenge? We are expanding our data team and looking for someone to take on the role of Staff Data Engineer. In this key position, you will be responsible for designing, building, and maintaining data pipelines that deliver high-quality data to our warehouse and other analytics platforms. You will collaborate closely with data scientists, analysts, and other engineers to ensure our data infrastructure meets business needs.

Key Responsibilities

As a Staff Data Engineer, you will:

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

Required Qualifications

To excel in this role, you should have:

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

Preferred Qualifications

It’s a bonus if you also have:

• Experience with Google Cloud, BigQuery, CloudSQL, gGRPC, Kubernetes.
• Experience with orchestration/scheduling tools such as Apache Airflow, Prefect, or similar.
• Experience in AdTech, including knowledge of ad networks, ad exchanges, programmatic advertising, DMPs, DSPs, audiences, etc.

What We Offer

At Sojern, we focus on creating an enriching experience for our employees. As part of our team, you will enjoy:

• Rewards & Recognition: Competitive compensation, stock options, Bonusly program, and 40 hours of paid volunteer leave.
• Flexibility: Flexi-Friday benefit, hybrid or remote work options, and time-zone friendly work hours.
• Connection: Annual team offsites, six employee resource groups, regular team-building events, monthly all-hands meetings.
• Wellbeing: PTO, comprehensive healthcare, paid parental leave, retirement contributions, travel benefits, mental health, wellness, and financial health resources.
• Growth: Learning and development stipend, mentorship programs, career and leadership training.
• Productivity: Home office tech setup, monthly internet and phone allowance, modern communication and collaboration tools (Slack, Google Suite).

About Sojern

Sojern harnesses the power of travel to bring the world together. We are driven by a passion to build smart digital solutions that help travel marketers reach travelers efficiently, fostering long-term growth, customer loyalty, and profitability. Our clients include hotels, attractions, and tourism boards who leverage our machine learning, data science, and real-time traveler data to engage with travelers at every stage of their journey.

Headquartered in San Francisco, Sojern is a globally distributed company with team members in 14 countries. Our culture is defined by