Senior Data Engineer
Posted 55mins ago
Employment Information
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
















