
Job Description
Ovii's Interpretation of the Role
We are looking for a Data Engineer to design and operate high‑performance batch and streaming pipelines, optimize ETL/ELT workflows, and manage large‑scale analytical databases. The role works closely with Product, Analytics, and Backend teams to deliver reliable data‑driven insights.
Role Snapshot
- Build batch & streaming pipelines
- Own ClickHouse analytical clusters
- Optimize SQL & ETL workloads
- Develop data models for reporting
- Collaborate across product and analytics
Must-Have Requirements
- SQL query optimization
- ClickHouse or other OLAP database
- PostgreSQL
- Java or Python programming
- Apache Kafka
- Distributed data processing frameworks
- Cloud platforms (AWS/GCP/Azure)
- Docker
- Kubernetes
- Monitoring/observability tools
- Data Engineering
- Batch and streaming pipelines
- ETL/ELT workflow development
- SQL optimization
- Cloud platform usage
Nice-to-Have Signals
- Looker or other BI platforms
- Apache Spark or Dataproc
- Airflow or other workflow orchestration tools
- Advertising technology knowledge (DSP, RTB, Attribution, Campaign Reporting)
- BI platform usage
- Large‑scale analytical systems
- Advertising technology
Work Setup
- Location: Noida, India
- Work mode: ONSITE
- Employment type: Full-Time
Not Specified in JD
- Salary range
- Visa sponsorship
- Remote eligibility
- Education requirement
- Certifications
- Relocation
- Notice period
- Travel
- Security clearance
- Coding test
- Portfolio
- GitHub
- Writing sample
- Cover letter
What You'll Likely Work On
- Design and implement scalable batch and streaming data pipelines
- Develop and tune ETL/ELT workflows using distributed processing frameworks
- Own and optimize ClickHouse clusters for large analytical workloads
- Create efficient data models for reporting and dashboarding
- Build ingestion pipelines from MongoDB, PostgreSQL, Kafka, APIs and other sources
- Improve performance of large‑scale SQL queries and analytical workloads
- Implement monitoring, health checks, and anomaly‑detection systems
- Partner with Product, Analytics, and Backend teams to deliver reliable insights
Good Fit If You Have
- Experience with cloud platforms (AWS, GCP, Azure)
- Familiarity with containerization (Docker) and orchestration (Kubernetes)
- Interest in BI tools such as Looker
Skills
- SQL & query optimization
- ClickHouse / OLAP databases
- PostgreSQL
- Java or Python
- Apache Kafka
- Distributed data processing frameworks
- Cloud platforms (AWS/GCP/Azure)
- Docker & Kubernetes
- Monitoring & observability tools