Data Engineer
Hyderabad, IndiaMumbai, India Permanent Date posted Oct. 29, 2024
- Job Title: Data Engineer
- Location: Hyderabad
At Opella (a Sanofi Consumer Healthcare Business Unit), we build trusted and loved brands that connect with hundreds of millions of consumers worldwide. Our mission is to enable better self-care for individuals and communities, while also contributing to a healthier planet. We strive to act as a force for good by integrating sustainability along our business and employees’ mission and operate responsibly from both a social and environmental point of view. To achieve this, we need people who can shape the future of our business and help us on our journey to becoming the best fast-moving consumer healthcare company in and for the world.
About the Job
This position reports to the Senior Data Architect in the Consumer Healthcare business unit (Opella) at Sanofi.
This position will collaborate with multiple business functions to provide guidance in implementing the right data model and practices that meet their needs.
S/he will closely work with the data engineering team, Architects and the data governance team to create a logical data model architecture for various data objects.
S/he will work on modern data architecture techniques and cloud data technologies.
The candidate must be able to work independently and collaboratively.
s/he will work with a diverse team of business analysts, data scientists, technical engineers, data architects, and project managers to deliver outcomes aligned with our business needs.
Key Responsibilities:
- Design, build, and maintain end-to-end data pipelines using Apache Airflow, dbt, and Snowflake.
- Develop, test, and optimize Python scripts for data extraction, transformation, and loading.
- Manage and administer Snowflake cloud databases, ensuring high availability, security, and performance.
- Use dbt to implement modular and reusable transformations for efficient data modeling and reporting.
- Leverage Elementary for data observability, ensuring the quality, accuracy, and reliability of the data pipelines.
- Collaborate with cross-functional teams to gather data requirements, align on data models, and support data-driven projects.
- Monitor, troubleshoot, and continuously optimize data workflows, ensuring they meet business SLAs and performance requirements.
- Implement best practices in data governance, security, and compliance to ensure data privacy and integrity.
- Work closely with the analytics team to prepare datasets for analysis, reporting, and machine learning initiatives.
QUALIFICATIONS
- 5+ years of hands-on experience in data engineering with a focus on Airflow, Python, Snowflake, dbt, and Elementary.
- Strong proficiency in Python for data manipulation, scripting, and process automation.
- Deep understanding of data pipeline orchestration using Apache Airflow.
- Experience with Snowflake cloud database architecture, including Snowpipe, warehouse management, and query optimization.
- Expertise in using dbt for building, transforming, and modeling data at scale.
- Familiarity with Elementary for ensuring data quality and pipeline observability.
- Strong knowledge of SQL for querying relational databases and transforming data.
- Experience with data modeling, performance tuning, and schema design.
- Solid understanding of data governance, security practices, and data privacy regulations.
- Excellent problem-solving skills, attention to detail, and ability to work independently and collaboratively.
- Experience with additional cloud platforms such as AWS or Azure.
- Familiarity with CI/CD pipelines and version control tools like Git.
- Understanding of modern data architecture, including data lakes, and real-time data processing frameworks.
- Knowledge of analytics and BI tools like Tableau, Power BI, or Looker.
Education
- Bachelor’s degree in computer science, Information Technology, or a related field.
- Fluent in English
- Work with multicultural and multi-sourced teams.
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.