Senior Data Engineer

iSOCRATES; Bengaluru; On-site; INR 1,400,000 - 2,000,000; Full time

Job summary

MADTECH.AI is seeking a Senior Data Engineer to design, build, and optimize scalable data platforms for BI, analytics, and AI-driven solutions. You will work with Python, AWS, SQL, Snowflake, and modern data engineering practices.

You will design ETL/ELT pipelines, modernize legacy systems, and mentor junior engineers while ensuring data quality and governance across platforms. Location includes Mysuru or Bengaluru with global collaboration across time zones.

Qualifications

• Bachelor's or Master's degree in Computer Science, Engineering, or related field.
• 4–6 years of experience in Data Engineering or 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); Snowflake and Glue exposure preferred.
• Solid understanding of data warehousing, ETL/ELT, and Kimball dimensional modeling; cloud migration experience
• AWS Data Analytics/ML certification is a plus.

Responsibilities

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

Skills

Python

SQL

AWS

Data warehousing

ETL/ELT

Cloud migration

Education

Bachelor's or Master's in CS/Engineering

Tools

Snowflake

AWS Glue

Redshift

S3

Athena

Job description

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

• 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.

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.
• 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.

Required Skills