The Role
Designs, develops, and maintains scalable data pipelines, data architectures, quality processes, and integrations across varied sources. Troubleshoots data issues, monitors solutions to meet SLAs, documents infrastructure, and collaborates with stakeholders and cross-functional teams. Requires strong SQL, database management, dimensional and relational modeling, and Python or Java experience, with preferred expertise in cloud data warehouses, big data, ETL tools, orchestration, BI dashboards, and Agile delivery.
Summary Generated by Built In
Experience: 5+ Years
Location: Bengaluru/Hyderabad/Pune
Employment Type: Full-Time
Work Mode: Hybrid
Job SummaryWe are looking for a Senior Data Engineer – Snowflake with 5+ years of experience in designing, developing, and maintaining scalable data solutions. The ideal candidate should have strong hands-on experience with Snowflake, dbt, SQL, and Python, along with good understanding of modern data engineering practices.
The candidate will be responsible for building reliable data pipelines, developing data transformation workflows, optimizing Snowflake workloads, and ensuring data quality and performance.
Key Responsibilities- Design, develop, and maintain scalable data pipelines and data transformation workflows using Snowflake, dbt, SQL, and Python.
- Develop and optimize Snowflake tables, views, queries, stored procedures, and data models.
- Build and maintain dbt models, including incremental models, snapshots, tests, macros, and model dependencies.
- Write complex and optimized SQL queries for data transformation, analysis, and reporting requirements.
- Develop Python scripts and utilities for data processing, automation, and pipeline orchestration.
- Implement data ingestion and transformation processes from multiple source systems into Snowflake.
- Perform data validation, reconciliation, and quality checks to ensure data accuracy and consistency.
- Analyze and optimize Snowflake query performance, warehouse utilization, and data processing efficiency.
- Implement appropriate data modeling techniques, including fact/dimension modeling and Slowly Changing Dimensions (SCD).
- Troubleshoot data pipeline failures and resolve data quality and performance issues.
- Collaborate with data analysts, business stakeholders, and other engineering teams to understand data requirements.
- Follow best practices for code quality, version control, testing, documentation, and deployment.
- 5+ years of experience in Data Engineering
- Strong hands-on experience with Snowflake
- Strong proficiency in SQL
- Hands-on experience with dbt
- Good programming experience in Python
- Strong understanding of ETL/ELT concepts and data pipelines
- Experience with data modeling and database concepts
- Experience with data validation and data quality processes
- Good understanding of Snowflake performance optimization
Skills Required
- Bachelor's degree in Computer Science, Data Analytics, Information Systems, or a related field
- Experience developing data pipelines using Python or Java
- 5+ years of dimensional and relational data modeling experience
- Excellent SQL and database management skills
- 5+ years of data warehouse engineering experience with OLAP platforms such as Snowflake, BigQuery, Teradata, or Redshift
- 5+ years of experience with transactional databases such as Oracle, SQL Server, or MySQL
- 5+ years of big data, Hadoop, Data Lake, and Spark experience in a cloud environment such as AWS
- 5+ years of experience with commercial ETL tools such as dbt, Matillion, and SSIS or Azure Data Factory
- 5+ years delivering ETL solutions from source systems, databases, APIs, flat files, and JSON
- Experience developing entity relationship diagrams using Erwin, SQLDBM, or equivalent
- Experience with job scheduling and monitoring systems such as Airflow, Datadog, or AWS SNS
- Experience with Claude Code, Cortex Coco, VSCode Copilot, or AI-enabled SDLC development models
- Experience building BI dashboards with tools such as Tableau
- Experience in financial, marketing, sales, accounts payable, accounts receivable, or invoicing domains
- Experience managing work assignments using Jira and Confluence
- Experience with Scrum or Agile methodologies
- Ability to work independently and as part of a team
- Excellent analytical and problem-solving skills
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Relanto is a global advisory, consulting, and technology-services partner that helps organizations navigate business transformation as artificial intelligence reshapes the business landscape. Founded in 2021, the company combines advisory expertise with consulting and technology services, operating across a global footprint that includes India and the United States. Its mission centers on applying AI and modern technology to evolving enterprise needs.
