Senior Data Engineer

Persistent Systems; Pune District; Hybrid; INR 3,000,000 - 5,400,000; Full time

Benefits offered by this job

Hybrid work environment

Learning & certifications support

Health insurance

Job summary

Persistent Systems seeks a Senior Data Engineer to architect and maintain scalable data pipelines on AWS, focusing on Redshift, Glue, and S3. The role emphasizes data warehousing, SQL optimization, and workflow automation with Airflow to deliver enterprise analytics.

You will collaborate with analysts, scientists, and stakeholders to ensure data quality and governance across platforms. You will design ETL/ELT processes, monitor performance, and contribute to CI/CD for data workflows, while

Qualifications

• 8–13 years of experience in Data Engineering, Data Warehousing, or Data Platform Development.
• Hands-on experience with AWS Redshift, AWS Glue, and Amazon S3.
• Proficient in Apache Airflow for orchestration, scheduling, monitoring, and dependency management.
• Expert-level SQL skills including complex query development, transformation, and optimization.
• Experience designing, building, and maintaining scalable data pipelines and enterprise data platforms.
• Strong understanding of data warehousing concepts, data modeling, and dimensional modeling.

Responsibilities

• Architect, develop, and maintain scalable data pipelines using AWS Redshift, AWS Glue, and S3.
• Design data warehousing solutions to support enterprise reporting and analytics.
• Develop and manage workflow orchestration with Apache Airflow.
• Write and optimize complex SQL queries for data transformation and analytics.
• Build high-performance data engineering solutions and ETL/ELT pipelines.
• Collaborate with analysts, scientists, architects, and stakeholders to deliver data solutions.
• Participate in architecture reviews, code reviews, and design discussions.
• Monitor, troubleshoot, and optimize data pipelines and platforms.
• Support Power BI integration and reporting when needed.

Skills

SQL

Data warehousing concepts

ETL/ELT design

Data governance

Security/compliance

Stakeholder management

Agile

Collaborative problem solving

Analytical thinking

Communication

Education

Bachelor’s degree in a relevant field

Tools

AWS Redshift

AWS Glue

Amazon S3

Apache Airflow

SQL development tools

Job description

We are seeking a highly experienced Senior Data Engineer with strong hands-on expertise in AWS data services, SQL, Apache Airflow, and Data Warehousing technologies. The ideal candidate will be responsible for designing, developing, and maintaining scalable data platforms and data pipelines that support enterprise analytics and business intelligence initiatives. This role requires deep technical expertise in AWS Redshift, AWS Glue, Amazon S3, workflow orchestration using Apache Airflow, and advanced SQL development. The successful candidate will play a key role in building reliable, secure, and high-performance data solutions while collaborating with cross-functional teams to deliver data-driven business outcomes.

• Location: All Persistent Locations
• Experience: Between 8 to 13 Years
• Job Type: Full Time Employment

What You'll Do:

• Architect, develop, and maintain scalable data pipelines using AWS Redshift, AWS Glue, and Amazon S3.
• Design and implement modern data warehousing solutions to support enterprise reporting and analytics needs.
• Develop and manage workflow orchestration and scheduling processes using Apache Airflow.
• Write, optimize, and maintain complex SQL queries for data transformation, integration, reporting, and analytics.
• Build reliable, scalable, and high-performance data engineering solutions.
• Design ETL/ELT pipelines for processing large volumes of structured and unstructured data.
• Ensure data quality, integrity, security, governance, and availability across enterprise platforms.
• Monitor and troubleshoot data pipelines, workflows, and platform-related issues.
• Collaborate with Data Analysts, Data Scientists, Architects, and Business Stakeholders to understand data requirements and deliver solutions.
• Participate in architecture discussions, solution design reviews, and technical planning activities.
• Perform code reviews and ensure adherence to engineering standards and best practices.
• Optimize data processing performance and support capacity planning initiatives.
• Support CI/CD implementation and automated deployment processes for data engineering workflows.
• Assist with Power BI integration and reporting requirements when needed.
• Maintain technical documentation, data flow diagrams, and operational procedures.
• Drive continuous improvement and modernization initiatives across data platforms.

Expertise You'll Bring:

• 8 to 13 years of experience in Data Engineering, Data Warehousing, or Data Platform Development.
• Expert-level hands-on experience with AWS Redshift, AWS Glue, Amazon S3.
• Strong proficiency in Apache Airflow for workflow orchestration, scheduling, monitoring, and dependency management.
• Expert-level SQL skills including Complex query development, Query optimization, Data transformation, Performance tuning, Data analysis.
• Proven experience designing, building, and maintaining scalable data pipelines and enterprise data platforms.
• Strong understanding of Data Warehousing concepts, data modeling, and dimensional modeling techniques.
• Experience with ETL/ELT design, implementation, and optimization.
• Strong understanding of data quality, data governance, data security, and compliance practices.
• Experience troubleshooting and optimizing large-scale data processing workloads.
• Hands-on involvement in code reviews, architecture discussions, and performance tuning initiatives.
• Strong analytical and problem-solving capabilities.
• Excellent communication and stakeholder management skills.
• Experience working in Agile and enterprise delivery environments.
• Competitive salary and benefits package
• Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
• Opportunity to work with cutting-edge technologies
• Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
• Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents

Values-Driven, People-Centric & Inclusive Work Environment:

Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds.

• We support hybrid work and flexible hours to fit diverse lifestyles.
• Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities.
• If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment.

Let's unleash your full potential at Persistent - persistent.com/careers

"Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind."