Requirement for our prestigious Client , is a next-generation analytics and data science company founded in 2016, working with marquee names in US healthcare industry

Senior Data Engineer (AWS) _ 4-8 Yrs_ ₹11–18 L_ Hybrid-Bengaluru_ Immediate Joiners or within 15 Days

Roles & Responsibilities

1. Create and maintain optimal data pipeline architecture for ETL/ELT into structured data
2. Assemble large, complex data sets that meet business requirements and create multi-dimensional modelling like Star Schema and Snowflake Schema
3. Expert level experience in creating scalable data warehouse including Fact tables, Dimensional tables and ingest datasets into cloud-based tools
4. Identify, design, and implement internal process improvements including automating manual processes and optimising data delivery
5. Collaborate with stakeholders to ensure seamless integration of data with internal data marts, enhancing advanced reporting
6. Setup and maintain data ingestion, streaming, scheduling, and job monitoring automation using AWS services including Lambda, Code Pipeline, Glue, S3, and Redshift
7. Build analytics tools that utilize the data pipeline to provide actionable insight into customer acquisition and operational efficiency
8. Work with stakeholders to assist with data-related technical issues and support their data infrastructure needs
9. Utilize GitHub for version control, code collaboration, and repository management
10. Create data tools for analytics and data scientist team members
11. Ensure data privacy and compliance with relevant regulations when handling customer data
12. Maintain data quality and consistency within the application

Ideal Candidate 1





Solid Senior Data Engineer Profile with AWS data-warehousing and pipeline expertise

2

Mandatory (Experience): Must have at least 4+ years of hands-on data engineering experience with the recent 2+ years in AWS cloud data warehouses and AWS cloud services

3

Mandatory (Tech skill 1): Must have advanced SQL knowledge and hands-on experience with relational databases and query authoring, plus a cloud data warehouse like AWS Redshift.

4

Mandatory (Tech skill 2): Must have expert-level experience creating scalable data warehouses — Fact tables, Dimensional tables, and ingesting datasets into cloud-based tools.

5

Mandatory (Tech skill 3): Must have strong multi-dimensional data modelling experience — Star Schema, Snowflake Schema, normalisation/de-normalisation, joins, OLAP cube modelling, and schema evolution while maintaining data integrity.

6

Mandatory (Tech skill 4): Must have hands-on experience creating and maintaining optimal ETL/ELT data pipeline architecture into structured data.

7

Mandatory (Tech skill 5): Must have experience setting up and maintaining data ingestion, streaming, scheduling, and job-monitoring automation using AWS services — Lambda, Glue, S3, Redshift, and Code Pipeline (CI/CD)

8

Mandatory (Tech skill 6):



Must have experience building and optimizing big-data pipelines, architectures, and datasets, including data compression into PARQUET and SQL performance tuning.

9

Mandatory (Tech skill 7): Must have experience with GitHub for version control, code collaboration, code reviews, branching strategies, and continuous integration.

10

Mandatory (Tech skill 8): Must have strong analytical skills across structured and unstructured datasets, with experience performing root-cause analysis to answer business questions and identify improvements.

11

Mandatory (Tech skill 9): Must have experience collaborating with cross-functional teams and Global IT to gather requirements and align work with business objectives, and ensuring data privacy/compliance (e.g. GDPR).

12

Mandatory (Tech skill 10): Working knowledge of message queuing, stream processing, and highly scalable big-data stores; familiarity with Agile working models.

13

Mandatory (Project Alignment): Current or recent role must clearly demonstrate hands-on work with AWS data platforms and ETL pipeline implementation—resume must describe specific projects, tools used, and candidate's direct scope

14

Mandatory (Education): Bachelor’s or master’s degree on Technology and Computer Science background

15

Mandatory (Availability): Must be an immediate joiner or currently serving notice period, able to start within the next week

16

Mandatory (Note 1) : Role is Hybrid, WFH flexibility as well upto 6 days a month

17

Mandatory (Note 2): CTC is inclusive of 20% variable

18

Preferred (Domain): Healthcare/Pharmaceutical/Life Sciences industry experience

📌 Senior Data Engineer (AWS) _ 4-8 Yrs_ Hybrid-Bengaluru_ Immediate Joiners or within 15 Days (Bangalore Metropolitan Area)
🏢 MCS Chennai
📍 Bangalore Metropolitan Area