Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Engaged Employer

iSOCRATES

Compare

3.0

based on 30 Reviews

29 iSOCRATES Jobs

Lead Data Engineer

iSOCRATES

3.0

based on 30 Reviews

8-13 years

Bangalore / Bengaluru

1 vacancy

Lead Data Engineer

iSOCRATES

posted 6hr ago

Job Role Insights

Fixed timing

Key skills for the job

Virtual Assistant Python Consulting Oracle MySQL SAP Data Migration

+ 4 more

Job Description

About iSOCRATES

Since 2015, iSOCRATES advises on, builds and manages mission-critical Marketing, Advertising and Data technologies, platforms, and processes as the Global Leader in MADTECH Resource Planning and Execution(TM).

iSOCRATES delivers globally proven, reliable, and affordable Strategy and Operations Consulting and Managed Services for marketers, agencies, publishers, and the data/tech providers that enable them.

iSOCRATES is staffed 24/7/365 with its proven specialists who save partners money, and time and achieve transparent, accountable, performance while delivering extraordinary value. Savings stem from a low-cost, focused global delivery model at scale that benefits from continuous re-investment in technology and specialized training.

About MADTECH.AI

MADTECH.AI is the Unified Marketing, Advertising, and Data Decision Intelligence Platform purpose-built to deliver speed to value for marketers.

At MADTECH.AI, we make real-time AI-driven insights accessible to everyone. Whether you re a global or emerging brand, agency, publisher, or data/tech provider, we give you a single source of truth - so you can capture sharper insights that drive better marketing decisions faster and more affordable than ever before.

MADTECH.AI unifies and transforms MADTECH data and centralizes decision intelligence in a single, affordable platform. Leave data wrangling, data model building, proactive problem solving, and data visualization to MADTECH.AI.

Job Description:

The Lead Data Engineer is responsible for finding trends in Data sets and Developing Algorithms to help make raw data more useful to the Organization. This role requires a significant Set of Technical Skills, including a deep Knowledge of SQL Database Design and Multiple Programming languages along with team management skills. The candidate must be a champion in SQL.

iSOCRATES is looking to add a Lead Data Engineer to its growing Analytics team. The Lead Data Engineer will lead the team that is responsible for finding trends in Data sets and Developing Algorithms to help make raw data more useful to the Organization. The Lead Data Engineer will report directly to the Technical Architect. iSOCRATES is seeking qualified candidates to work on-site, full-time in Mysuru, India and who are eligible to travel to the U.S.

Responsibilities :

Design and build production data pipelines from ingestion to consumption within a big data architecture.
As a champion in MSSQL, the candidate must understand existing legacy code and redesign to make it performant code.
Handle the technicalities of Data migration project from on-prem to cloud environments.
You will pair to write clean and iterative code based on TDD
Leverage various continuous delivery practices to deploy, support and operate data pipelines.
Advise Educate clients on how to use different distributed storage computing technologies from the plethora of options available.
Develop and operate modern data architecture approaches to meet key business objectives provide end-to-end data solutions.
Create data models and speak to the tradeoffs of different modelling approaches.
Seamlessly include data quality in your day-to-day work as well as in the delivery process.
Setting department priorities, goals, and objectives, budget, recruiting, training, work ethic, and culture.
Guide the junior team members.
Building and leading productive, service-oriented relationships between the Data Engineering department and other iSOCRATES departments and between the department and external stakeholders.

Qualifications:

Overall, 7-10 years of experience in data analytics
6+ years strong experience in SQL/NoSQL databases.
Strong in Database - T-SQL/MSSQL/Oracle/MySQL
Design and build production data pipelines from ingestion to consumption using Python/ AWS/ Snowflake.
Experience in on-prem to cloud data migration projects
Design, build and operationalize large-scale enterprise data solutions and applications using one or more of AWS data and analytics services in combination with Mandatory - Redshift, S3, Athena, Good to have - Glue, Snowflake.
Design and implement data engineering, ingestion, and curation functions on AWS cloud using AWS native or custom programming.
Perform detailed assessments of current state data platforms and create an appropriate transition path to AWS cloud.
Should be able to understand the data very well, create a pattern on structured /non-structured data.
Strong knowledge of Data warehouse, Data Modelling (Preferably Dimensional Modelling - Kimball)
Proficiency in both ETL ELT.
Hands-on ETL Tools like Alteryx, SSIS, FiveTran or CloverDX will be an added advantage.
AWS Certified Data Analytics Specialist / AWS Certified ML Specialist will be an added advantage.
Exposure to Media Marketing is a plus.
Knowing GCP is a plus.
Knowing 1 or more visualization tools is a plus.
2 to 3 years of experience in Team Building Handling.

Preferred Skills:

Structured thinker, a result-oriented person passionate about data-driven decision-making.
Have a passion for problem-solving and client relations.
Should possess good communication capabilities. Should be a very good team player with a go-getter attitude, results-driven, adaptable, inspirational, organized and quality-focused.
Ability to handle complex problems from design to execution and deliver in time time-bound manner under constraints.
Must be ready to work in Late EMEA or ET hours
Ready to work from Mysore or Bangalore locations.

Employment Type: Full Time, Permanent

Read full job description

Prepare for Lead Data Engineer roles with real interview advice