Snowflake & Python Data Engineer

Synechron Technologies Pvt. Ltd._INDIA Company; Pune District; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Synechron Technologies Pvt. Ltd. in Pune is seeking a Snowflake & Python Data Engineer to build and support scalable data solutions across cloud and on-premises environments.

You will develop data pipelines, integrate multiple data sources, automate workflows, and support analytics and reporting. The role requires hands-on experience with Snowflake, Python, SQL, AWS, and distributed Agile teams. You will design, test, and optimize data models, implement data validation, and collaborate with

Qualifications

• 5+ years in data engineering or data integration.
• 3+ years using Snowflake and Python professionally.
• Strong SQL and relational database experience.

Responsibilities

• Design, develop, test, and support Snowflake data pipelines.
• Build Python-based integrations and automation for cloud and on-prem sources.
• Develop efficient SQL queries and data models.
• Monitor pipelines and resolve data-quality or operational issues.
• Document technical designs and support processes.

Skills

Python 3.x

Snowflake

SQL

Shell scripting

Git

AWS

Agile delivery

Distributed teams

Education

Bachelor's degree in computer science or related

Tools

Django

Flask

Python ORM libraries

Job description

Job Summary

Synechron is seeking a Snowflake & Python Data Engineer to build and support scalable data solutions across cloud and on-premises environments. The role will develop data pipelines, integrate multiple data sources, automate workflows, and support analytics and reporting. The successful candidate will work with Snowflake, Python, SQL, relational databases, and AWS to deliver secure, reliable, and efficient data solutions in collaboration with distributed Agile teams.

Software Requirements

• 5+ years of experience integrating data between cloud and on-premises databases.
• 3+ years of hands-on experience with Snowflake and Python 3.x.
• Strong SQL and relational database experience.
• Experience integrating multiple data sources using Python.
• Strong Python programming and shell scripting skills.
• Working knowledge of AWS services, particularly S3 and EC2.
• Experience with Git, testing, code reviews, and Agile delivery.
• Experience working with distributed teams.
• Strong written and verbal communication, organization, and analytical skills.

Preferred Experience

• Experience with Django, Flask, or Python ORM libraries.
• Experience with data orchestration, CI/CD, monitoring, or infrastructure-as-code tools.
• Knowledge of ledger, sub-ledger, transaction, or reconciliation processes.
• Snowflake or AWS certification.

Overall Responsibilities

• Design, develop, test, and support Snowflake data pipelines.
• Build Python-based integrations and automation for cloud, on-premises, database, file, and API sources.
• Develop efficient SQL queries, transformations, data models, and reporting structures.
• Implement data validation, reconciliation, error handling, monitoring, and recovery processes.
• Troubleshoot data quality, performance, and production issues.
• Collaborate with engineering, analytics, architecture, security, and business teams.
• Participate in Agile planning, estimation, reviews, and retrospectives.
• Document technical designs, data mappings, operational procedures, and support processes.
• Follow security, governance, cost-management, and sustainable cloud-use practices.

Technical Skills (By Category)

• Programming Languages
  • Essential: Python 3.x, SQL, and shell scripting.
  • Preferred: Additional programming languages, asynchronous Python, and reusable Python library development.
• Databases and Data Management
  • Essential: Snowflake, relational databases, data modeling, batch and incremental loading, data validation, reconciliation, and SQL optimization.
  • Preferred: Snowflake streams, tasks, stages, dimensional modeling, data governance, and ledger data.
• Cloud Technologies
  • Essential: AWS, including S3 and EC2; cloud-to-on-premises data integration.
  • Preferred: Additional AWS data, security, monitoring, migration, and cost-optimization services.
• Frameworks and Libraries
  • Essential: Python libraries for data processing, database connectivity, API integration, and testing.
  • Preferred: Django, Flask, ORM libraries, and workflow automation frameworks.
• Development Tools and Methodologies
  • Essential: Git, Agile development, code reviews, automated testing, documentation, and production support.
  • Preferred: CI/CD, containerization, infrastructure-as-code, orchestration, and observability tools.
• Security
  • Essential: Role-based access, least privilege, secure credential management, encryption, data masking, logging, and secure data handling.
  • Preferred: Experience with audit, privacy, compliance, and access-review processes.

Experience Requirements

• 5+ years in data engineering, data integration, database development, or a related role.
• 3+ years using Snowflake and Python professionally.
• Strong experience with SQL and relational databases.
• Experience delivering and supporting production data pipelines.
• Experience working in Agile and distributed team environments.
• Financial services or other regulated-industry experience is preferred.
• Equivalent experience, technical training, certifications, or demonstrable project work may be considered in place of formal qualifications.

Day-to-Day Activities

• Review requirements, source data, mappings, and acceptance criteria.
• Design and develop Python and Snowflake data solutions.
• Write and optimize SQL transformations.
• Monitor pipelines and resolve data-quality or operational issues.
• Create tests, perform code reviews, and support deployments.
• Attend Agile ceremonies and technical discussions.
• Collaborate with stakeholders to clarify requirements and priorities.
• Maintain technical documentation and support procedures.
• Identify opportunities to improve reliability, automation, performance, cost, and sustainability.

Qualifications

• Bachelor’s degree in computer science, information systems, engineering, mathematics, or a related field, or equivalent practical experience.
• Snowflake, AWS, database, or data engineering certifications are preferred.
• Completion of applicable Synechron training in security, privacy, compliance, Agile delivery, and engineering standards.
• Commitment to ongoing learning in Snowflake, Python, SQL, AWS, security, and data engineering practices.

Professional Competencies

• Analytical thinking and structured problem solving.
• Clear communication with technical and business stakeholders.
• Effective collaboration across distributed teams.
• Ability to manage priorities, deadlines, dependencies, and production issues.
• Adaptability to changing requirements and technologies.
• Commitment to quality, security, documentation, and continuous improvement.
• Interest in practical automation and efficient, sustainable use of cloud resources.

SYNECHRON’S DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more. All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Candidate Application Notice

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 14,500+, and has 58 offices in 21 countries within key global markets. For more information on the company, please visit our website or LinkedIn community. At Synechron, we are committed to integrating sustainability into our business strategy, ensuring responsible growth while minimizing environmental impact. Employees play a key role in driving our sustainability initiatives, from reducing our carbon footprint to fostering ethical and sustainable business practices across global operations. All positions are required to adhere to our Sustainability and Health Safety standards, demonstrating a commitment to environmental stewardship, workplace safety, and sustainable practices.