MedReview is looking for a hands-on ETL Engineer who knows how to build, optimize, and scale data pipelines in a high-performance environment.
Requirements
- Building and maintaining scalable ETL pipelines
- Design and develop ETL pipelines using SSIS, Azure Data Factory, and Databricks
- Building and optimizing ClickHouse ingestion pipelines (batch + streaming)
- Developing transformations for structured and semi-structured data
- Optimizing SQL Server and ClickHouse queries for performance and scalability
- Improving data models, partitions, and materialized views in ClickHouse
- Integrating data from multiple sources (APIs, SQL Server, cloud storage, Kafka/Event Hubs)
- Monitoring pipeline performance and ensuring low latency + high reliability
- Implementing data quality checks, error handling and lineage tracking
- Partnering with BI teams to support dashboards (Power BI, etc)
Benefits
- Generous Paid Time Off
- 401k Matching
- Retirement Plan
- Four Day Work Week