Senior Data Engineer
MinderaChennai, Tamil Nadu, India; Bengaluru, Karnataka, IndiaOn-Site
Needs a free Superjobs account. You'll finish on Mindera's site.
Skill score
Summary
The Senior Data Engineer designs, builds, maintains and optimises data pipelines and dimensional data models using Snowflake, dbt, SQL, Python, Airflow and AWS services, and takes ownership of existing data workflows. The role suits an experienced engineer with prior Analytics Engineering background who can work independently with minimal ramp-up.
- Function
- Data Science
- Estimated salary
- Est. ₹19–28 LPA
- Estimated for a senior role, ~8 yrs experience, India. Not published by the employer.
- Work mode and location
- On-Site, Chennai, Tamil Nadu, India; Bengaluru, Karnataka, India
- Experience
- 8–12 yrs
- Employment type
- Full-time
Job description
Overview
We are looking for an experienced Data Engineer with strong hands-on expertise in Snowflake, dbt, SQL, Python, and AWS data services. The ideal candidate will have prior experience in Analytics Engineering, with the ability to maintain, optimise, and enhance existing data models and pipelines while contributing to the team's data engineering initiatives.
Role Overview
As a Data Engineer, you will be responsible for designing, developing, maintaining, and optimising data pipelines and analytical data models. You will work extensively with Snowflake, dbt Core/dbt Cloud, SQL, Python, and AWS services to ensure reliable, scalable, and high-quality data transformation workflows.
The ideal candidate will bring strong Analytics Engineering experience and be capable of taking ownership of existing data solutions with minimal ramp-up time.
Roles and responsibilities
Key Responsibilities
- Design, develop, and maintain scalable data pipelines and transformation workflows.
- Build and optimise data models using Snowflake to support analytics and reporting requirements.
- Manage Snowflake virtual warehouses, optimise queries, and improve performance and compute efficiency.
- Develop and maintain dbt models using dbt Core and dbt Cloud, including incremental models, macros, and automated testing.
- Write complex, efficient SQL queries for data transformation, validation, and processing.
- Develop Python scripts for data engineering, pipeline automation, and workflow management.
- Work with Snowflake stored procedures and Python-based data processing solutions.
- Build, maintain, and troubleshoot Apache Airflow DAGs for data pipeline orchestration.
- Implement and support data ingestion and processing workflows using AWS services, including S3, Glue, and Kinesis Data Firehose.
- Design and implement dimensional data models, including fact tables, dimension tables, and star/snowflake schemas.
- Monitor data pipelines, troubleshoot production issues, and ensure data quality, consistency, and reliability.
- Collaborate with analytics engineers, data engineers, analysts, and other stakeholders to translate business requirements into effective data solutions.
- Follow best practices for version control, testing, documentation, deployment, and maintainability.
- Take ownership of existing data workflows and contribute to continuous improvements in pipeline performance and data modelling.
Skills required
Top skills
- Snowflake
- dbt Core
- dbt Cloud
- SQL
All skills (7)
- Python
- Apache Airflow
- Amazon S3
- AWS Glue
- Kinesis Data Firehose
- Dimensional modelling
- Analytics Engineering
Qualifications
Snowflake
- Strong hands-on experience with Snowflake data warehousing.
- Experience with warehouse management, query optimisation, and performance tuning.
- Knowledge of Snowflake architecture, compute management, and data modelling.
dbt Core and dbt Cloud
- Strong experience developing and maintaining dbt projects.
- Hands-on expertise in incremental models, macros, and dbt testing.
- Understanding of model dependencies, documentation, and deployment workflows.
SQL
- Advanced SQL skills, including complex joins, CTEs, window functions, and aggregations.
- Experience optimising queries and processing large datasets.
Python
- Experience developing Python scripts for data engineering and pipeline automation.
- Familiarity with Snowflake stored procedures and Python-based integrations.
- Experience building or maintaining Airflow DAGs.
AWS and Data Pipeline Orchestration
- Hands-on experience with AWS data services, including:
- Amazon S3
- AWS Glue
- Amazon Kinesis Data Firehose
- Experience using Apache Airflow for pipeline orchestration, scheduling, and monitoring.
- Ability to troubleshoot and maintain production data pipelines.
Dimensional Modelling
- Strong understanding of dimensional modelling principles.
- Experience designing fact and dimension tables.
- Knowledge of star and snowflake schemas and analytical data modelling practices.
Experience and Qualifications
- 8–12 years of overall experience in Data Engineering or related data disciplines.
- Previous hands-on experience in an Analytics Engineering role is strongly preferred.
- Proven experience working with Snowflake, dbt, SQL, Python, and AWS data services.
- Experience maintaining and enhancing production-grade data pipelines and analytical models.
- Ability to work independently, solve complex technical problems, and take ownership of existing data solutions.
- Strong communication and collaboration skills.
Other details
We offer
- Flexible working hours (self-managed)
- Annual bonus, subject to company performance
- Access to Udemy online training and opportunities to learn and grow within the role
Our offices are located: Porto, Portugal | Aveiro, Portugal | Coimbra, Portugal | Leicester, UK | San Diego, USA | Chennai, India | Bengaluru, India
Company info
About Mindera
Software Engineering Applications, including Web and Mobile, are at the core of what we do at Mindera. We partner with our clients, to understand their products and deliver high-performance, resilient and scalable software systems that create an impact on their users and businesses across the world.