Microsoft Azure Synapse Data Engineer
BARCELONA, B, ES, 08009
Allianz
As an international financial services provider, Allianz offers worldwide products and solutions in insurance and asset management.As part of a global finance project the migration from SAP R3 to SAP S4/HANA is being carried out. At the same time, the delivery route to the future SAP system will also be placed on a new basis. The aim of this data pool is to transfer the data from the supplying systems (feeders) into the input structures. The data pool is divided into a Core and a OE (=organizational entity) specific part. Most tasks are to be carried out in the OE specific part.
You will
-
Create data models for all elements to be modeled (tables, datamarts, etc.)
-
Implement the entire ETL processes as part of the architecture and processes specified by the project
-
Define and implement the necessary landing zone and data store for ingesting the raw data
-
Carry out the staging using data lake architecture and processes
-
Set up the raw data vault for the OE and across the board.
-
Set up the business data vault for OE and across the board.
-
Create customer-specific data warehouses and data marts within the scope of the Consumption Layer using data from different layers
Your Skills
5+ years experience with:
-
Microsoft Azure Data Technologies
-
Design of Data lake Solutions
-
Modeling of Raw- and Business Data vaults
-
Design of Datawarehouses and Datamarts
-
Orchestration of Data processing
Technologies
-
Azure Data Lake Storage Gen2
-
Azure Synapse Analytics e.g. with Synapse dedicated SQL-Pools
-
Sparke Notebooks (SQL, Python)
-
Azure Functions
-
Stored Processes within Synapse Analytics
-
Azure Synapse Pipelines
-
Data Modeling: ERWIN
-
Data Catalog and Quality: EDC
Nice to have:
-
Oracle SQL / PL/SQL
-
SAS Base (incl. Macro programming) and DI-Studio
-
Linux Bash
-
PowerBI
Your benefits:
- We offer a hybrid work model which recognizes the value of striking a balance between in-person collaboration and remote working incl. up to 25 days per year working from abroad
- We believe in rewarding performance and our compensation and benefits package includes a company bonus scheme, pension, employee shares program and multiple employee discounts (details vary by location)
- From career development and digital learning programs to international career mobility, we offer lifelong learning for our employees worldwide and an environment where innovation, delivery and empowerment are fostered
- Flexible working, health and wellbeing offers (including healthcare and parental leave benefits) support to balance family and career and help our people return from career breaks with experience that nothing else can teach
42592 | Ingeniería informática y tecnológica | Profesional / Senior | Non-Executive | Allianz Technology | Jornada completa | Indefinido
About Allianz Technology
Allianz Technology is the global IT service provider for Allianz and delivers IT solutions that drive the digitalization of the Group. With more than 13,000 employees located in 22 countries around the globe, Allianz Technology works together with other Allianz entities in pioneering the digitalization of the financial services industry.
We oversee the full digitalization spectrum – from one of the industry’s largest IT infrastructure projects that includes data centers, networking and security, to application platforms that span from workplace services to digital interaction. In short, we deliver full-scale, end-to-end IT solutions for Allianz in the digital age.
D&I statement
Allianz Technology is proud to be an equal opportunity employer encouraging diversity in the working environment. We are interested in your strengths and experience. We welcome all applications from all people regardless of gender identity and/or expression, sexual orientation, race or ethnicity, age, nationality, religion, disability, or philosophy of life.
Join us. Let´s care for tomorrow.
You. IT
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture Azure ETL Finance Linux Oracle Pipelines Power BI Python SAS Security SQL
Perks/benefits: Career development Equity Flex hours Health care Parental leave Salary bonus
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Manager jobs
- Open Data Science Manager jobs
- Open Principal Data Engineer jobs
- Open Data Engineer II jobs
- Open Sr Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Data Analytics Engineer jobs
- Open Junior Data Scientist jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Business Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Big Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Junior Data Engineer jobs
- Open Data Product Manager jobs
- Open Data Quality Analyst jobs
- Open Research Scientist jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open CI/CD-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Hadoop-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs