Data Engineering Analyst

Data Engineering Analyst

• Location :

Barcelona - Spain

Ratan Roy

Establish technical designs to meet Sanofi requirements aligned with the architectural and Data standardsOwnership of the entire back end of the application, including the design, implementation, testing, and troubleshooting of the core application logic, databases, data ingestion and transformation, data processing and orchestration of pipelines, APIs, CI / CD integration and other processesFine-tune and optimize queries using Snowflake platform and database techniquesOptimize ETL / data pipelines to balance performance, functionality, and other operational requirements Assess and resolve data pipeline issues to ensure performance and timeliness of executionAssist with technical solution discovery to ensure technical feasibilityAssist in setting up and managing CI / CD pipelines and development of automated testsDeveloping and managing microservices using pythonConduct peer reviews for quality, consistency, and rigor for production-level solutionDesign application architecture for efficient concurrent user handling, ensuring optimal performance during high usage periodsPromote best practices and standards for code management, automated testing, and deploymentsOwn all areas of the product lifecycle :

design, development, test, deployment, operation, and supportCreate detail documentation on Confluence to be able to support and maintain codebase and its functionalityAbout you Experience developing backend, integration, data pipelining, and infrastructure with relevant technologies and tools (Snowflake, AWS, Spark, Informatica / IICS or equivalent).Bachelor’s degree in computer science, engineering, or similar quantitative field of studyExpertise in database optimization and performance improvementExpertise in Python, PySpark, and SnowparkExperience data warehouse and object-relational database (Snowflake and PostgreSQL) and writing efficient SQL queriesExperience in cloud-based data platforms (Snowflake, AWS)Proficiency in developing robust, reliable APIs using Python and FastAPI FrameworkExperience with job scheduling and orchestration (Airflow is a plus)Expert in ELT and ETL & Experience working with large data sets and performance and query optimization.Understanding of data structures and algorithmsExperience in modern testing framework (SonarQube, K6 is a plus)Strong collaboration skills, willingness to work with others to ensure seamless integration of the server-side and client-sideKnowledge of DevOps best practices and associated tools, a plus, especially in the setup, configuration, maintenance, and troubleshooting of associated tools :

Containers and containerization technologies (Kubernetes, Argo, Red Hat OpenShift)Infrastructure as code (Terraform)Monitoring and Logging (CloudWatch, Grafana)CI / CD Pipelines (JFrog Artifactory)Scripting and automation (Python, GitHub, Github actions)Languages :

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 our ALL IN video and check out our Diversity Equity and Inclusion actionsat sanofi.Com!#LI-EUR#GIC#LI-HybridPursue progress, discover extraordinaryBetter 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!SummaryLocation :

BarcelonaType :

Full time