BI Consultant | Data Engineer | MCSA | MCSE | Power BI Super User | tackytech.blog
Aktualisiert am 13.03.2024
Profil
Freiberufler / Selbstständiger
Verfügbar ab: 01.03.2024
Verfügbar zu: 50%
davon vor Ort: 0%
Azure
Power BI
Data Engineering
Datawarehouse
MS Azure SQL Database
SQL
Python
PowerShell
DevOps
Agile Softwareentwicklung
ETL
Datenarchitektur
Datenbankadministration
Data Modeling
MS SQL Server Analysis Services
MS SQL Datenbanken
MS SQL Server Reporting Services
German
Muttersprache
English
fluent
Swedish
fluent
Latin
intermediate Latin certificatec

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich
nicht möglich

Projekte

Projekte

2 years 5 months
2023-07 - now

Freelancing on different data initiatives

Data/BI Engineer Spark SQL Python DAX ...
Data/BI Engineer
? Modelling and developing semantic models and Power BI reports on Databricks Lakehouse
? Consulting in Power BI best practices for governance and CICD as well as Lakehouse data modelling
? Developing (near)-real time data platform utilizing streaming and graph calculations in Synapse and Spark
? Modelling and developing data models for consumption in Power BI and Celonis
Spark SQL Python DAX Power Query M Power BI Azure DevOps Azure Databricks YAML Powershell T-SQL R Azure Data Factory Azure Functions Azure SQL Database Power BI
6 months
2023-04 - 2023-09

Expanding cloud solution from AWS to Azure

Data Engineer Postgres SQL T-SQL Python AWS Aurora ...
Data Engineer
? Expanding Agilitek?s cloud solution from AWS to Azure
? Enhancing ETL flows in AWS and reducing AWS RDS cost
? Implementing meta-steered ETL in Snowflake
AWS Azure
Postgres SQL T-SQL Python AWS Aurora AWS Eventbridge AWS Step functions AWS DynamoDB
3 months
2023-02 - 2023-04

Building scalable and meta-driven ETL pipelines

Data Engineer T-SQL Azure Data Factory VMWare ...
Data Engineer
  • Building scalable and meta-driven ETL pipelines in Azure Data Factory and Databricks
  • Maintaining and updating Virtual Machines in Azure and Virtual Desktop Infrastructure in VMWare
Azure
T-SQL Azure Data Factory VMWare Azure Virtual Machines Azure VNet Confluence JIRA
CGI INC (IT Consultancy Firm)
Vancouver (CAN)
4 years
2019-03 - 2023-02

Designing and lead developing EDW solutions

Business Intelligence Consultant T-SQL R Python ...
Business Intelligence Consultant
  • Designing and lead developing EDW solutions in Azure using Azure SQL, Synapse, Data Factory, Analysis Services (Azure & on-prem), Azure Functions, Azure VNet, Azure Purview, Power BI Premium
  • Gathering and validating business requirements and translating them into data models (Inmon & Kimball)
  • Creating reports and dashboards in Power BI (Pro & Premium) and SSRS
  • Building Big Data platforms (Lakehouse) using Delta, Azure Databricks, Python, Spark, Hadoop
  • Working agile in Azure DevOps, setting up CI/CD pipelines and automated test runs
  • Establishing data governance, incl master data management, data catalogs, organizational access design
  • Leading and mentoring junior consultants both during client deliveries and internally
  • Taking several Azure and Microsoft certifications: MCSA, MCSE, DA-100, AZ-500, AI-100, AZ-104
T-SQL R Python DAX PowerShell Power Query M YAML MS Azure (Data Factory Analysis Services Power BI Premium SQL Database Synapse Key Vault Data / Delta Lake ARM Templates DevOps Databricks Purview Functions Logic Apps VNet EventGrid) MS SSMS MS SSAS MS SSRS MS SSIS MS Visual Studio Postman Spark Hadoop MS Excel
RANDOM FOREST AB
Stockholm
1 year 1 month
2018-02 - 2019-02

Analyzing and visualizing qualitative and quantitative data

Research Analyst SQL Microsoft Office Microsoft Power BI ...
Research Analyst
  • Analyzing and visualizing qualitative and quantitative data in Excel, Power BI and PowerPoint
  • Presenting results to internal and external customers
  • Creating and developing dashboards for tracking services or KPI overviews with Power BI
SQL Microsoft Office Microsoft Power BI Google Suite
POTENTIALPARK AB
Stockholm
2 years 5 months
2015-10 - 2018-02

Underwriting of credit applications including risk analysis and assessment

Customer Advisor
Customer Advisor
  • Underwriting of credit applications including risk analysis and assessment
  • Maintaining customer contact by taking inbound / outbound calls, sending letters, e-mails and faxes
  • Selling loan-related products (skip-a-pay, loan insurance, duration extension etc.)
NORDAX BANK AB
Stockholm

Aus- und Weiterbildung

Aus- und Weiterbildung

1 year 10 months
2016-08 - 2018-05

M.Sc. Operations Management and Control

Stockholm Business School / Stockholm University, Stockholm
Stockholm Business School / Stockholm University, Stockholm

  • GPA: 3.82 / 4.00
  • Thesis: on request

5 months
2017-08 - 2017-12

Exchange Semester abroad

Master of Business Administration, San Diego State University, San Diego
Master of Business Administration
San Diego State University, San Diego
  • GPA: 3.66 / 4.00
3 years 8 months
2011-10 - 2015-05

B. Sc. Industrial Engineering and Management

Karlsruhe Institute of Technology, Karlsruhe
Karlsruhe Institute of Technology, Karlsruhe
  • Thesis: on request

Position

Position

? Modelling and developing semantic models and Power BI reports on Databricks Lakehouse
? Consulting in Power BI best practices for governance and CICD as well as Lakehouse data modelling
? Developing (near)-real time data platform utilizing streaming and graph calculations in Synapse and Spark
? Modelling and developing data models for consumption in Power BI and Celonis

Kompetenzen

Kompetenzen

Top-Skills

Azure Power BI Data Engineering Datawarehouse MS Azure SQL Database SQL Python PowerShell DevOps Agile Softwareentwicklung ETL Datenarchitektur Datenbankadministration Data Modeling MS SQL Server Analysis Services MS SQL Datenbanken MS SQL Server Reporting Services

Produkte / Standards / Erfahrungen / Methoden

Data Factory
Analysis Services
Power BI
Azure SQL Database
Azure Synapse
Delta Lake
Lakehouse
Azure DevOps
Jira
Purview
Azure Function
Logic App
Fabric
SSMS
SSAS
SSIS
Postman
Spark
Databricks
Hadoop

IT programs: 

  • MS Azure (Data Factory, Analysis Services, Power BI Premium, SQL Database, Synapse, Key Vault, Data / Delta Lake, ARM Templates, DevOps, Databricks, Purview, Functions, Logic Apps, VNet)
  • Fabric
  • MS SSMS
  • MS SSAS
  • MS SSRS
  • MS SSIS
  • MS Visual Studio
  • Postman
  • Spark
  • Hadoop

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich
nicht möglich

Projekte

Projekte

2 years 5 months
2023-07 - now

Freelancing on different data initiatives

Data/BI Engineer Spark SQL Python DAX ...
Data/BI Engineer
? Modelling and developing semantic models and Power BI reports on Databricks Lakehouse
? Consulting in Power BI best practices for governance and CICD as well as Lakehouse data modelling
? Developing (near)-real time data platform utilizing streaming and graph calculations in Synapse and Spark
? Modelling and developing data models for consumption in Power BI and Celonis
Spark SQL Python DAX Power Query M Power BI Azure DevOps Azure Databricks YAML Powershell T-SQL R Azure Data Factory Azure Functions Azure SQL Database Power BI
6 months
2023-04 - 2023-09

Expanding cloud solution from AWS to Azure

Data Engineer Postgres SQL T-SQL Python AWS Aurora ...
Data Engineer
? Expanding Agilitek?s cloud solution from AWS to Azure
? Enhancing ETL flows in AWS and reducing AWS RDS cost
? Implementing meta-steered ETL in Snowflake
AWS Azure
Postgres SQL T-SQL Python AWS Aurora AWS Eventbridge AWS Step functions AWS DynamoDB
3 months
2023-02 - 2023-04

Building scalable and meta-driven ETL pipelines

Data Engineer T-SQL Azure Data Factory VMWare ...
Data Engineer
  • Building scalable and meta-driven ETL pipelines in Azure Data Factory and Databricks
  • Maintaining and updating Virtual Machines in Azure and Virtual Desktop Infrastructure in VMWare
Azure
T-SQL Azure Data Factory VMWare Azure Virtual Machines Azure VNet Confluence JIRA
CGI INC (IT Consultancy Firm)
Vancouver (CAN)
4 years
2019-03 - 2023-02

Designing and lead developing EDW solutions

Business Intelligence Consultant T-SQL R Python ...
Business Intelligence Consultant
  • Designing and lead developing EDW solutions in Azure using Azure SQL, Synapse, Data Factory, Analysis Services (Azure & on-prem), Azure Functions, Azure VNet, Azure Purview, Power BI Premium
  • Gathering and validating business requirements and translating them into data models (Inmon & Kimball)
  • Creating reports and dashboards in Power BI (Pro & Premium) and SSRS
  • Building Big Data platforms (Lakehouse) using Delta, Azure Databricks, Python, Spark, Hadoop
  • Working agile in Azure DevOps, setting up CI/CD pipelines and automated test runs
  • Establishing data governance, incl master data management, data catalogs, organizational access design
  • Leading and mentoring junior consultants both during client deliveries and internally
  • Taking several Azure and Microsoft certifications: MCSA, MCSE, DA-100, AZ-500, AI-100, AZ-104
T-SQL R Python DAX PowerShell Power Query M YAML MS Azure (Data Factory Analysis Services Power BI Premium SQL Database Synapse Key Vault Data / Delta Lake ARM Templates DevOps Databricks Purview Functions Logic Apps VNet EventGrid) MS SSMS MS SSAS MS SSRS MS SSIS MS Visual Studio Postman Spark Hadoop MS Excel
RANDOM FOREST AB
Stockholm
1 year 1 month
2018-02 - 2019-02

Analyzing and visualizing qualitative and quantitative data

Research Analyst SQL Microsoft Office Microsoft Power BI ...
Research Analyst
  • Analyzing and visualizing qualitative and quantitative data in Excel, Power BI and PowerPoint
  • Presenting results to internal and external customers
  • Creating and developing dashboards for tracking services or KPI overviews with Power BI
SQL Microsoft Office Microsoft Power BI Google Suite
POTENTIALPARK AB
Stockholm
2 years 5 months
2015-10 - 2018-02

Underwriting of credit applications including risk analysis and assessment

Customer Advisor
Customer Advisor
  • Underwriting of credit applications including risk analysis and assessment
  • Maintaining customer contact by taking inbound / outbound calls, sending letters, e-mails and faxes
  • Selling loan-related products (skip-a-pay, loan insurance, duration extension etc.)
NORDAX BANK AB
Stockholm

Aus- und Weiterbildung

Aus- und Weiterbildung

1 year 10 months
2016-08 - 2018-05

M.Sc. Operations Management and Control

Stockholm Business School / Stockholm University, Stockholm
Stockholm Business School / Stockholm University, Stockholm

  • GPA: 3.82 / 4.00
  • Thesis: on request

5 months
2017-08 - 2017-12

Exchange Semester abroad

Master of Business Administration, San Diego State University, San Diego
Master of Business Administration
San Diego State University, San Diego
  • GPA: 3.66 / 4.00
3 years 8 months
2011-10 - 2015-05

B. Sc. Industrial Engineering and Management

Karlsruhe Institute of Technology, Karlsruhe
Karlsruhe Institute of Technology, Karlsruhe
  • Thesis: on request

Position

Position

? Modelling and developing semantic models and Power BI reports on Databricks Lakehouse
? Consulting in Power BI best practices for governance and CICD as well as Lakehouse data modelling
? Developing (near)-real time data platform utilizing streaming and graph calculations in Synapse and Spark
? Modelling and developing data models for consumption in Power BI and Celonis

Kompetenzen

Kompetenzen

Top-Skills

Azure Power BI Data Engineering Datawarehouse MS Azure SQL Database SQL Python PowerShell DevOps Agile Softwareentwicklung ETL Datenarchitektur Datenbankadministration Data Modeling MS SQL Server Analysis Services MS SQL Datenbanken MS SQL Server Reporting Services

Produkte / Standards / Erfahrungen / Methoden

Data Factory
Analysis Services
Power BI
Azure SQL Database
Azure Synapse
Delta Lake
Lakehouse
Azure DevOps
Jira
Purview
Azure Function
Logic App
Fabric
SSMS
SSAS
SSIS
Postman
Spark
Databricks
Hadoop

IT programs: 

  • MS Azure (Data Factory, Analysis Services, Power BI Premium, SQL Database, Synapse, Key Vault, Data / Delta Lake, ARM Templates, DevOps, Databricks, Purview, Functions, Logic Apps, VNet)
  • Fabric
  • MS SSMS
  • MS SSAS
  • MS SSRS
  • MS SSIS
  • MS Visual Studio
  • Postman
  • Spark
  • Hadoop

Vertrauen Sie auf Randstad

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

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

Das Freelancer-Portal

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