Roche Logo

Roche

Snowflake Data Engineer

Posted 15 Days Ago
Pune, Maharashtra
Mid level
Pune, Maharashtra
Mid level
The Data Engineer will design, implement, and maintain data pipelines in Snowflake while optimizing SQL queries and managing data workflows. This role emphasizes collaboration with business stakeholders and requires expertise in data integration and transformation.
The summary above was generated by AI

Roche fosters diversity, equity and inclusion, representing the communities we serve. When dealing with healthcare on a global scale, diversity is an essential ingredient to success. We believe that inclusion is key to understanding people’s varied healthcare needs. Together, we embrace individuality and share a passion for exceptional care. Join Roche, where every voice matters.

The Position

Position: Data and Analytics Specialist
As a member of Roche Informatics' Data Advisory & Insights team, the Data and Analytics Specialist plays
a crucial role in building and maintaining strong relationships with business stakeholders across different
functions. In this role, you will work in an agile product team, understanding the analytical needs of the
domain and utilizing your expertise in data and analytics to fulfill those needs. With a proven track
record in understanding the true requirements of business stakeholders, you will collaborate as a team
player in delivering data products. Additionally, you are comfortable with ambiguity, able to work
independently with minimal oversight.
Context:
We are seeking a skilled and motivated Data Engineer with expertise in Snowflake, strong SQL, and ETL
background to join our growing team. The ideal candidate will have a proven track record in designing,
implementing, and maintaining data pipelines and data warehousing solutions. Assist in designing, planning,
and executing architectural projects under the guidance of senior architects. If you are passionate about data engineering and
want to work with cutting-edge technologies and contribute to a modern data architecture, this is the perfect opportunity for you
Key Responsibilities:
● Design, implement, and maintain scalable data pipelines in Snowflake to support data
integration, transformation, and analysis.
● Design and implement scalable data architectures on Snowflake.
● Assist in developing architectural designs and technical drawings.
● Prepare project documentation, reports, and presentations.
● Develop and optimize SQL queries for efficient data retrieval and transformation.
● Work on ETL processes to ensure smooth data ingestion, cleaning, and transformation from
multiple sources into Snowflake. Prior experience with SAP BW sources is preferred.
● Experience in ingesting data through APIs is mandatory.
● Work with SQL, Python, and DBT for data processing and transformations.
● Implement role-based access controls and security measures in Snowflake.
● Troubleshoot and optimize existing data pipelines for better performance and scalability.
● Integrate and automate data workflows using Snowflake, Dataiku, or other automation tools.
● Ensure data integrity, security, and compliance with best practices.
Required Skills & Qualifications:
● 5-6 years of experience in data engineering, with a focus on Snowflake and Talend ETL processes.
● Strong expertise in SQL (e.g., writing complex queries, optimizing query performance) and Snowflake SnowSQL.
● Proven experience in designing and implementing scalable ETL pipelines
● Hands-on experience working with Snowflake for data warehousing, including optimizing queries
and managing Snowflake environments.
● Deep understanding of Snowflake advanced features (clustering, micro-partitioning, time travel).
● Knowledge of data modeling, and warehousing.
● Experience in Python for data processing, automation, and scripting.
● Strong problem-solving and analytical skills with attention to detail.
● Excellent communication and collaboration skills.
Nice to Have:
● Experience with data orchestration tools like Apache Airflow or similar.
● Familiarity with cloud platforms like AWS, Azure, or Google Cloud.
● Experience with version control systems (e.g., Git).
● Experience with Talend.

#LI-DNI

Who we are

At Roche, more than 100,000 people across 100 countries are pushing back the frontiers of healthcare. Working together, we’ve become one of the world’s leading research-focused healthcare groups. Our success is built on innovation, curiosity and diversity.

Roche is an Equal Opportunity Employer.

Top Skills

Apache Airflow
AWS
Azure
Dataiku
Dbt
ETL
GCP
Python
Snowflake
SQL
Talend

Roche Pune, Mahārāshtra, IND Office

671-75 Ganeshkhind Road, Pune, Maharashtra, India, 411005

Similar Jobs

7 Days Ago
3 Locations
Senior level
Senior level
Artificial Intelligence • Big Data • Machine Learning
Design and implement data solutions using Snowflake, develop ETL pipelines, optimize performance, and manage large-scale data projects with cloud technologies.
Top Skills: AirflowApache NifiAWSAzureBig QueryCloud Pub-SubDatabricksGCPGoogle DataflowHadoopHd-InsightsKafkaKinesisLookerOoziePower BIPysparkPythonRedshiftScalaSnowflakeSparkSQLSynapseTableau
9 Days Ago
Pune, Maharashtra, IND
Mid level
Mid level
Healthtech • Biotech • Pharmaceutical
As a Data Engineer at Roche, you'll design ETL/ELT pipelines, optimize data solutions, and collaborate on analytics to enhance data utilization.
Top Skills: AWSAzureCi/Cd ToolsDbtEltETLGCPInmutaJavaMonte CarloPythonSnowflakeSQL
Senior level
Payments
The Lead Software Engineer will design cloud-based solutions, develop frameworks, and manage Big Data warehouses while leading cross-functional agile teams.
Top Skills: AthenaAWSAzureAzure Data FactoryDatabricksNifiPythonRSnowflakeSnowpipe

What you need to know about the Pune Tech Scene

Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account