Staff Data Engineer Job Opportunity at Sojern

Are you a talented and motivated data engineer looking to make a significant impact? Sojern is searching for a dedicated Staff Data Engineer to join our growing data team. This role is crucial for designing, building, and maintaining data pipelines that deliver high-quality data to our data warehouse and other analytics platforms. You will closely collaborate with data scientists, analysts, and other engineers to ensure our data infrastructure meets business needs.

Role 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 updated on the latest data engineering tools and technologies.
• Attend communities of practice to keep the team updated on best practices and org-wide initiatives.
• Unblock or mentor developers to maintain story progression.
• Participate in the Agile development lifecycle, including sprint planning, stand-ups, and retrospectives.

Qualifications

Essential Skills

• 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, gRPC, Kubernetes.
• Experience with orchestration/scheduling tools like Apache Airflow, Prefect, or similar.
• Experience in AdTech, including knowledge about Ad networks, ad exchanges, programmatic advertising, DMPs, DSPs, Audiences, etc.

Benefits & Perks

At Sojern, we embrace a whole-person approach to create an enriching experience for our Sojernistas. Our employees benefit from:

Rewards & Recognition

• Competitive compensation packages and stock options for every employee.
• Bonusly program to reward and recognize team wins and performance.
• Up to 40 hours of paid time for community volunteer activities.

Flexibility

• Flexible Fridays and hybrid or remote work options for most roles.
• Time-zone friendly work hours with asynchronous collaboration.

Connection

• Annual team offsites and six employee resource groups.
• Regular team-building events, both virtual and in-office.
• Monthly company All Hands & leadership Q&As.

Wellbeing

• PTO allowance to recharge and 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 including hotel stays and IATA membership.
• Mental health, wellness, and financial health resources.

Growth

• Learning & development stipend, mentorship program, and career development programs.
• Leadership training to foster professional growth.

Productivity

• Home office tech setup including a laptop, monitor, keyboard,