ETL Engineer

MedReview; New York (NY); Hybrid; USD 120,000 - 130,000; Full time

Job summary

A leading data solutions company is seeking an experienced ETL Engineer to design and optimize data pipelines using tools like Azure Data Factory and ClickHouse. This role requires proficiency in SQL and a strong understanding of data processing workflows. Candidates should be able to work on-site Monday to Thursday with remote Fridays. The position offers a competitive salary range of $120-130K and a fast-paced environment that emphasizes data quality and scalability.

Qualifications

• 5+ years of experience with ETL tools and data pipelines.
• Strong SQL skills for optimizing and troubleshooting queries.
• Experience with ClickHouse and cloud environments, preferably Azure.

Responsibilities

• Design and develop ETL pipelines using various tools.
• Build and optimize ClickHouse ingestion pipelines.
• Integrate data from multiple sources including APIs and cloud storage.

Skills

Azure Data Factory

SSIS

Databricks

SQL optimization

ClickHouse

Python

Scala

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

• 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, cloud storage, Kafka/Event Hubs)
• Monitor pipeline performance and ensure low latency + high reliability
• Implement data quality checks, error handling and lineage tracking
• Partner with BI teams to support dashboards (Power BI, etc)

Must-Haves (Non-Negotiables)

• ETL tools: Azure Data Factory, SSIS, Databricks
• Strong SQL skills (writing, optimizing, and troubleshooting complex queries)
• Experience working with ClickHouse (schema design, ingestion, optimization)
  Experience with cloud environments (Azure perferred)
• Programming in Python or Scala for data processing

Nice to Have

• Experience with streaming data (Kafka, Event Hubs)
• Exposure to big data frameworks
• Understanding of DevOps/Data pipeline deployment practices
• Experience supporting BI tools (Power BI, Tableau)

What Success Looks Like

• You can independently build and optimize ETL pipelines
• You understand how to make data systems faster, cleaner, and scalable
• You're comfortable working across engineering, analytics, and business teams
• You proactively identify performance issues and fix them