Sojern is hiring a
Staff Data Engineer

Summary

Join our growing data team as a Staff Data Engineer and play a key role in designing, building, and maintaining data pipelines that deliver high-quality data to our data warehouse and other analytics platforms.

Requirements

• 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

Responsibilities

• 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

Preferred Qualifications

• 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

Benefits

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