Description:

Join Terrascope on a mission to reverse the impact of climate change by empowering corporations to decarbonize their operations, portfolios, and supply chains.
The Senior Data & Analytics Engineer will design and implement scalable data architectures for SaaS platforms in both single-tenant and multi-tenant environments.
This role will leverage the AWS Data Engineering stack, Postgres, and advanced analytics processing techniques, including the creation of materialized views for high-volume data analytics.
The position is 100% hands-on, focusing on building a robust and scalable data platform to support seamless data onboarding and management for a SaaS platform.
Responsibilities include designing scalable data platforms, optimizing materialized views, developing data migration scripts, and writing clean code in Python, Java, or Go.
The engineer will process large-scale datasets, optimize Postgres databases, implement best practices for scaling analytics solutions, and ensure data integrity and consistency.
The role requires collaboration with product, engineering, and data science teams to align platform capabilities with analytics and machine learning requirements.
The engineer will manage and scale AWS infrastructure and automate workflows using the GitHub DevOps stack.

Requirements:

A Bachelor’s degree in a STEM field is required.
Candidates should have 5 to 8 years of extensive experience as a Data and Analytics engineer building data platforms for SaaS applications.
Experience in database migration projects and building or migrating multi-tenant database projects is essential.
Deep competence in Python scripting for writing ETL pipelines and automating AWS tasks is required.
Proficiency in Java or Go for building high-performance tools is necessary.
Candidates must have deep competence in data storage and management using AWS RDS (Postgres), S3, and Document DB.
A strong understanding of Postgres database architecture, including indexes and query optimization, is required.
Advanced SQL skills to design complex queries for materialized views are necessary.
Experience with AWS Glue, Lambda, Step functions, and AWS data migration service is required.
Candidates should have experience in data processing and analytics using AWS Athena and AWS Redshift.
Knowledge of security and monitoring using AWS IAM, CloudWatch, and CloudTrail is essential.
Experience in mapping between MongoDB’s flexible schema and Postgres' relational schema is preferred.
Proven experience with scalable, large data sets and high-performance SaaS applications is required.
Strong problem-solving skills, excellent programming skills, and a collaborative team player attitude are essential.
Familiarity with the Rust programming language and an entrepreneurial mindset are considered a plus.

Terrascope is committed to creating an inclusive environment for a strong and diverse team.
The company values diversity and fosters a community where everyone can be their authentic self.
Employees will have the opportunity to work on impactful projects that contribute to climate action and sustainability.
The role offers the chance to collaborate with a talented team and mentor peers while sharing best practices.
Employees will be part of a venture backed by one of the world’s largest food and agri companies, providing a unique strategic advantage and secure funding.