The Senior Data Engineer will design and maintain data ingestion frameworks and data pipelines, optimize DBT models, and integrate workflows with AWS services.
Role Overview
We are looking for a Senior Data Engineer who will play a key role in designing, building, and maintaining data ingestion frameworks and scalable data pipelines. The ideal candidate should have strong expertise in platform architecture, data modeling, and cloud-based data solutions to support real-time and batch processing needs.
What you'll be doing:
- Design, develop, and optimise DBT models to support scalable data transformations.
- Architect and implement modern ELT pipelines using DBT and orchestration tools like Apache Airflow and Prefect.
- Lead performance tuning and query optimization for DBT models running on Snowflake, Redshift, or Databricks
- Integrate DBT workflows & pipelines with AWS services (S3, Lambda, Step Functions, RDS, Glue) and event-driven architectures
- Implement robust data ingestion processes from multiple sources, including manufacturing execution systems (MES), Manufacturing stations, and web applications.
- Manage and monitor orchestration tools (Airflow, Prefect) for automated DBT model execution.
- Implement CI/CD best practices for DBT, ensuring version control, automated testing, and deployment workflows.
- Troubleshoot data pipeline issues and provide solutions for optimizing cost and performance.
What you'll have:
- 5+ years of hands-on experience with DBT, including model design, testing, and performance tuning.
- 5+ years of Strong SQL expertise with experience in analytical query optimization and database performance tuning.
- 5+ years of programming experience, especially in building custom DBT macros, scripts, APIs, working with AWS services using boto3.
- 3+ years of Experience with orchestration tools like Apache Airflow, Prefect for scheduling DBT jobs.
- Hands-on experience in modern cloud data platforms like Snowflake, Redshift, Databricks, or Big Query
- Experience with AWS data services (S3, Lambda, Step Functions, RDS, SQS, CloudWatch).
- Familiarity with serverless architectures and infrastructure as code (CloudFormation/Terraform).
- Ability to effectively communicate timelines and deliver MVPs set for the sprint.
- Strong analytical and problem-solving skills, with the ability to work across cross-functional teams.
Nice to haves:
- Experience in hardware manufacturing data processing.
- Contributions to open-source data engineering tools.
- Knowledge of Tableau or other BI tools for data visualization.
- Understanding of front-end development (React, JavaScript, or similar) to collaborate effectively with UI teams or build internal tools for data visualization
Top Skills
Apache Airflow
Aws (S3
Databricks
Dbt
Glue)
Lambda
Prefect
Rds
Redshift
Snowflake
Step Functions
Similar Jobs
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
As a Senior Data Engineer, you'll build and maintain data pipelines, work on data lakes, and enhance self-service capabilities while transforming vague requirements into actionable solutions.
Top Skills:
AirflowAWSEmrHiveJavaKinesisPythonRdsS3ScalaSparkSQLSqs
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
As a Senior Data Engineer at Atlassian, you'll build and optimize data pipelines and micro-services, working with AWS-based data lakes and enhancing data accessibility for stakeholders while ensuring data quality.
Top Skills:
AirflowAWSDatabricksEmrHiveJavaKinesisPythonRdsS3ScalaSparkSQLSqs
Healthtech • Software • Analytics • Biotech • Pharmaceutical • Manufacturing
As a Senior Data Engineer at Takeda, you will design and implement complex data structures and pipelines, lead the ingestion of structured and unstructured data, develop data quality methodologies, and influence analytics to derive actionable insights from large data sets, while collaborating closely with architects and product owners.
What you need to know about the Bengaluru Tech Scene
Dubbed the "Silicon Valley of India," Bengaluru has emerged as the nation's leading hub for information technology and a go-to destination for startups. Home to tech giants like ISRO, Infosys, Wipro and HAL, the city attracts and cultivates a rich pool of tech talent, supported by numerous educational and research institutions including the Indian Institute of Science, Bangalore Institute of Technology, and the International Institute of Information Technology.