Data Engineer
Hyderabad, IndiaMumbai, India Permanent Date posted Oct. 21, 2024
- Job Title: Data Engineer
- Location: Hyderabad
- Job: Permanent
Position Overview:
- This position will report to the Senior Data Architect within the Consumer Healthcare business unit (Opella) at Sanofi. The Data Engineer will collaborate across multiple business functions and work closely with data scientists, data architects, and data governance teams to implement scalable data pipelines and platforms that support various business needs.
- S/he should have strong expertise in Snowflake, Python, AWS, dbt, and Git to join our data engineering team.
- The successful candidate will be responsible for designing, building, and optimizing data pipelines to support advanced analytics and business intelligence initiatives. You will work with cutting-edge cloud technologies to ensure data is accessible, clean, and optimized for use by various teams across the organization.
- This role requires someone who can collaborate effectively with data architects, analysts and business stakeholders to deliver scalable and high-performance data solutions
Key Responsibilities:
The Data Engineer will be responsible for:
- Design, develop, and maintain data pipelines using Python and dbt to ingest, transform, and store data in Snowflake.
- Build and manage Snowflake data warehouses and data marts, ensuring efficient and scalable data architectures.
- Leverage AWS services (e.g., S3, Lambda, Glue, EC2) to develop cloud-based data pipelines and automate data workflows.
- Develop ETL/ELT pipelines to load data into Snowflake, ensuring performance, scalability, and reliability.
- Optimize data queries and performance within Snowflake, ensuring efficient use of resources and minimizing query costs.
- Use dbt for transforming and modeling data in Snowflake, implementing robust testing, documentation, and version control processes.
- Implement and manage CI/CD pipelines for data engineering projects using Git to ensure smooth development, testing, and deployment processes.
- Ensure data quality, integrity, and consistency through best practices in data governance, documentation, and monitoring.
- Troubleshoot and optimize existing data workflows, resolving any issues with data ingestion, processing, or query performance.
Qualification
- 7+ years of experience in Data Engineering, with a strong focus on database development, ETL/ELT processes, and cloud platforms.
- Strong experience with Snowflake as a data warehouse platform, including data modeling, performance tuning, and optimization.
- Proficiency in Python for building data pipelines, automation, and data transformations.
- Hands-on experience with AWS cloud services, particularly S3, Lambda, Glue and EC2.
Expertise in dbt for managing and transforming data within Snowflake. - Experience with SQL for complex data queries, transformations, and performance optimization.
- Familiarity with Git for version control, branching, and collaborating on data engineering projects.
- Experience building and maintaining ETL/ELT pipelines in cloud environments.
Excellent troubleshooting skills with the ability to optimize and improve existing data processes. - Ability to work independently and in collaboration with cross-functional teams.
Strong communication skills to effectively interact with technical and non-technical stakeholders.
Education:
- Bachelor’s degree in computer science, Information Technology, Data Engineering, or a related field.
Pursue progress. Discover extraordinary.
Progress doesn’t happen without people – people from different backgrounds, in different locations, doing different roles, all united by one thing: a desire to make miracles happen. You can be one of those people. Chasing change, embracing new ideas and exploring all the opportunities we have to offer. Let’s pursue progress. And let’s discover extraordinary together.
At Sanofi, we provide equal opportunities to all regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, or gender identity.
Watch 'One day at Sanofi' and check out our Diversity Equity and Inclusion initiatives at sanofi.com
You have not viewed any jobs yet.
You have not saved any jobs yet.
Hubs
From Bogota to Budapest, Kuala Lumpur to Hyderabad – it’s your skills that help the Sanofi world go round. With a role in one of our Hubs, you’re right at the heart of our global transformation, as we fearlessly work together to cut the time it gets new treatments to patients. By making the most of your creativity and bringing your unique self you’re supportingyou’ll help others to perform at their best. Let’s make the discoveries that’ll change lives.
Find out more about this location
Experience possibility
-
-
Cambridge Crossing
We're bringing together 2,500 people from across our organization — R&D, Medical, Commercial and Global colleagues all working to realize the power of collaboration.
-
Innovation in Action
Our flexible lab of the future will transform how we conduct research, while our innovation center will be fully integrated with existing R&D locations.
-
Sustainable and Green
Our new facility was built to minimize the environmental impact — helping protect our planet and people. Using resources efficiently, we're providing greener, healthier workspaces.
-
Sanofi’s AI Centre of Excellence in Toronto
The Centre is focused on using leading technologies to develop world-class data and artificial intelligence (AI) products to create value for the health sector.
-
Ama
Ama puts her project management techniques and ServiceNow knowledge to use to help advance Sanofi’s Digital Data operating model. Learn how our team connects data and AI to do what’s never been done before.
-
Sanofi Canada's Philanthropic Efforts
By chasing the miracles of science to improve people’s lives, we surprise ourselves with what we can achieve. Our team is humbled by the impact our efforts make.
-
Emmanuel
Emmanuel, Head of the Sanofi Digital Accelerator, shares how his team builds digital solutions that enable patients to receive new treatments to help improve their lives.
-
Dimitrije
Dimitrije shares insights into the work carried out by the AI Centre of Excellence in Toronto.
-
Ziv
Read Ziv's first-hand account describing the reasons he chose to join Sanofi – and many of the reasons why he now chooses to stay.
-
When you grow, we all grow
We strive to support your whole self with thoughtfully crafted rewards that benefit you physically, financially, mentally and socially. Whatever your role, you'll thrive in our inclusive teams.
-
Build a career with purpose
Bring your passion to your role and impact millions of people around the world. You're in the driver's seat – just set your goals, and we'll provide the training and support that will get you there.
-
Bolder, better futures
Change your life. And the lives of millions around the globe. How? By starting a career where you're supported to grow, while having a tangible impact and learning from the best.
-
Our locations
We're in 60+ countries, all pulling together to define the future of healthcare. Wherever you work, you'll develop your career alongside experts, using technology to chase bigger breakthroughs.
-
Sanofi Stories
At Sanofi every voice matters. Get to know the talented Sanofians shaping our future and pushing us toward our ambitious goals.
-
Sanofi at Cambridge Crossing
Dubbed Sanofi at Cambridge Crossing, our new state-of-the-art facility will create an innovation hub promoting close collaboration and integration among business units. Join us and become part of a team dedicated to chasing the miracles of science that improve people’s lives.
-
Why Sanofi
Get access to the tools, training, and support to reach your goals. By fulfilling your potential, you’ll help us achieve our aim of halving the time from discovery to therapy.
-
Our people & culture
We're the first in Pharma to have a DE&I board. We also have Employee Resource Groups that create spaces for every Sanofian to be heard. Your voice matters – use it to shape our future.
-
Sanofi's Postdoctoral Program
Designed for high-caliber Ph.D. graduates, Sanofi's Postdoctoral Program helps you advance your scientific career in a state-of-the-art environment.
-
Physician Careers at Sanofi
At Sanofi, physicians like you have the opportunity to collaborate on new ideas and challenge established thinking. Learn about Physician careers here.
-
AI Centre of Excellence
The AI Centre of Excellence at Sanofi is a unique data-driven team based in Downtown Toronto. We pride ourselves on being data-obsessed and highly focused on using state-of-the-art technologies to drive global impact.
What could we achieve together?
Want to join our Global Talent Community? Every Sanofian works on projects that truly make a difference to people’s lives.
What could you achieve? Sign up today and discover our latest opportunities as soon as they’re available.