iSOCRATES

Senior Data Engineer

Bengaluru, India Mysuru, India
SQL Data Warehousing Python Data Analytics Data Engineering Snowflake AWS MS SQL MySQL NoSQL Redshift S3 Athena Glue ETL ELT GCP
Description

Senior Data Engineer

Location: Bengaluru, India; Mysuru, KA, IND, India

Department: MADTECH.AI

Experience: 4 - 6 Yrs

Skills: MS SQL, Data Warehousing, Python, Data Analytics, Data Engineering, Snowflake, AWS Services

Role Overview

We are seeking a highly skilled and performance-driven Senior Data Engineer to design, build, and optimize scalable data solutions that power business intelligence and advanced analytics. The ideal candidate will bring deep expertise in SQL, strong experience in modern data architectures, and hands-on exposure to cloud-based data ecosystems.

This role requires both strong technical capabilities and the ability to collaborate effectively across teams while contributing to department-level goals and initiatives.

Key Responsibilities

Data Engineering & Architecture

  • Design and develop robust, production-grade data pipelines from ingestion to consumption within modern big data architectures.
  • Build and optimize scalable data solutions using Python, AWS, and Snowflake.
  • Redesign and enhance legacy MSSQL codebases to improve performance, scalability, and maintainability.
  • Lead and execute on-premises to cloud data migration initiatives.
  • Develop and operationalize enterprise-grade data platforms using AWS services such as Redshift, S3, and Athena (Glue and Snowflake exposure is an advantage).
  • Implement data engineering, ingestion, and curation frameworks using AWS native services or custom solutions.
  • Perform current-state assessments of data platforms and define structured transition paths to cloud environments.

Data Modeling & Quality

  • Design data models and articulate trade-offs between different modeling approaches (preferably Kimball-based dimensional modeling).
  • Build and maintain both ETL and ELT pipelines.
  • Integrate data quality standards and validation processes into everyday workflows and delivery cycles.
  • Work with structured and unstructured datasets to derive scalable patterns and solutions.

Engineering Excellence

  • Write clean, test-driven, and iterative code following TDD practices.
  • Leverage continuous integration and continuous delivery (CI/CD) practices to deploy and maintain data pipelines.
  • Demonstrate strong understanding of distributed storage and computing technologies.

Collaboration & Leadership

  • Contribute to departmental planning including goal setting, prioritization, and continuous improvement initiatives.
  • Build service-oriented relationships with internal teams and external stakeholders.
  • Support recruiting, mentoring, and fostering a strong engineering culture focused on quality and accountability.

Qualifications & Experience

  • Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.
  • 4+ years of overall experience in Data Engineering and Analytics.
  • 3+ years of hands-on experience with MSSQL or MySQL (strong SQL expertise is mandatory).
  • Proven experience working with both SQL and NoSQL databases.
  • Strong experience designing and building production data pipelines using Python and AWS.
  • Experience with on-premises to cloud data migration projects.
  • Hands-on expertise with AWS data services (Redshift, S3, Athena - mandatory; Glue and Snowflake - good to have).
  • Strong knowledge of Data Warehousing concepts and Dimensional Modeling (Kimball preferred).
  • Proficiency in ETL and ELT methodologies.
  • AWS Certified Data Analytics or AWS Certified ML certification is an advantage.
  • Exposure to Media & Marketing analytics domain is a plus.
  • Familiarity with GCP or data visualization tools is desirable.

Behavioral Competencies

  • Structured thinker with strong analytical orientation.
  • Results-driven with a passion for data-led decision-making.
  • Strong problem-solving skills with end-to-end ownership mindset.
  • Excellent communication and stakeholder management skills.
  • Ability to work effectively under time constraints and in late EMEA/ET hours.
  • Willingness to work from Mysore or Bangalore location.


About iSOCRATES

iSOCRATES advises on, builds, manages, and owns mission-critical Marketing, Advertising and Data platforms, technologies, and processes as the Global Leader in MADTech Resource Planning and Execution™ serving publishers, marketers, agencies and enablers.
iSOCRATES has two lines of business: Products (MADTechAI™) and Services (Consulting: Strategy and Operations; Managed Services).

About MADTECH.AI

MADTECH.AI is your Marketing Decision Intelligence platform. Unify, transform, analyze, and visualize all your data in a single, cost-effective AI-powered hub. Gain speed to value by leaving data wrangling, model building, data visualization, and proactive problem solving to MADTECH.AI. Sharper insights, smarter decisions, faster.

MADTECH.AI was spun out of well-established Inc. 5000 consultancy iSOCRATES® which advises on, builds, manages, and owns mission-critical Marketing, Advertising and Data platforms, technologies and processes as the Global Leader in MADTECH Resource Planning and Execution™ serving marketers, agencies, publishers, and their data/tech suppliers.
iSOCRATES
iSOCRATES

0 applies

0 views

There are more than 50,000 engineering jobs:

Subscribe to membership and unlock all jobs

Engineering Jobs

60,000+ jobs from 4,500+ well-funded companies

Updated Daily

New jobs are added every day as companies post them

Refined Search

Use filters like skill, location, etc to narrow results

Become a member

🥳🥳🥳 452 happy customers and counting...

Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.

To try it out

For active job seekers

For those who are passive looking

Cancel anytime

Frequently Asked Questions

  • We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
  • We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
  • We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
  • We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
  • Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
  • Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
  • Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅

What Fellow Engineers Say