Senior Data Engineer

Locatee; United States; Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Competitive Compensation

Comprehensive Benefits

Flexible Work Environment

Inclusive & Collaborative Culture

Job summary

Tango is seeking a Senior Data Engineer to join its data engineering team in the US. You will design and maintain scalable ETL/ELT pipelines using AWS-native services, own the dbt transformation layer, and optimize our data warehouse stack (Redshift, Postgres, TimescaleDB).

You will ensure data quality with automated validation, monitor pipeline costs, and collaborate with product and analytics teams to deliver high-performance datasets.

Qualifications

• 5+ years of professional experience as a Data Engineer or similar role.
• Strong proficiency with Python and SQL and modern data engineering frameworks.
• Deep experience with AWS data services (Glue, Lambda, Step Functions, S3, Redshift, RDS/Postgres).
• Hands-on experience designing ETL/ELT pipelines, orchestration, and tuning.
• Experience with production databases (Postgres, TimescaleDB, etc).
• Solid understanding of data modeling (OLTP/OLAP, star schema) and warehousing.
• Experience with data quality frameworks, validation, and monitoring.
• Production experience with dbt: models, tests, sources, CI workflows.

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines using AWS-native services.
• Develop automated workflows to ingest, transform, and validate large volumes of data.
• Monitor pipeline performance, reliability, and cost efficiency; implement improvements.
• Own the transformation layer in dbt and ensure dataset validation against sources.
• Manage and optimize production databases and data warehouse.
• Implement database performance tuning, indexing, and schema evolution best practices.
• Oversee data retention, partitioning, and backups.
• Build automated data validation frameworks and anomaly detection.
• Establish data quality SLAs across ingestion and reporting layers.
• Maintain metadata, lineage, and documentation for auditability.
• Collaborate with engineering teams on APIs and data contracts.
• Support analytics teams with curated datasets and high-performance queries.
• Troubleshoot production issues and improve observability.

Skills

Python

SQL

AWS

dbt

ETL/ELT

Data modeling

CI/CD

Git

Tools

dbt

Git

CI/CD

Job description

*Applicants must be authorized to work in the U.S. for any employer.

*We cannot sponsor employment-based visas at this time.

About The Company:

With hundreds of customers across more than 140 countries, Tango is the leader in cloud-based Software-as-a-Service (SaaS) solutions use to manage the end-to-end real estate and facilities lifecycles. Tango’s Store Lifecycle Management and Integrated Workplace Management System software, deliver a single solution spanning real estate, design & construction, lease administration & accounting, facilities maintenance, occupancy management, energy & sustainability, desk booking, visitor and space management.
We are looking for a Senior Data Engineer to join our dynamic and growing Data Engineering team.

Key Responsibilities:

• Design, build, and maintain scalable ETL/ELT pipelines using AWS-native services (Glue, Lambda, Step Functions, S3).
• Develop automated workflows to ingest, transform, and validate large volumes of structured and semi-structured data.
• Monitor pipeline performance, reliability, and cost efficiency; implement proactive improvements.
• Own the transformation layer in dbt: models, tests, sources, and documentation. Every dataset that reaches the warehouse is modeled in dbt and validated against source.
  Database & Warehouse Management
• Manage and optimize production databases (Postgres, TimescaleDB) and our OLAP data warehouse (Redshift, etc).
• Implement database performance tuning, indexing strategies, query optimizations, and schema evolution best practices.
• Oversee data retention, partitioning, and backup/restore strategies.
  Data Quality & Governance
• Build automated data validation frameworks and anomaly detection, anchored in dbt tests and source-reconciliation checks..
• Establish and enforce data quality SLAs across ingestion and reporting layers.
• Maintain metadata, lineage, and documentation standards to support auditability (SOC 1/2, ISO).
  Cross-Functional Collaboration
• Work with application engineering teams to design APIs, microservices, and data contracts.
• Support Product and Data Analytics teams with curated datasets and high-performance query patterns.
• Troubleshoot production issues and improve observability using monitoring and alerting tools (CloudWatch, Datadog, etc.).

Required Skills:

Required

• 5 years of professional experience as a Data Engineer or similar role.
• Strong expertise with Python and SQL, and modern data engineering frameworks.
• Deep experience with AWS data services (Glue, Lambda, Step Functions, S3, Redshift, RDS/Postgres).
• Hands-on experience with ETL/ELT pipeline design, orchestration, and performance tuning.
• Strong experience with production databases (Postgres, TimescaleDB, etc).
• Solid understanding of data modeling (OLTP, OLAP/star schema), warehousing, and analytics workloads.
• Experience with data quality frameworks, validation, and monitoring.
• Production experience with dbt: building and testing models, managing sources and lineage, structuring a project across staging/intermediate/mart layers and running it in CI.
• Experience with Git-based workflows and CI/CD for data: pull requests, code review and automated testing of transformations.
  Preferred
• Experience with time-series data and high-volume ingestion pipelines.
• Background in the Energy, Sustainability, or IoT data domain.
• dbt Semantic Layer or comparable metrics-layer experience (Cube, LookML, Omni semantic models).

++What We Offer++

We’re committed to creating an environment where you can thrive—professionally and personally. Our offerings include:

• Competitive Compensation We recognize and reward your contributions with a salary package that reflects your value.
• Comprehensive Benefits Including health, dental, and vision insurance, a 401(k) plan with company match, and generous paid time off to support your well-being.
• Flexible Work EnvironmentWhether remote, hybrid, or in-office, we support work arrangements that promote productivity and balance.
• Inclusive & Collaborative Culture We foster a workplace where diverse perspectives are valued, teamwork is encouraged, and everyone has a voice.

Tango is proud to be an equal opportunity employer. We are committed to equal opportunity regardless of race, ethnicity, religion, parental status, sexual orientation, age, citizenship, disability, or veteran status.