Senior Associate Data Engineer

MassMutual India; Hyderabad; Presencial; INR 1.200.000 - 2.400.000; Jornada completa

Descripción de la vacante

MassMutual India is seeking a data engineer to design and manage ELT pipelines, enabling high-quality data assets across multiple markets. You will work with senior engineers to implement scalable BI solutions and support data strategy.

The role requires 3–5 years in Data Warehousing/BI, strong SQL and Python skills, and experience with Airflow and AWS services for data processing and orchestration.

Formación

• 3–5 years of experience in Data Warehousing and BI roles.
• Proficiency in SQL and Python.
• Hands-on experience with Airflow orchestration pipelines.

Responsabilidades

• Design, build, and measure ELT jobs to process data sources into a clean data asset.
• Collaborate with tech leads to implement enterprise data solutions and BAU support.
• Define multi-market data requirements and implement data/BI solutions.
• Create and maintain data pipelines for scalable data processing and storage.
• Extract, organize, and manage data for authorized users across the organization.
• Perform data profiling, validation, and cleansing to maintain integrity.

Conocimientos

SQL

Python

Shell scripting

Spark

Airflow

AWS

Data warehousing

BI

Data modelling

Performance tuning

Herramientas

SQL

Python

Shell scripting

Spark

Airflow

AWS (S3, Lambda, EMR, CloudWatch, Step Functions)

Relational DB design

Data warehousing principles

Descripción del empleo

Job Description:

• Design, build, and measure ELT jobs to process disparate data sources and form a high integrity, high quality, clean data asset.
• Work closely with tech lead and senior engineers to implement and deliver enterprise data solutions including data strategy, feasibility and longevity of solutions, hands‑on solution implementation and BAU support.
• Involve in stakeholders conversations to define multi-market data requirements and implement data and BI solutions
• Create and maintain data pipelines, integrations, and transformations to ensure efficient data processing, storage, and retrieval. Ensure data infrastructure is scalable, efficient, and aligned with best practices in data management
• Extract, organize, and manage data to ensure accessibility for authorized users across the organization
• Perform data profiling, validation, and cleansing to maintain data integrity and accuracy.
• Perform unit test and conduct reviews with other team members to ensure code is rigorously designed, elegantly coded, and effectively tuned for performance.
• Implement internal process improvements with coordination, automate manual processes, debug inefficient pipelines for optimal performance and scalability.
• Understand and follow the best practices and proactively seek opportunities to automate and construct tools that streamline operations and enhance overall reliability.
• Collaborate with business analysts to understand requirements and use cases, translating them into technical stories and tasks.
• 3-5 years of experience in Data Warehousing and Business Intelligence roles..
• Proficiency in Airflow Orchestration Pipelines, relational database design, data modelling, and data warehousing principles.
• Excellent programming skills in SQL, Python etc.
• Proficient in Shell scripting and building spark jobs.
• Knowledge on AWS services like S3, lambda, EMR, Cloud watch, Step functions.
• Knowledge of cloud services, relational database design principles, data warehousing, performance tuning, and optimization techniques.
• Experience in performance analysis and tuning to ensure optimal database performance
• Ability to analyze the business requirements
• Excellent communication skills with the ability to collaborate effectively with technical teams and business stakeholders to gather and refine requirements.
• Delivery-focused with a can-do attitude in challenging environments.