ETL Engineer

Job description

Position Summary: MedReview is looking for a hands-on ETL Engineer who knows how to build, optimize, and scale data pipelines in a high-performance environment. This is not an entry-level role. You will be working with modern data tools and large datasets, with a strong focus on ClickHouse, SQL performance, and real time data processing. If you're someone who can take ownership of data pipeline end-to-end and thrives in a fast-paced data-driven environment, this role is for you. This is an on-site role Monday - Thursday with remote Fridays. Candidates must be able to consistently work on-site. No exceptions. Salary $120-130K Responsibilities: You will be responsible for building and maintaining scalable ETL pipelines that power analytics and business intelligence. - Design and develop ETL pipelines using SSIS, Azure Data Factory, and Databricks - Build and optimize ClickHouse ingestion pipelines (batch + streaming) - Develop transformations for structured and semi-structured data - Optimize SQL Server and ClickHouse queries for performance and scalability - Improve data models, partitions, and materialized views in ClickHouse - Integrate data from multiple sources (APIs, SQL Server...