Python with SQL [Snowflake]

About Us

We believe the future of software development is AI-native — where engineers operate at a higher level of abstraction and quality remains non-negotiable. 

Incubyte is a software craft consultancy where the “how” of building software matters as much as the “what”.  

We partner with companies of all sizes, from helping enterprises build, scale, and modernize to early-stage founders bring their ideas to life. 

Our engineers operate in an AI-native development model, using AI as a collaborator across the SDLC to accelerate development while upholding the discipline of software craftsmanship. Guided by Software Craftsmanship and Extreme Programming practices, we build reliable, maintainable, and scalable systems with speed, without compromising quality. If this way of building software resonates with you, we’d like to talk. 

Our Guiding Principles 

These principles define how we work at Incubyte. They are non-negotiable. 

Relentless Pursuit of Quality with Pragmatism 

  We build high-quality systems without losing sight of delivery. 

Extreme Ownership 

  We take responsibility end-to-end for decisions, execution, and outcomes. 

Proactive Collaboration 

  We collaborate closely, challenge each other, and solve problems together. 

Active Pursuit of Mastery 

  We continuously improve our craft and raise our bar. 

Invite, Give, and Act on Feedback 

We seek, give, and act on feedback to get better every day. 

Ensuring Client Success 

We act as trusted partners and focus on real outcomes, not just output. 

Job Description

This is a remote position.

Experience Level

2+ years of experience in SQL, Python, and Snowflake (or equivalent cloud data warehouse), Azure Cloud services.

Role Overview

If you're a Data Craftsperson who takes pride in clean, well-tested data solutions and believes in the principles of Extreme Programming, we'd love to meet you. At Incubyte, we're a DevOps organization where developers own the entire release cycle — you'll get hands-on experience across data engineering, analytics, cloud infrastructure, and direct client communication. This role sits primarily in data engineering (80%) with a meaningful analytics component (20%), supporting our client's data systems end-to-end.

What You'll Do

• Design, build, and maintain data pipelines and infrastructure using SQL and Python
• Work within Snowflake to build and optimize data models supporting business use cases
• Parse and process structured and semi-structured data (JSON, XML) from varied sources
• Diagnose issues across raw, intermediate, and summary tables
• Build SQL queries to support repeatable analytics use cases based on stakeholder requirements
• Investigate and resolve data quality issues, including time-sensitive or urgent ones
• Identify opportunities to consolidate models and maintain a single source of truth (SSOT)

Requirements

What We're Looking For

• 2+ years of experience with SQL and relational databases, with the ability to understand complex data relationships and transformations (required)
• 2+ years of experience with Python for data engineering tasks (required)
• Experience with Snowflake or an equivalent cloud data warehouse (required)
• Experience working with Snowflake Coco or any other AI tools(required) 
• Experience parsing JSON and XML data (a plus)
• A strong eye for data quality and attention to detail
• Knowledge of Git (required)
• Knowledge of Azure cloud services such as Azure Data Factory, Azure Blob Storage, and Azure SQL Database (required)
• Knowledge of data infrastructure/modeling tools like DBT, Fivetran (a plus)
• Experience with BI tools like Power BI(a plus, not core to this role)
• Knowledge of Docker, Linux, Shell/Bash, and virtualization technologies (a plus)
• Knowledge of SSIS packages (a plus)
• Familiarity with CI/CD methodologies

Benefits

Life at Incubyte  

We are a remote-first company with structured flexibility. Teams commit to shared rhythms during core hours, ensuring smooth collaboration while maintaining autonomy. Twice a year, we come together in person for a co-working sprint and once a year for a retreat - with all travel expenses covered. 

Our environment is built for crafters: pairing, refactoring, experimenting with AI, and pushing the boundaries of software excellence. We are all lifelong learners, and our work is our passion. 

Perks

• Dedicated learning & development budget. 
• Sponsorship for conference talks. 
• Comprehensive medical & term insurance.
• Employee-friendly leave policies. 
• Home Office fund 
• Medical Insurance

Location: Hyderabad / Chennai

Experience: 5+ years

Employment type: Full-time, permanent

Work Hours: General Shift

website: www.amazech.com

Qualifications: 

• B.E./B.Tech/M.E./M.Tech in Computer Science, Information Technology, Data Science, or related disciplines.
• Strong academic background with relevant industry experience in Data Engineering and Data Warehousing.

Key Responsibilities:

·       Design, develop, and maintain scalable data warehouse solutions using Snowflake.

·       Write, optimize, troubleshoot, and enhance Snowflake SQL queries with a focus on performance and scalability.

·       Develop and support ETL processes using Talend to ensure reliable and efficient data movement.

·       Collaborate with business, analytics, and application teams to enable reporting, dashboards, metrics, and data exploration capabilities.

·       Perform data analysis and resolve issues across data ingestion, transformation, and reporting pipelines.

·       Debug and troubleshoot Python-based data processing scripts and automation workflows.

·       Implement best practices for data quality, testing, deployment, and code reviews.

·       Work across UI, API, and Data Warehouse layers to support end-to-end data integration and business requirements.

·       Monitor, optimize, and maintain data warehouse performance and operational stability.

·       Create and maintain technical documentation, data models, and process workflows.

Required Skills and Experience: 

·       Strong hands-on expertise in Snowflake Data Warehouse.

·       Advanced SQL skills with experience handling large-scale datasets.

·       Strong understanding of Data Warehousing concepts, dimensional modelling, and data architecture.

·       Hands-on experience with Analytical SQL functions, query tuning, and performance optimization.

·       Experience developing and maintaining ETL solutions using Talend.

·       Proficiency in Python for scripting, debugging, automation, and data processing.

·       Experience integrating UI, API, and Data Warehouse workflows.

·       Strong problem-solving and analytical skills.

·       Experience with testing, code reviews, and deployment best practices.

·       Excellent communication and stakeholder management skills.

About the Role

You'll be at the forefront of designing and implementing robust data platform solutions that power advanced analytics, AI, and machine learning. Working with modern cloud technologies, you'll build scalable data foundations that enable clients to make smarter, data-driven decisions.

Key Responsibilities

• Build scalable data pipelines using Snowflake, AWS, GCP, and Databricks.
• Design and optimize data models for AI and machine learning workloads.
• Develop reliable data foundations for MLOps, governance, and data lineage.
• Integrate data from multiple sources into modern data platforms.
• Leverage Snowpark ML and Snowflake's native AI capabilities.
• Ensure data platforms are secure, scalable, and high-performing.

What We're Looking For

• 5+ years of hands-on experience with Snowflake.
• Strong proficiency in SQL and Python.
• Experience with AWS, Azure, or GCP.
• Knowledge of cloud storage services such as S3, ADLS, or GCS.
• Strong understanding of Dimensional Modeling and Data Vault.
• Experience with Scala or Java is a plus.

Tech Stack

• Data Warehouse: Snowflake
• Programming: SQL, Python, Scala (Good to Have), Java (Good to Have)
• Cloud: AWS, Azure, GCP
• Storage: S3, ADLS, GCS
• AI/ML: Snowpark ML, MLOps

Perks & Benefits

• Public Speaking & Communication Program
• Mentoring Program with Senior Support Leads
• 360° Progress Reviews
• Weekly Learning Sessions & Guilds
• Paid Certifications
• Hackathons & Innovation Days
• Recognition & Rewards Programs
• Team Socials & Annual Offsites
• Employee Assistance Program (24/7 Wellbeing Support)

The Data People Shaping Tomorrow

Our client helps organizations unlock the power of data through modern cloud, analytics, and AI solutions. We believe in creating an environment where talented technologists can learn, innovate, and make a real impact while building cutting-edge data platforms for global clients. If you're passionate about data engineering and want to work with the latest technologies in AI, cloud, and analytics, we'd love to hear from you.

🚀 Job Title : Data Engineer – AWS, PySpark & Airflow

Experience : 5+ Years

Industry : Health Insurance / BFSI

Location : Sector 43, Gurugram, Haryana

Work Mode : Work From Office (5 Days a Week)

Employment Type : Full-Time

Role Overview :

We are looking for an experienced Data Engineer with strong hands-on expertise in AWS Data Engineering, Data Lake Architecture, Python, SQL, PySpark, and Apache Airflow.

The candidate will be responsible for designing, developing, and maintaining scalable, reliable, and high-performance data pipelines using AWS cloud technologies. The role involves building end-to-end ETL / ELT workflows, implementing data transformation and processing solutions, optimizing pipeline performance, and ensuring the reliability of production data systems.

Mandatory Skills :

AWS Data Engineering | Data Lake Architecture | Amazon S3 | AWS Glue | Amazon EMR | Athena | Redshift | Python | SQL | PySpark | Apache Spark | Apache Airflow | ETL/ELT | PostgreSQL | Data Modelling | Pipeline Optimization | Production Support | Root Cause Analysis

Key Responsibilities :

• Design, develop, and maintain end-to-end data pipelines for data ingestion, staging, transformation, curation, and consumption.
• Build and manage AWS-based data lake solutions using Amazon S3, AWS Glue, Amazon EMR, Athena, and Redshift.
• Develop, maintain, and optimize ETL / ELT pipelines using Python, SQL, Apache Spark, and PySpark.
• Implement and manage workflow orchestration using Apache Airflow, including scheduling, dependency management, retries, monitoring, and failure handling.
• Integrate data from multiple structured and semi-structured sources.
• Design and maintain data models, dimensional models, and analytical data marts.
• Work with relational databases, including PostgreSQL and Amazon RDS.
• Optimize Spark jobs, SQL queries, data transformations, and cloud resource utilization.
• Implement data quality checks, validation rules, and error-handling mechanisms.
• Monitor production data pipelines, troubleshoot failures, and perform root cause analysis (RCA).
• Ensure pipeline reliability, scalability, performance, and compliance with service-level agreements (SLAs).
• Follow data security, access management, governance, and sensitive-data protection best practices.
• Collaborate with business, analytics, and application teams to deliver effective data solutions.
• Maintain technical documentation and follow established data engineering standards.

Required Technical Skills :

• AWS Data Engineering : Strong hands-on experience with AWS-based data engineering and data lake architecture.
• AWS Services : Amazon S3, AWS Glue, Glue Data Catalog, Amazon EMR, Athena, Redshift, AWS Lambda, and IAM.
• Programming : Strong proficiency in Python and SQL.
• Big Data Processing : Hands-on experience with Apache Spark and PySpark.
• Workflow Orchestration : Experience developing and managing workflows using Apache Airflow.
• ETL/ELT Development : Experience building scalable data ingestion, transformation, and processing pipelines.
• Database Technologies : Good understanding of relational databases and PostgreSQL concepts.
• Data Modelling : Experience with data modelling, data transformation, and analytical data structures.
• Production Support : Ability to monitor pipelines, troubleshoot failures, perform RCA, and resolve production issues.
• Performance Optimization : Experience optimizing SQL queries, Spark jobs, and data processing workflows.

Good-to-Have Skills :

• Experience with AWS Database Migration Service (DMS) and Amazon RDS.
• Familiarity with dbt for data transformation and modelling.
• Knowledge of Delta Lake, Apache Iceberg, or Apache Hudi.
• Exposure to Apache Kafka and real-time data streaming.
• Familiarity with GraphQL, Hasura, or similar data-serving technologies.
• Understanding of data governance and data quality frameworks.
• Experience in the BFSI, healthcare, or health insurance domain.

Candidate Requirements :

• 5+ years of relevant experience in Data Engineering.
• Proven hands-on experience building and maintaining production-grade data pipelines on AWS.
• Strong understanding of data lake architecture and large-scale data processing.
• Practical experience with Apache Airflow and Spark / PySpark-based transformations.
• Strong programming, analytical, debugging, and problem-solving skills.
• Experience handling production incidents, pipeline failures, and performance bottlenecks.
• Ability to take ownership of deliverables and work effectively with cross-functional teams.
• Good communication, collaboration, and technical documentation skills.
• Willingness to work from the Gurugram office five days a week.

Ideal Candidate :

The ideal candidate is a hands-on Data Engineer who can independently build, optimize, and maintain AWS-based data pipelines, work with large datasets using PySpark, orchestrate workflows through Airflow, and resolve production issues in a business-critical environment.

Sr. Data Engineer 

Location: Pune

Responsibilities 

· Lead the end-to-end design and development of scalable, high-performance data pipelines and ETL/ELT frameworks aligned with modern data engineering best practices. 

· Architect complex data integration workflows that bring together structured, semi-structured, and unstructured data from both cloud and on-premise sources. 

· Build robust real-time, batch, and on-demand pipelines with built-in observability—monitoring, alerting, and automated error handling. 

· Partner with analysts, data scientists, and business leaders to define and deliver reliable data models, quality frameworks, and SLAs that power key business insights. 

· Ensure optimal pipeline performance and throughput, with clearly defined SLAs and proactive alerting for data delivery or quality issues. 

· Collaborate with platform, DevOps, and architecture teams to build secure, reusable, and CI/CD-enabled data workflows that align with enterprise architecture standards. 

· Establish and enforce the best practices in source control, code reviews, testing automation, and continuous delivery for all data engineering components. 

· Lead root cause analysis (RCA) and preventive maintenance for critical data failures, ensuring minimal business impact and continuous service improvement. 

· Guide the team in establishing standards for data modeling, transformation logic, and governance, ensuring long-term maintainability and scalability. 

· Design and execute comprehensive testing strategies—unit, integration, and system testing—ensuring high data reliability and pipeline resilience. 

· Monitor and fine-tune data pipeline and query performance, optimizing for reliability, scalability, and cost-efficiency. 

· Create and maintain detailed technical documentation, including data architecture diagrams, process flows, and integration specifications for internal and external stakeholders. 

· Facilitate and lead discussions with business and operational teams to understand data requirements, prioritize initiatives, and drive data strategy forward. 

Qualifications 

· 7 to 10 years of hands-on experience in data engineering roles with a proven record of building scalable and secure data platforms. 

· Over 5 years of experience in scripting languages such as Python for data processing, automation, and ETL development. 

· 4+ years of experience with Snowflake, including performance tuning, security model design, and advanced SQL development. 

· 5+ years of experience with data integration tools such as Azure Data Factory, Fivetran, or Matillion. 

· 5+ years of experience in writing complex, highly optimized SQL queries on large datasets. 

· Proven experience integrating and managing APIs, JSON, XML, and webhooks for data acquisition. 

· Hands-on experience with cloud platforms (Azure/AWS) and orchestration tools like Apache Airflow or equivalent. 

· Experience with CI/CD pipelines, automated testing, and code versioning tools (e.g., Git). 

· Familiarity with dbt or similar transformation tools and best practices for modular transformation development. 

· Exposure to data visualization tools like Power BI for supporting downstream analytics is a plus. 

· Strong interpersonal and communication skills with the ability to lead discussions with technical and business stakeholders. 

Education 

Bachelor’s or Master’s degree in Computer Science/Information technology or related field. 

Equivalent academic and work experience can be considered. 

Strong Data Engineer (AWS) Profile

2

Mandatory (Experience 1) – Must have minimum 6+ years of experience in Data Engineering, with strong experience designing, developing, and maintaining scalable data pipelines and ETL processes.

3

Mandatory (Experience 2) – Must have 3+ years of hands-on experience with AWS data engineering services, particularly S3, AWS Glue, EMR, Lambda, and Redshift.

4

Mandatory (Experience 3) – Must have strong programming experience in Python, Java, or Scala, with hands-on development of data processing and pipeline solutions.

5

Mandatory (Experience 4) – Must have strong expertise in SQL, data warehousing, and database technologies, including experience with both SQL and NoSQL databases.

6

Mandatory (Experience 5) – Must have hands-on experience working with Big Data technologies and distributed data processing, including designing and optimizing large-scale data pipelines.

7

Mandatory (Experience 6) – Must have experience with data pipeline troubleshooting, monitoring, data quality, governance, and security best practices.

8

Mandatory (Education) – B.Tech / B.E./ M.Tech

Strong Data Engineer (AWS) Profile

2

Mandatory (Experience 1) – Must have minimum 6+ years of experience in Data Engineering, with strong experience designing, developing, and maintaining scalable data pipelines and ETL processes.

3

Mandatory (Experience 2) – Must have 3+ years of hands-on experience with AWS data engineering services, particularly S3, AWS Glue, EMR, Lambda, and Redshift.

4

Mandatory (Experience 3) – Must have strong programming experience in Python, Java, or Scala, with hands-on development of data processing and pipeline solutions.

5

Mandatory (Experience 4) – Must have strong expertise in SQL, data warehousing, and database technologies, including experience with both SQL and NoSQL databases.

6

Mandatory (Experience 5) – Must have hands-on experience working with Big Data technologies and distributed data processing, including designing and optimizing large-scale data pipelines.

7

Mandatory (Experience 6) – Must have experience with data pipeline troubleshooting, monitoring, data quality, governance, and security best practices.

8

Mandatory (Education) – B.Tech / B.E./ M.Tech

Immediate Joining

We are looking for a Dedicated Resource on Contract for –

Role: Data Engineer

Experience: 5+ Years

Location: Remote

Duration: 3+ Months

Strong hands-on experience with Snowflake, including writing SQL queries, creating views, stored procedures, and functions.

Good knowledge of AI tools such as Claude.

Experience with ETL tools like Alteryx is good to have.

Power BI experience is good to have.

Strong communication skills.

SENIOR DATA ENGINEER – DATABRICKS & SNOWFLAKE

Experience: 7+ Years

Location: Remote

Employment Type: Full-Time

Budget: Up to ₹30 LPA

Time Zone: US Eastern Time (ET)

Shift: US ET Night Shift

Job Description

We are looking for an experienced Senior Data Engineer with strong expertise in Databricks, Snowflake, Apache Spark, and AWS to design, develop, and maintain scalable data engineering solutions.

The candidate will work on integrating data from multiple sources, building modern data pipelines, developing enterprise data models, and preparing data platforms for AI/ML applications.

Experience in healthcare, scientific data, or the histopathology domain will be an added advantage.

Key Responsibilities

• Design, build, and maintain scalable data pipelines to acquire, integrate, and manage data from diverse sources such as laboratory systems, MES, clinical supply, quality systems, and external partners.
• Develop and optimize data workflows for structured and unstructured data using Python, PySpark, R, SQL, Databricks, and Snowflake.
• Design and maintain enterprise-level data models and data repositories.
• Perform ETL development, data warehousing, database design, and data integration.
• Ensure data quality, versioning, traceability, and consistency to support AI/ML readiness.
• Collaborate with stakeholders and technical teams to translate business requirements into technical solutions.
• Manage multiple projects while ensuring scalability, performance, and reliability.

Required Skills

• 7+ years of experience in Data Engineering.
• Strong hands-on experience with Databricks and Snowflake.
• Excellent knowledge of Apache Spark / PySpark.
• Strong experience with AWS cloud services and AWS RDS.
• Experience with Oracle and Microsoft SQL Server (MSSQL).
• Proficiency in Python, R, and SQL.
• Strong understanding of ETL, Data Warehousing (DWH), data modeling, and database design.
• Experience with dbt and cloud-based data architectures.
• Knowledge of NoSQL and graph databases.
• Strong analytical, problem-solving, and stakeholder-management skills.
• Good English communication skills (B2 level or above).
• Willingness to work in the US Eastern Time (ET) night shift.

Preferred / Good to Have

• Experience in histopathology, healthcare, life sciences, or scientific data environments.
• Knowledge of CDISC, HL7, FHIR, OMOP, DICOM, or other regulated data standards.
• Experience handling high-dimensional data, including imaging and sensor data.
• Familiarity with MLOps and machine learning model deployment workflows.
• Knowledge of Manufacturing Execution Systems (MES) and Laboratory Information Management Systems (LIMS).
• Exposure to knowledge graphs and ontology-driven architectures.

Education

Bachelor's degree in Engineering, Data Science, Life Sciences, Computer Science, or a related field. A master's degree is preferred.

Interested candidates can apply with their updated resumes.

Job Title : AWS Data Engineer

Experience : 4+ Years

Location : Bengaluru (HSR – Hybrid, 3 Days WFO)

Notice Period : Immediate Joiner

💡 Role Overview :

We are looking for a skilled AWS Data Engineer to design, build, and scale modern data platforms. The role involves working with AWS-native services, Python, Spark, and DBT to deliver secure, scalable, and high-performance data solutions in an Agile environment.

🔥 Mandatory Skills :

Python, SQL, Spark, AWS (S3, Glue, EMR, Redshift, Athena, Lambda), DBT, ETL/ELT pipeline development, Airflow/Step Functions, Data Lake (Parquet/ORC/Iceberg), Terraform & CI/CD, Data Governance & Security

🚀 Key Responsibilities :

• Design, build, and optimize ETL/ELT pipelines using Python, DBT, and AWS services
• Develop and manage scalable data lakes on S3 using formats like Parquet, ORC, and Iceberg
• Build end-to-end data solutions using Glue, EMR, Lambda, Redshift, and Athena
• Implement data governance, security, and metadata management using Glue Data Catalog, Lake Formation, IAM, and KMS
• Orchestrate workflows using Airflow, Step Functions, or AWS-native tools
• Ensure reliability and automation via CloudWatch, CloudTrail, CodePipeline, and Terraform
• Collaborate with data analysts and data scientists to deliver actionable insights
• Work in an Agile environment to deliver high-quality data solutions

✅ Mandatory Skills :

• Strong Python (including AWS SDKs), SQL, Spark
• Hands-on experience with AWS data stack (S3, Glue, EMR, Redshift, Athena, Lambda)
• Experience with DBT and ETL/ELT pipeline development
• Workflow orchestration using Airflow / Step Functions
• Knowledge of data lake formats (Parquet, ORC, Iceberg)
• Exposure to DevOps practices (Terraform, CI/CD)
• Strong understanding of data governance and security best practices
• Minimum 4–7 years in Data Engineering (3+ years on AWS)

➕ Good to Have :

• Understanding of Data Mesh architecture
• Experience with platforms like Data.World
• Exposure to Hadoop / HDFS ecosystems

🤝 What We’re Looking For :

• Strong problem-solving and analytical skills
• Ability to work in a collaborative, cross-functional environment
• Good communication and stakeholder management skills
• Self-driven and adaptable to fast-paced environments

📝 Interview Process :

1. Online Assessment
2. Technical Interview
3. Fitment Round
4. Client Round