Database Engineering Specialist

• Location: Budapest – Sanofi Business Services, Váci Greens

• Hybrid working

About Sanofi: 

We are an innovative global healthcare company, driven by one purpose: we chase the miracles of science to improve people’s lives. Our team, across some 100 countries, is dedicated to transforming the practice of medicine by working to turn the impossible into the possible. We provide potentially life-changing treatment options and life-saving vaccine protection to millions of people globally, while putting sustainability and social responsibility at the center of our ambitions. 

Job summary: 

The Database Tech and Snowflake Center of Excellence (COE) team in the Data, AI and Governance organization has the mandate to build and operationalize data foundation platforms necessary for the enterprise data and analytics and insights initiatives, following industry standard practices and tools.  These new data platforms as part of OneMesh are built on Snowflake, AWS, Informatica Cloud, dbt, Airflow capabilities and support core business processes and analytics for all Global Business Units and Global Functions (GBU/GF) including Finance, HR, Manufacturing, Supply Chain, Procurement, and others function-specific processes.  Our Snowflake Data Cloud operates a landscape of approximately 40 warehouse accounts with data ingestion coming from approximately 200 different applications and database technologies including AWS Aurora, Oracle, SAP.  

The candidate who will take on this extended engineering specialist role will need to look after the Snowflake, dbt, and Airflow software platform health, usage, support, performance & cost, know about new releases, features, training and marketing, showcase innovation, etc.  In this role the candidate will move from a service mindset into a product management approach.

Job Duties and Responsibilities:

The Database Engineering Specialist will

• Responsible for technical design, administration, security and evolution of Snowflake, dbt and Airflow platform and services
  • Manage end to end deliverables leveraging internal experts, partners and do project management
  • Monitor project plans, provide overall coordination, and report status on regular basis
  • Develop work plans to manage key aspects of the technical solutions including documentation of specifications

• Coordinate with partners, infrastructure teams, project teams, products owners, scrum masters and vendors (Snowflake, dbt Labs, Amazon AWS) to address solution architecture design and delivery considerations
  • Work with internal and external team members to lead system integration planning, data sources integration and solution for key analytical projects
  • Evaluate, recommend, deploy and manage strategic application technology standards enabling the organization to maintain a technological and competitive edge
  • Be responsible for transfer of knowledge to the support teams

• Responsible for delivery of solutions using Agile methodology from detailed planning through execution, deployment and transfer of support services.  Enabling the capabilities of the OneMesh Snowflake, orchestration Airflow (MMWA) and dbt platform and service solutions.
  • Enable new analytics database capabilities as part of the Snowflake COE
  • Contribute to the Snowflake, Airflow and dbt platform best practices in support of digital projects  
  • Promote best practices on Airflow, dbt, Snowflake and data sharing to Digital project teams 

• Ensure to maintain high level standard, compliancy, and operational excellence in support of the Snowflake, dbt and Airflow platforms and services
  • Enforce compliance requirements of the solution in regards of GxP regulation
  • Remains up to date on company’s standards, industry practices and emerging technologies like Artificial Intelligence (AI) and Machine Learning (ML) solutions

Key Functional Requirements & Qualifications:

• Experience working with a variety of cross-functional teams 
• Good understanding of agile/scrum development processes and concepts
• Able to work in a fast-paced, constantly evolving environment and manage multiple priorities  
• Pragmatic and capable of solving complex issues  
• Service-oriented, flexible team player 
• Attention to detail & technical intuition 
• Excellent written, verbal, and interpersonal skills for executive level communication and collaboration
• Fluent in English (Other languages a plus)

Key Technical Requirements & Qualifications:

• Bachelor’s Degree or equivalent in in Computer Science, Engineering, or relevant field
• Excellent conceptual understanding of structured databases, modelling, and data ingestion
• Relevant cloud certifications (AWS, Azure, Snowflake) are a plus
• 5 years experiences with AWS, Azure cloud services
• Experience with Snowflake platform is a must have (account, security, provisioning, cost, data sharing and stream implementation)
• 5 years experiences with other RDBMS such as PostgreSQL, MySQL, SQL Server, Oracle
• 5 years experiences working with data models, ETL/ELT, data warehouse and query tuning

• Experience with ETL/ELT tools like Informatica Cloud and dbt
• Strong experience in deployment of cloud databases, hosting platforms, storage and migration services such as AWS SCT and DMS

• Strong experience in automation tools and methodologies specifically using Gitlab, Github action, Terraform, Ansible
• Experience with programming languages such as Python, JSON, YAML, Shell Scripting, SQL 
• Experience with Project Management Tools (JIRA, Confluence a plus)
• Good knowledge of Azure AD, ServiceNow and monitoring tool such as Splunk

• 5+ years experiences in a data team as Data Engineer or data warehouse DBA

Why choose us?

• An international work environment, in which you can develop your talent and realize ideas and innovations within a competent team

• Bring the miracles of science to life alongside a supportive, future-focused team

• An environment based on last technologies and frequent training to reinforce your profile

• Work from an "Office of the Year 2024" finalist office

 

#Sanofi #WeNeverSettle #SanofiCareers #PursueProgress #DiscoverExtraordinary #joinsanofi #careerswithpurpose #SBSBUDAPEST #LI-EUR #LI-Hybrid

Pursue progress, discover extraordinary

Better is out there. Better medications, better outcomes, better science. But 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. So, let’s be those people.

At Sanofi, we provide equal opportunities to all regardless of race, colour, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, ability or gender identity.

Watch our ALL IN video and check out our Diversity Equity and Inclusion actions at sanofi.com!