Data Engineering Expert | Snowflake | Wherescape | ELT | BI | SQL Server
Aktualisiert am 19.04.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 15.05.2024
Verfügbar zu: 100%
davon vor Ort: 10%
Snowflake
Data Vault
ELT
Kimball
Wherescape
PowerShell
PowerBI
Business analysis
Tableau
SSRS
SSIS
SSAS
Data Engineer
ETL
T-SQL
English
Verhandlungssicher

Einsatzorte

Einsatzorte

Deutschland, Österreich
möglich

Projekte

Projekte

1 year 5 months
2022-12 - 2024-04

IFRS17 reporting solution

Data Engineer SQL Snowflake PowerShell ...
Data Engineer

Designing and building a reporting tool to integrate Actuarial data into Snowflake for IFRS17 compliance.

Designed ELT processes using Wherescape RED, dimensional modelling in Wherescape RED, managed data exports within WS Red and Snowflake; developed Orchestration flows

Applied Data Vault 2.0 modeling and analysis techniques to ensure data integrity and scalability

Created PowerBI dashboards dashboards to visualize and analyze data for enhanced decision making.

Snowflake Wherescape PowerBI MS SQL Server PowerShell Git Atlassian Confluence PostgreSQL
SQL Snowflake PowerShell Data Vault Dimensional modelling
Allianz Benelux
Allianz Benelux
1 year 9 months
2022-03 - 2023-11

System to integrate Actuarial data into Snowflake for IFRS17 compliance

Data Engineer Snowflake Wherescape ELT ...
Data Engineer

Led the development effort as the lead developer, overseeing all phases of designing and building a new system to integrate Actuarial data into Snowflake for IFRS17 compliance. 

Conducted ELT processes using Wherescape RED, implemented dimensional modeling in WS RED, and managed data exports within WS Red; developed Orchestration flow using WS Jobscheduler for efficient workflow management.

Implemented Snowflake tables, views, procedures, and functions, along with monitoring and data checks, including query history, load history, and data quality checks utilizing dynamic SQL with Snowflake information schema. 

Utilized AWS CLI for various cloud-based operations.

Provided business analysis support for IFRS17 reporting, contributing to comprehensive and accurate financial reporting processes. 

Snowflake Wherescape ELT AWS CLI Powershell Tableau Jenkins
Legal & General
UK remote
1 year
2021-03 - 2022-02

Building Information Marts using company Data Vault

Data Engineer Snowflake SQL PowerShell ...
Data Engineer

Data Vault 2.0 modeling in 3D, managed loading and unloading data, views, procedures, block statements, and dimensional modeling (BVLT & INMT) using Wherescape RED.

Conducted ETL from Snowflake to PostgreSQL using Wherescape RED

Set up PostgreSQL environments, performed data load from Snowflake to PostgreSQL databases (development, testing, integration, user acceptance testing, production), managed Wherescape procedures and jobs for PostgreSQL environments

Conducted production monitoring, including daily monitoring of UC4 jobs, Wherescape Data Vault jobs monitoring, error investigation, follow-ups, and configuring of new Wherescape flows

Snowflake Wherescape RED Wherescape 3D PostgreSQL MS SQL Server PowerShell Atlassian Confluence Atlassian JIRA Agile Git
Snowflake SQL PowerShell ELT ETL Data Modeling Data Vault Kimball
Allianz Benelux
Deloitte Technology
8 months
2020-07 - 2021-02

Data Vault migration to Snowflake using Wherescape

Data Engineer SQL Snowflake Bash ...
Data Engineer

Conducted Raw Data Vault migration from Exadata to Snowflake using Wherescape RED & 3D

Created conversion rules and 3D flows for the Data Vault modeling process

Exported Exadata Data Vault data and loaded it into Snowflake using sqlcl, bash, Wherescape RED, and 3D

Configured new objects, managed errors, conducted debugging, and provided support for Wherescape 3D

Managed template changes for adding new functionalities, provided support, and handled Wherescape RED procedures and check

Implemented Data Vault 2.0 modeling in 3D, managed loading and unloading data, views, procedures, block

statements, and dimensional modeling (BVLT & INMT) using Wherescape RED

Snowflake Wherecape RED Wherescape 3D PostgreSQL MS SQL Server MS Azure SQL Database Azure Oracle Exadata
SQL Snowflake Bash SQLcl ELT Data Vault
Allianz Benelux
Deloitte Technology

Einsatzorte

Einsatzorte

Deutschland, Österreich
möglich

Projekte

Projekte

1 year 5 months
2022-12 - 2024-04

IFRS17 reporting solution

Data Engineer SQL Snowflake PowerShell ...
Data Engineer

Designing and building a reporting tool to integrate Actuarial data into Snowflake for IFRS17 compliance.

Designed ELT processes using Wherescape RED, dimensional modelling in Wherescape RED, managed data exports within WS Red and Snowflake; developed Orchestration flows

Applied Data Vault 2.0 modeling and analysis techniques to ensure data integrity and scalability

Created PowerBI dashboards dashboards to visualize and analyze data for enhanced decision making.

Snowflake Wherescape PowerBI MS SQL Server PowerShell Git Atlassian Confluence PostgreSQL
SQL Snowflake PowerShell Data Vault Dimensional modelling
Allianz Benelux
Allianz Benelux
1 year 9 months
2022-03 - 2023-11

System to integrate Actuarial data into Snowflake for IFRS17 compliance

Data Engineer Snowflake Wherescape ELT ...
Data Engineer

Led the development effort as the lead developer, overseeing all phases of designing and building a new system to integrate Actuarial data into Snowflake for IFRS17 compliance. 

Conducted ELT processes using Wherescape RED, implemented dimensional modeling in WS RED, and managed data exports within WS Red; developed Orchestration flow using WS Jobscheduler for efficient workflow management.

Implemented Snowflake tables, views, procedures, and functions, along with monitoring and data checks, including query history, load history, and data quality checks utilizing dynamic SQL with Snowflake information schema. 

Utilized AWS CLI for various cloud-based operations.

Provided business analysis support for IFRS17 reporting, contributing to comprehensive and accurate financial reporting processes. 

Snowflake Wherescape ELT AWS CLI Powershell Tableau Jenkins
Legal & General
UK remote
1 year
2021-03 - 2022-02

Building Information Marts using company Data Vault

Data Engineer Snowflake SQL PowerShell ...
Data Engineer

Data Vault 2.0 modeling in 3D, managed loading and unloading data, views, procedures, block statements, and dimensional modeling (BVLT & INMT) using Wherescape RED.

Conducted ETL from Snowflake to PostgreSQL using Wherescape RED

Set up PostgreSQL environments, performed data load from Snowflake to PostgreSQL databases (development, testing, integration, user acceptance testing, production), managed Wherescape procedures and jobs for PostgreSQL environments

Conducted production monitoring, including daily monitoring of UC4 jobs, Wherescape Data Vault jobs monitoring, error investigation, follow-ups, and configuring of new Wherescape flows

Snowflake Wherescape RED Wherescape 3D PostgreSQL MS SQL Server PowerShell Atlassian Confluence Atlassian JIRA Agile Git
Snowflake SQL PowerShell ELT ETL Data Modeling Data Vault Kimball
Allianz Benelux
Deloitte Technology
8 months
2020-07 - 2021-02

Data Vault migration to Snowflake using Wherescape

Data Engineer SQL Snowflake Bash ...
Data Engineer

Conducted Raw Data Vault migration from Exadata to Snowflake using Wherescape RED & 3D

Created conversion rules and 3D flows for the Data Vault modeling process

Exported Exadata Data Vault data and loaded it into Snowflake using sqlcl, bash, Wherescape RED, and 3D

Configured new objects, managed errors, conducted debugging, and provided support for Wherescape 3D

Managed template changes for adding new functionalities, provided support, and handled Wherescape RED procedures and check

Implemented Data Vault 2.0 modeling in 3D, managed loading and unloading data, views, procedures, block

statements, and dimensional modeling (BVLT & INMT) using Wherescape RED

Snowflake Wherecape RED Wherescape 3D PostgreSQL MS SQL Server MS Azure SQL Database Azure Oracle Exadata
SQL Snowflake Bash SQLcl ELT Data Vault
Allianz Benelux
Deloitte Technology

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das GULP Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.