Database Engineering Specialist
Sanofi Group
+ 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 (https://www.youtube.com/watch?v=SkpDBZ-CJKw&t=67s) and check out our Diversity Equity and Inclusion actions at sanofi.com (https://www.sanofi.com/en/our-responsibility/equality-and-inclusiveness) !
Global Terms & Conditions and Data Privacy Statement (https://www.sanofi.com/en/careers/global-terms-and-conditions/)
Sanofi is dedicated to supporting people through their health challenges. We are a global biopharmaceutical company focused on human health. We prevent illness with vaccines, provide innovative treatments to fight pain and ease suffering. We stand by the few who suffer from rare diseases and the millions with long-term chronic conditions.
With more than 100,000 people in 100 countries, Sanofi is transforming scientific innovation into healthcare solutions around the globe. Discover more about us visiting www.sanofi.com or via our movie We are Sanofi (https://youtu.be/96EwNjb1TLo)
As an organization, we change the practice of medicine; reinvent the way we work; and enable people to be their best versions in career and life. We are constantly moving and growing, making sure our people grow with us. Our working environment helps us build a dynamic and inclusive workplace operating on trust and respect and allows employees to live the life they want to live.
All in for Diversity, Equity and Inclusion at Sanofi - YouTube (http://www.youtube.com/watch?v=SkpDBZ-CJKw&t=2s)
Por favor confirme su dirección de correo electrónico: Send Email