How Remoteville checks and expires listings
What the job involves
The main requirements, responsibilities and hiring steps.
Requirements
- 4+ years of data engineering or related experience with SQL as a core skill
- Expertise in complex production-grade SQL including window functions recursive CTEs lateral joins and advanced aggregations
- Proven query optimization experience using execution plans bottleneck analysis and performance tuning
- Hands-on experience with AWS data services especially Aurora Redshift Athena and S3
- Experience building scalable ELT ETL pipelines with SQL transformation at the core
- Proficiency in dbt for transformation testing and documentation
- Experience with Python for orchestration and data processing
- Familiarity with Airflow or AWS MWAA
- Understanding of data quality access control and governance
- Experience in GitLab or similar CI CD environments
Nice to have
- Healthcare experience
- Clinical trials exposure
- AWS certification
- Terraform knowledge
- Streaming pipeline exposure
Day to day
- Write and optimize complex SQL across large clinical datasets on AWS.
- Build and support SQL-driven ELT and ETL pipelines using dbt and AWS services.
- Partner with technical and clinical teams to deliver reliable data products reporting and governance.