The ETL Engineer will design, develop, and optimize ETL pipelines using tools like Azure Data Factory and ClickHouse, ensuring performance and reliability while integrating data from various sources.
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.
We are targeting candidates who already have strong, hands-on experience in the following:
Nice to Have:
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, 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)
We are targeting candidates who already have strong, hands-on experience in the following:
- 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) - Programing 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)
- 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
Similar Jobs
Information Technology • Software
Contract Senior Analytics Engineer to design and build a dbt-based datamart for onboarding an MMM/incrementality vendor. Translate vendor schema to internal DTC sources, implement dbt models, tests, and docs, configure Snowflake data sharing, and manage GitLab merge request workflows.
Top Skills:
AirflowDbt CloudDbt CoreGitlabMetricflowSnowflakeSQL
Information Technology • Software
The role involves developing ETL processes using IBM InfoSphere DataStage, focusing on stored procedures and source to target mapping with Oracle.
Top Skills:
Ibm Infosphere DatastageOracle 11
Software
The ETL Developer will analyze data, create migration paths, develop standard queries, document processes, and ensure data quality. They must also support transitions and understand business needs.
Top Skills:
ETLInformaticaMs Office SuitePentahoSalesforceSQL
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
