Senior Data Engineer

Posted 55mins ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Senior Data Engineer building AWS ETL/ELT pipelines and dbt models for Tango’s cloud real-estate and facilities SaaS. Managing databases, data quality, warehousing, and observability.

Responsibilities:

  • Design, build, and maintain scalable ETL/ELT pipelines using AWS-native services
  • Develop automated workflows to ingest, transform, and validate structured and semi-structured data
  • Monitor pipeline performance, reliability, and cost efficiency and implement improvements
  • Own the dbt transformation layer, including models, tests, sources, and documentation
  • Manage and optimize production Postgres and TimescaleDB databases and the Redshift OLAP warehouse
  • Implement database tuning, indexing, query optimization, schema evolution, retention, partitioning, and backup/restore strategies
  • Build automated data validation and anomaly-detection frameworks
  • Establish and enforce data quality SLAs across ingestion and reporting layers
  • Maintain metadata, lineage, and documentation standards for auditability
  • Collaborate with application engineering teams on 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

Requirements:

  • 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 Glue, Lambda, Step Functions, S3, Redshift, and RDS/Postgres
  • Hands-on experience designing, orchestrating, and performance-tuning ETL/ELT pipelines
  • Strong experience with production databases, including Postgres and TimescaleDB
  • Understanding of OLTP, OLAP/star-schema data modeling, warehousing, and analytics workloads
  • Experience with data quality frameworks, validation, and monitoring
  • Production experience with dbt, including models, tests, sources, lineage, staging/intermediate/mart layers, and CI execution
  • Experience with Git-based workflows and CI/CD for data, including pull requests, code review, and automated transformation testing
  • Applicants must be authorized to work in the U.S. for any employer
  • Employment-based visa sponsorship is unavailable
  • Preferred: experience with time-series data and high-volume ingestion pipelines
  • Preferred: background in Energy, Sustainability, or IoT data
  • Preferred: dbt Semantic Layer or comparable metrics-layer experience

Benefits:

  • Competitive compensation
  • Health insurance
  • Dental insurance
  • Vision insurance
  • 401(k) plan with company match
  • Generous paid time off
  • Fully remote work environment
  • Inclusive and collaborative culture