Design, build, and optimize scalable data pipelines, ETL/ELT workflows, dbt transformation projects, SQL data models, and AWS cloud data solutions. Ensure data quality, governance, security, and pipeline reliability while supporting BI initiatives. Collaborate with stakeholders, lead technical discussions, review code, mentor junior engineers, and develop reusable documentation and best practices.
Job Title: Senior Data Engineer / Analytics Engineer
Experience
8+ Years
Location
Flexible / Hybrid / Remote
Job Summary
We are seeking an experienced Senior Data Engineer / Analytics Engineer with 8+ years of hands-on experience in designing, building, and optimizing scalable data platforms and analytics solutions. The ideal candidate should possess strong expertise in SQL, dbt, AWS, and Python, along with excellent communication and stakeholder management skills. The role involves working closely with business teams, data analysts, architects, and engineering teams to deliver reliable and scalable data solutions.
Key Responsibilities
- Design, develop, and maintain scalable data pipelines and ETL/ELT workflows.
- Build and manage data transformation frameworks using dbt.
- Develop high-performance data models and optimize complex SQL queries.
- Implement data ingestion and integration processes from multiple data sources.
- Leverage AWS services to build cloud-native data solutions.
- Ensure data quality, governance, security, and compliance across data platforms.
- Collaborate with business stakeholders to understand requirements and convert them into technical solutions.
- Create reusable data models, documentation, and best practices.
- Monitor and troubleshoot production data pipelines to ensure reliability and performance.
- Mentor junior team members and participate in code reviews and architectural discussions.
- Support BI and reporting initiatives by providing curated and trusted datasets.
Required Skills
SQL
- Advanced SQL development and performance tuning.
- Expertise in data modeling, query optimization, and database design.
- Experience working with large-scale relational and analytical databases.
dbt
- Strong experience in developing and maintaining dbt projects.
- Creating incremental models, snapshots, tests, macros, and documentation.
- Understanding of CI/CD integration and deployment practices for dbt.
AWS
Hands-on experience with:
- Amazon S3
- AWS Glue
- AWS Lambda
- Amazon Redshift
- AWS Athena
- IAM and Security Best Practices
- CloudWatch Monitoring
- EventBridge / Step Functions (preferred)
Python
- Strong development experience using Python for data engineering and automation.
- Expertise with Pandas, NumPy, and API integrations.
- Experience building scalable data processing frameworks.
Additional Technical Skills
- Experience with ETL/ELT frameworks.
- Knowledge of data warehousing concepts and dimensional modeling.
- Exposure to CI/CD tools such as GitHub Actions, Jenkins, or Azure DevOps.
- Experience with Airflow or other workflow orchestration tools is preferred.
- Familiarity with Agile/Scrum methodologies.
Soft Skills
- Strong verbal and written communication skills.
- Ability to interact confidently with business stakeholders and leadership teams.
- Excellent problem-solving and analytical thinking capabilities.
- Experience leading technical discussions and solution design workshops.
- Strong collaboration and mentoring skills.
Preferred Qualifications
- Bachelor's or Master's degree in Computer Science, Engineering, Information Systems, or related field.
- AWS Certification (Associate or Professional level) preferred.
- Experience in modern cloud data platforms and analytics ecosystems.
Nice to Have
- Snowflake
- Databricks
- Power BI or Tableau
- Data Governance and Data Quality frameworks
- Infrastructure as Code (Terraform/CloudFormation)
Responsibilities
Job Title: Senior Data Engineer / Analytics Engineer
Experience
8+ Years
Location
Flexible / Hybrid / Remote
Job Summary
We are seeking an experienced Senior Data Engineer / Analytics Engineer with 8+ years of hands-on experience in designing, building, and optimizing scalable data platforms and analytics solutions. The ideal candidate should possess strong expertise in SQL, dbt, AWS, and Python, along with excellent communication and stakeholder management skills. The role involves working closely with business teams, data analysts, architects, and engineering teams to deliver reliable and scalable data solutions.
Key Responsibilities
- Design, develop, and maintain scalable data pipelines and ETL/ELT workflows.
- Build and manage data transformation frameworks using dbt.
- Develop high-performance data models and optimize complex SQL queries.
- Implement data ingestion and integration processes from multiple data sources.
- Leverage AWS services to build cloud-native data solutions.
- Ensure data quality, governance, security, and compliance across data platforms.
- Collaborate with business stakeholders to understand requirements and convert them into technical solutions.
- Create reusable data models, documentation, and best practices.
- Monitor and troubleshoot production data pipelines to ensure reliability and performance.
- Mentor junior team members and participate in code reviews and architectural discussions.
- Support BI and reporting initiatives by providing curated and trusted datasets.
Required Skills
SQL
- Advanced SQL development and performance tuning.
- Expertise in data modeling, query optimization, and database design.
- Experience working with large-scale relational and analytical databases.
dbt
- Strong experience in developing and maintaining dbt projects.
- Creating incremental models, snapshots, tests, macros, and documentation.
- Understanding of CI/CD integration and deployment practices for dbt.
AWS
Hands-on experience with:
- Amazon S3
- AWS Glue
- AWS Lambda
- Amazon Redshift
- AWS Athena
- IAM and Security Best Practices
- CloudWatch Monitoring
- EventBridge / Step Functions (preferred)
Python
- Strong development experience using Python for data engineering and automation.
- Expertise with Pandas, NumPy, and API integrations.
- Experience building scalable data processing frameworks.
Additional Technical Skills
- Experience with ETL/ELT frameworks.
- Knowledge of data warehousing concepts and dimensional modeling.
- Exposure to CI/CD tools such as GitHub Actions, Jenkins, or Azure DevOps.
- Experience with Airflow or other workflow orchestration tools is preferred.
- Familiarity with Agile/Scrum methodologies.
Soft Skills
- Strong verbal and written communication skills.
- Ability to interact confidently with business stakeholders and leadership teams.
- Excellent problem-solving and analytical thinking capabilities.
- Experience leading technical discussions and solution design workshops.
- Strong collaboration and mentoring skills.
Preferred Qualifications
- Bachelor's or Master's degree in Computer Science, Engineering, Information Systems, or related field.
- AWS Certification (Associate or Professional level) preferred.
- Experience in modern cloud data platforms and analytics ecosystems.
Nice to Have
- Snowflake
- Databricks
- Power BI or Tableau
- Data Governance and Data Quality frameworks
- Infrastructure as Code (Terraform/CloudFormation)
Qualifications
Job Title: Senior Data Engineer / Analytics Engineer
Experience
8+ Years
Location
Flexible / Hybrid / Remote
Job Summary
We are seeking an experienced Senior Data Engineer / Analytics Engineer with 8+ years of hands-on experience in designing, building, and optimizing scalable data platforms and analytics solutions. The ideal candidate should possess strong expertise in SQL, dbt, AWS, and Python, along with excellent communication and stakeholder management skills. The role involves working closely with business teams, data analysts, architects, and engineering teams to deliver reliable and scalable data solutions.
Key Responsibilities
- Design, develop, and maintain scalable data pipelines and ETL/ELT workflows.
- Build and manage data transformation frameworks using dbt.
- Develop high-performance data models and optimize complex SQL queries.
- Implement data ingestion and integration processes from multiple data sources.
- Leverage AWS services to build cloud-native data solutions.
- Ensure data quality, governance, security, and compliance across data platforms.
- Collaborate with business stakeholders to understand requirements and convert them into technical solutions.
- Create reusable data models, documentation, and best practices.
- Monitor and troubleshoot production data pipelines to ensure reliability and performance.
- Mentor junior team members and participate in code reviews and architectural discussions.
- Support BI and reporting initiatives by providing curated and trusted datasets.
Required Skills
SQL
- Advanced SQL development and performance tuning.
- Expertise in data modeling, query optimization, and database design.
- Experience working with large-scale relational and analytical databases.
dbt
- Strong experience in developing and maintaining dbt projects.
- Creating incremental models, snapshots, tests, macros, and documentation.
- Understanding of CI/CD integration and deployment practices for dbt.
AWS
Hands-on experience with:
- Amazon S3
- AWS Glue
- AWS Lambda
- Amazon Redshift
- AWS Athena
- IAM and Security Best Practices
- CloudWatch Monitoring
- EventBridge / Step Functions (preferred)
Python
- Strong development experience using Python for data engineering and automation.
- Expertise with Pandas, NumPy, and API integrations.
- Experience building scalable data processing frameworks.
Additional Technical Skills
- Experience with ETL/ELT frameworks.
- Knowledge of data warehousing concepts and dimensional modeling.
- Exposure to CI/CD tools such as GitHub Actions, Jenkins, or Azure DevOps.
- Experience with Airflow or other workflow orchestration tools is preferred.
- Familiarity with Agile/Scrum methodologies.
Soft Skills
- Strong verbal and written communication skills.
- Ability to interact confidently with business stakeholders and leadership teams.
- Excellent problem-solving and analytical thinking capabilities.
- Experience leading technical discussions and solution design workshops.
- Strong collaboration and mentoring skills.
Preferred Qualifications
- Bachelor's or Master's degree in Computer Science, Engineering, Information Systems, or related field.
- AWS Certification (Associate or Professional level) preferred.
- Experience in modern cloud data platforms and analytics ecosystems.
Nice to Have
- Snowflake
- Databricks
- Power BI or Tableau
- Data Governance and Data Quality frameworks
- Infrastructure as Code (Terraform/CloudFormation)
About Us
EXL (NASDAQ: EXLS) is a leading data analytics and digital operations and solutions company. We partner with clients using a data and AI-led approach to reinvent business models, drive better business outcomes and unlock growth with speed. EXL harnesses the power of data, analytics, AI, and deep industry knowledge to transform operations for the world’s leading corporations in industries including insurance, healthcare, banking and financial services, media and retail, among others. EXL was founded in 1999 with the core values of innovation, collaboration, excellence, integrity and respect. We are headquartered in New York and have more than 54,000 employees spanning six continents. For more information, visit www.exlservice.com.
EXL Pune, Mahārāshtra, IND Office
Pune, India
Similar Jobs
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Design and build data services and pipelines supporting machine learning products. Develop automation tools for model deployment, maintain production data systems, improve infrastructure, participate in code reviews, and collaborate across engineering, data science, and product teams. The role requires expertise in distributed systems, large-scale data processing, CI/CD, container orchestration, and AI-enabled workflow improvements.
Top Skills:
AirflowAWSAws BatchCi/CdDockerEmrGlueGoKafkaKubernetesKv StoresLinuxPythonRelational DatabasesSagemakerSparkSpinnaker
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Own the architecture, technical direction, reliability, cost efficiency, and adoption of Atlassian’s analytical data platform. Build foundational ingestion, transformation, orchestration, compute, and consumption components; establish multi-tenant standards and SLOs; and lead cross-team technical initiatives. The role requires hands-on development, distributed systems expertise, batch and streaming architecture design, cloud experience, and mentorship of senior engineers.
Top Skills:
Amazon Web ServicesApache IcebergApache PinotSparkClickhouseDbtDelta LakeDruidJavaKotlinKubernetesPythonStarrocks
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
Designs and optimizes scalable data ingestion pipelines for product telemetry and enterprise business data. Builds automated pipelines using Fivetran, Python, APIs, S3 lakehouse architectures, Kafka, Spark, and Snowflake. Applies advanced SQL, incremental loading, CDC, micro-batching, and rate-limit handling to support reliable, analytics-ready datasets. Implements CI/CD and DevOps practices, monitors pipeline performance, and partners with analysts and platform teams to rapidly deliver data solutions.
Top Skills:
Amazon S3SparkBulk ApisCdcCi/CdDevOpsFivetranKafkaPythonSnowflakeSQLVersion Control
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
