This is a senior data infrastructure role focused on building and optimizing ingestion and transformation pipelines in AWS, moving data from Microsoft SQL Server into Redshift using AWS DMS and Change Data Capture (CDC). If you love throughput, reliability, and clean data movement at scale, this is right in your lane.
About ECP
ECP is a SaaS platform for senior living communities, trusted by 8,000+ communities worldwide. They’re growing their products and customer base and building out data infrastructure to support enterprise-scale analytics.
Schedule
- Full time
- Remote (U.S. candidates)
What You’ll Do
- Design, build, and maintain ingestion pipelines from Microsoft SQL Server to AWS Redshift using AWS DMS and CDC
- Architect scalable, fault-tolerant workflows to ensure data quality, low latency, and consistent performance
- Build automation/frameworks to speed up onboarding new databases into the data platform
- Partner with data analysts, app developers, and DevOps to keep data available and accurate across systems
- Implement monitoring, alerting, and recovery for large-scale data movement pipelines
- Optimize AWS DMS configs, Redshift performance, and SQL Server CDC processes for throughput and efficiency
- Manage and tune replication strategies for high volume and concurrency
- Support compliance with data security, privacy, and healthcare standards
- Document architecture, workflows, configs, and SOPs
- Stay current on AWS data services and modern platform best practices
What You Need
- 5+ years in data engineering/data platform work in large-scale, distributed environments
- Strong Microsoft SQL Server expertise (CDC, replication, performance tuning, query optimization)
- Strong AWS data services experience (DMS, Redshift, S3, Glue, Lambda, CloudWatch)
- ETL/ELT pipeline experience at scale (DBT mentioned)
- Python (or similar scripting) for automation and transformations
- Infrastructure as Code familiarity (Terraform, CloudFormation) and CI/CD practices
- Strong understanding of data modeling, schema evolution, and data lineage
- Strong communication and documentation skills
- Bachelor’s degree in CS/Engineering/IS or equivalent experience
- Authorized to work in the U.S. without sponsorship
This one screams “build the plumbing that everybody forgets about until it breaks.” If you’re the type who likes being the reason the dashboards don’t lie, you’ll be valuable fast.
Happy Hunting,
~Two Chicks…