Work
Projects
T-SQL course
Resources: GitHub
Period: Feb 2023
Role: Co-creator
About: Together with Thomas Lange, I developed and taught an in-person course on T-SQL in Danish. The course moved from basic to advanced level, covering topics like joins, CTEs, window functions and programmable elements.
Employments
Data Engineer/Architect at the Danish Refugee Council (current)
Employer: Danish Refugee Council
Period: Feb 2023 – Present
Position: Data Engineer & Architect
Role: As a Data Engineer and Architect for an international NGO, I design, build and maintain a cloud-first data platform (using Azure DevOps, Databricks and Azure Data Lake) that integrates various sources to provide a single source of truth for analytics and operational needs.
Skills:
- Collaborating with business stakeholders to understand and deliver on business needs
- Working according to the scrum methodology
- Setting up developer-friendly environments using sandboxes, version control and documentation
- Building a data platform on open source technology, like Delta Lake and Apache Spark
- Establishing modelling principles grounded in medallion architecture
- Using Spark SQL and PySpark to build data pipelines
- Keeping up with new ways of working with AI 😅
BI Consultant at the Ministry of Food, Agriculture and Fisheries
Employer: Ministry of Food, Agriculture and Fisheries
Period: May 2022 – Jan 2023
Position: BI Consultant
Role: As a BI Consultant on the ministry’s on-premises data platform, I analyzed and implemented business logic while establishing the necessary infrastructure for the solution.
Skills:
- Architecting data layers and modelling principles
- Describing principles for documentation
- Setting up version control and a CI/CD process using Redgate's SQL Essential Toolbelt
- Building data artifacts using Microsoft's T-SQL and SSIS
Data Officer at the Ministry of Higher Education and Science
Employer: Ministry of Higher Education and Science
Period: Apr 2020 – Apr 2022
Position: Data Officer
Role: As a data officer, I developed BI solutions for research and innovation projects, with a focus on advancing data maturity, data preparation and relational modeling. Primarily used the Microsoft stack, with Python for data transformation and machine learning.
Skills:
- Project management
- Maintenance jobs, performance tuning and backups on Microsoft SQL Server
- Designing (relational) database models on Microsoft SQL Server
- Implementing complex business logic using T-SQL
- Master data management using Microsoft Master Data Services
- Developing simple apps using Microsoft Power Apps
- Developing ETL flows using the Python library Pandas
- Utilizing machine learning to automate processes using the Python module scikit-learn
Data Officer at the Ministry of Children and Education
Employer: Ministry of Children and Education
Period: Aug 2018 – Mar 2020
Position: Data Officer
Role: As a data officer, I did mostly backend development. I worked on a Microsoft SQL Server-based data warehouse (on-premises) using the Microsoft stack, including Visual Studio and Team Foundation Server.
Skills:
- Stakeholder management
- Agile working
- Designing and documenting solutions using Sparx Enterprise Architect
- Data ingestion
- Implementing business logic using T-SQL
- Developing ETL flows using Microsoft Integration Services (SSIS)
- Designing tabular models using Microsoft Analysis Services (SSAS)
Consultant at Lange Gruppen
Employer: Lange Gruppen
Period: Aug 2016 – Jul 2018
Position: Consultant
Role: As a consultant, I performed statistical analyses and developed BI solutions, mostly for public sector customers. The analyses ranged from simple exploratory calculations to advanced projection models and optimization algorithms.
Skills:
- Uncovering customer needs and challenges and expectation management
- Analytical and technical problem solving
- Data analysis and visualization in Microsoft Power BI using the DAX language
- Statistical analyses using Statistical Analysis Software (SAS)
- Report writing
Certifications
Certified Associate Python Programmer, PCAP (ongoing)
Microsoft Certified Solutions Associate, MCSA: BI Reporting
Certified: Jun 2018
Bachelor of Science in Economics at University of Copenhagen
Certified: Jul 2015