DATA Engineer (Analytics & DATA Modeling)

Avenoir Technologies

Delhi

Hybrid

INR 1,620,000 - 1,980,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

PF/EPF

Job summary

Avenoir Technologies in Delhi is seeking an experienced Data Engineer with strong SQL, ETL/ELT development, data warehousing, and data modeling expertise to design scalable data pipelines and analytical models for business intelligence and reporting.

The role involves building and optimizing data models, ensuring data quality, collaborating with BI and analytics teams, and delivering reliable data solutions on cloud platforms.

Qualifications

  • 5+ years of experience in Data Engineering, Analytics, or Data Modeling.
  • Strong hands-on experience in SQL and database development.
  • Experience in ETL/ELT development and data pipeline management.
  • Good understanding of Data Warehousing and Dimensional Data Modeling.
  • Knowledge of Star Schema, Snowflake Schema, Fact and Dimension tables.
  • Experience in data transformation, data integration, and data validation.
  • Hands-on experience with Python/PySpark for data processing.

Responsibilities

  • Design, develop, and maintain scalable ETL/ELT pipelines and data workflows.
  • Build and optimize data models to support analytics and reporting requirements.
  • Perform data extraction, transformation, integration, and validation.
  • Develop complex SQL queries and optimize database performance.
  • Implement dimensional data models using Star Schema and Snowflake Schema.
  • Work on data warehousing concepts, data integration, and transformation processes.
  • Ensure data quality, consistency, and accuracy across data platforms.
  • Collaborate with BI, analytics, and business teams to understand data requirements.
  • Troubleshoot pipeline issues and improve data processing performance.

Skills

SQL
ETL/ELT
Data modeling
Data warehousing
Python/PySpark

Tools

Azure Data Factory
Databricks
ADLS
Synapse
AWS Glue

Job description

DATA ENGINEER (ANALYTICS & DATA MODELING)

Experience: 5+ Years
Maximum CTC: 18 LPA
Role: Data Engineer Analytics & Data Modeling

PF: Mandatory (Candidates must have a valid PF/UAN history)

Job Summary

We are looking for an experienced Data Engineer with strong expertise in SQL, ETL/ELT development, Data Warehousing, and Data Modeling. The ideal candidate should have hands-on experience in building scalable data pipelines, developing analytical data models, and delivering reliable data solutions for business intelligence and reporting.

Key Responsibilities
  • Design, develop, and maintain scalable ETL/ELT pipelines and data workflows.
  • Build and optimize data models to support analytics and reporting requirements.
  • Perform data extraction, transformation, integration, and validation.
  • Develop complex SQL queries and optimize database performance.
  • Implement dimensional data models using Star Schema and Snowflake Schema.
  • Work on data warehousing concepts, data integration, and transformation processes.
  • Ensure data quality, consistency, and accuracy across data platforms.
  • Collaborate with BI, analytics, and business teams to understand data requirements.
  • Troubleshoot pipeline issues and improve data processing performance.
Mandatory Skills
  • 5+ years of experience in Data Engineering, Analytics, or Data Modeling.
  • Strong hands-on experience in SQL and database development.
  • Experience in ETL/ELT development and data pipeline management.
  • Good understanding of Data Warehousing and Dimensional Data Modeling.
  • Knowledge of Star Schema, Snowflake Schema, Fact and Dimension tables.
  • Experience in data transformation, data integration, and data validation.
  • Hands-on experience with Python/PySpark for data processing.
Preferred Skills
  • Experience with cloud data platforms such as Azure, AWS, or GCP.
  • Exposure to Azure Data Factory, Databricks, ADLS, Synapse, or AWS Glue.
  • Knowledge of Snowflake, Redshift, or other cloud data warehouses.
  • Familiarity with Power BI, Tableau, or other BI/reporting tools.
  • Understanding of data governance, metadata management, and data quality practices.
Candidate Profile
  • Candidates with strong Data Engineering and Analytics backgrounds.
  • Must have practical experience developing and maintaining ETL/ELT pipelines.
  • Should possess strong SQL querying and optimization skills.
  • Experience in designing and implementing analytical and dimensional data models.
  • Ability to handle large datasets and complex data transformations.
  • Should have experience working on end-to-end data engineering projects.
  • Good analytical, communication, and problem-solving skills.
  • Ability to work independently and collaborate with cross-functional teams.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Covasant Technologies • Hyderabad

On-site
INR 900,000 - 1,500,000
Lead Data Engineer
Lead Data Engineer

Indxx • Gurugram District

On-site
INR 3,600,000 - 5,200,000
Senior Engineer EDT Data And Analytics - Data Engineering
Senior Engineer EDT Data And Analytics - Data Engineering

Stryker • Gurugram District

Hybrid
INR 1,500,000 - 2,800,000
Data Engineer
Data Engineer

Inference Labs • Bengaluru

On-site
INR 1,200,000 - 2,200,000
Data Engineer/Snowflake Oracle
Data Engineer/Snowflake Oracle

Tech Mahindra Limited • Hyderabad, Chennai, Bengaluru

Hybrid
INR 1,200,000 - 2,200,000
Senior Data Engineer - Data & Analytics
Senior Data Engineer - Data & Analytics

Stryker India Private Limited • Gurugram District

Hybrid
INR 1,800,000 - 3,200,000
Hybrid work model
Flexible work arrangements
Data Engineer
Data Engineer

Sutherland Company • Hyderabad

On-site
INR 1,200,000 - 1,800,000
Hybrid work model
Data Engineer
Data Engineer

Ecolab Global Services • Pune District

Hybrid
INR 1,200,000 - 1,800,000
Data Analytics Developer
Data Analytics Developer

Comviva • Gurugram District

On-site
INR 1,200,000 - 2,100,000
Data Engineer
Data Engineer

Imagevision • Hyderabad

On-site
INR 1,200,000 - 1,800,000