Senior Data Engineer

iSOCRATES Inc.; Bengaluru; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

MADTECH.AI in Bengaluru/Mysuru seeks a Senior Data Engineer to design, build, and optimize scalable data platforms powering BI, analytics and AI-driven solutions. You will work with Python, AWS, SQL, Snowflake, Redshift and Glue to deliver high-performance data pipelines and robust data models.

The role emphasizes data quality, cloud migration from on-premises to the cloud, and collaboration with data scientists and stakeholders.

Qualifications

• Bachelor's or Master's degree in Computer Science, Engineering, or a related field.
• 4-6 years of experience in Data Engineering or a similar role.
• Strong proficiency in Python and SQL (MSSQL/MySQL).
• Experience with relational and NoSQL databases.
• Hands-on experience with AWS data services (Redshift, S3, Athena); exposure to Snowflake and AWS Glue is preferred.
• Strong understanding of data warehousing, ETL/ELT, and dimensional modeling (Kimball preferred).
• Experience with cloud migration and modern data architectures.
• AWS Data Analytics/ML certification is a plus.
• Exposure to Media & Marketing Analytics, GCP, or BI tools is an advantage.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines for structured and unstructured data.
• Build and optimize data solutions using Python, AWS, SQL, and Snowflake.
• Modernize legacy data platforms and support on-premises to cloud migration initiatives.
• Develop scalable data models, preferably using Kimball dimensional modeling.
• Ensure data quality, governance, reliability, and performance across data platforms.
• Work with AWS services including Redshift, S3, Athena, and Glue (preferred).
• Optimize cloud-based data warehouses and distributed data processing systems.
• Implement CI/CD pipelines and follow data engineering best practices.
• Partner with data scientists, analysts, and business stakeholders to deliver scalable data solutions.
• Translate business requirements into technical designs.
• Mentor junior engineers and contribute to engineering standards, documentation, and continuous improvement.

Skills

Python

SQL

AWS

Snowflake

Data modeling

ETL/ELT

Kimball

NoSQL

GCP/BI tools

Education

Bachelor's/Master's in Computer Science or Engineering

Tools

Redshift

S3

Athena

Glue

Snowflake

Job description

Role Overview

We are looking for a highly skilled Senior Data Engineer to design, build, and optimize scalable data platforms that power business intelligence, analytics, and AI-driven solutions. The ideal candidate will have strong expertise in Python, AWS, SQL, and modern data engineering practices, with experience building high-performance data pipelines and cloud-based data platforms.

Key Responsibilities

Data Engineering

• Design, develop, and maintain scalable ETL/ELT pipelines for structured and unstructured data.
• Build and optimize data solutions using Python, AWS, SQL, and Snowflake.
• Modernize legacy data platforms and support on-premises to cloud migration initiatives.
• Develop scalable data models, preferably using Kimball dimensional modeling.
• Ensure data quality, governance, reliability, and performance across data platforms.

Cloud & Platform Engineering

• Work with AWS services including Redshift, S3, Athena, and Glue (preferred).
• Optimize cloud-based data warehouses and distributed data processing systems.
• Implement CI/CD pipelines and follow data engineering best practices.

Collaboration & Leadership

• Partner with data scientists, analysts, and business stakeholders to deliver scalable data solutions.
• Translate business requirements into technical designs.
• Mentor junior engineers and contribute to engineering standards, documentation, and continuous improvement.

Qualifications

• Bachelor's or Master's degree in Computer Science, Engineering, or a related field.
• 4-6 years of experience in Data Engineering or a similar role.
• Strong proficiency in Python and SQL (MSSQL/MySQL).
• Experience with relational and NoSQL databases.
• Hands-on experience with AWS data services (Redshift, S3, Athena); exposure to Snowflake and AWS Glue is preferred.
• Strong understanding of data warehousing, ETL/ELT, and dimensional modeling (Kimball preferred).
• Experience with cloud migration and modern data architectures.
• AWS Data Analytics/ML certification is a plus.
• Exposure to Media & Marketing Analytics, GCP, or BI tools is an advantage.

Key Competencies

• Strong analytical and problem-solving skills.
• Ownership mindset with a focus on quality and execution.
• Excellent collaboration and communication skills.
• Ability to thrive in a fast-paced, agile environment.
• Passion for continuous learning and mentoring.

Location

• Mysore or Bangalore.
• Willingness to collaborate with global teams across time zones.

About MADTECH.AI

MADTECH.AI is the Decision Intelligence platform for mission-driven organizations and their partners. Eliminate the burden of data wrangling, model building, data visualization, and optimization in one cost-effective AI-powered hub. By delivering sharper, on-demand insights, predictions, recommendations, and proactive problem-solving, the platform reduces data complexity empowering clients to make smarter, data-driven decisions faster and more affordably. Headquartered in St. Petersburg, Florida, U.S.A. with global capability centers in Mysuru and Bengaluru, Karnataka, India, MADTECH.AI proudly offers platform support and Professional Services staffed with proven specialists who save clients money, time and achieve transparent, accountable performance while delivering extraordinary value.