Renvaldas Mackevicius, Developer in Gävle, Sweden
Renvaldas is available for hire
Hire Renvaldas

Renvaldas Mackevicius

Verified Expert  in Engineering

Data Engineer and Developer

Gävle, Sweden
Toptal Member Since
October 7, 2021

Renvaldas is a senior data engineer with 20+ years of experience in data integration projects that include developing data models, maintaining data warehouses and analytics environments, and building data integration and analysis workflows in SSIS and Azure cloud. He excels in designing and building SSAS tabular models, working in Azure cloud infrastructure and administration, and designing and building Power BI reports.


Data Warehousing, C#, DAX, Dedicated SQL Pool (formerly SQL DW)...
Visual Studio, TypeScript, JavaScript, SQL...
IIS SQL Server, SQL Server Integration Services (SSIS), C#, ArcGIS Server...




Preferred Environment

Data Warehousing, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW), C#, Azure Data Factory, Python, Windows PowerShell, SQL

The most amazing... I've developed include integrated front and back-end applications for a black call list subsystem and an address data control and load subsystem.

Work Experience

Senior Data Engineer

2018 - PRESENT
  • Developed various data integrations using SSIS, ADF, and APIs on-premises and in the cloud.
  • Created a monitoring system for dealing with data loading workflows, performance, and data quality.
  • Designed and created SSAS tabular models and Power BI reports for solving various business problems.
  • Supported other developers and applications maintenance teams in various design, maintenance, troubleshooting, and administration activities.
  • Worked in administering DW on-premises and in Azure.
Technologies: Data Warehousing, C#, DAX, Dedicated SQL Pool (formerly SQL DW), Azure SQL Data Warehouse, Microsoft Parallel Data Warehouse (PDW), Azure SQL, Databricks, Azure Data Factory, User Requirements, Testing, Training, Microsoft Power BI, SQL Server Analysis Services (SSAS), SSAS Tabular, Neo4j, ETL, Data Engineering

Data Scientist | GIS Developer

2014 - 2018
  • Acted as a scrum master in the project for optimizing locations of Scania Service centers through a map-centric web application used by many local Scania services centers all over the world. I also developed the client-side, the API, and DB.
  • Performed many data integration assignments, including data and business analysis.
  • Delivered business and data analysis, implemented data collection and cleansing procedures, and built reporting based on collected data for a project aiming to reduce lead times.
Technologies: Visual Studio, TypeScript, JavaScript, SQL, SQL Server Integration Services (SSIS), ArcGIS Server, ArcGIS, ArcSDE, Microsoft Power BI, SQL Server DBA, Python, Windows PowerShell

GIS | Database | Web Developer

2013 - 2017
  • Worked as a full-stack developer on a client project to build a wood material tracing sourcing system.
  • Created automated testing workflows to reduce potential errors, which reduced business testing times.
  • Provided training for the client on technology and system usage.
Technologies: IIS SQL Server, SQL Server Integration Services (SSIS), C#, ArcGIS Server, ArcGIS, Python, ArcSDE, JavaScript, TypeScript


2011 - 2017
Esri Sverige
  • Owned analysis, system design, database design, programming, and user training.
  • Designed and developed various GIS and tabular data solutions based on ESRI, Microsoft, and Oracle technologies.
  • Provided training to various clients mainly on build solutions and ESRI technologies.
Technologies: Data, GIS, Esri, SQL Server Integration Services (SSIS), Oracle, IIS SQL Server, ArcGIS Server, C#, Windows PowerShell, PostgreSQL, PostGIS, SQL, SQL CLR, ArcGIS, ArcSDE, JavaScript, TypeScript, ASP.NET, SQL Stored Procedures, Database Design, FME

Full-stack Developer

2008 - 2011
  • Designed the architecture and developed integrated front and back-end applications for a black call list subsystem, designing a persistent layer (database schema).
  • Designed the architecture and developed integrated front and back-end applications for an address data control and load subsystem, designing a persistent layer (database schema).
  • Architected and built an application for automatic data—GIS and attribute—control and correction to a monitoring system. I also implemented automation tools for big raster maps automatic tilling, merging, and conversion.
Technologies: Databases, Esri, User Requirements, Database Design, Python, ASP.NET


1999 - 2008
  • Architected a drivers' information system for the Lithuania National Tourism System (LNTS). I designed user interfaces, workflows and overall database structure, created and implemented server-side code with Oracle SP, and performed data conversion.
  • Worked on model requirements and the process flow using UML (Visio). I designed and implemented data exchange web services for LNTS, porting old functionality back-end applications from Visual Basic 6.0 to .NET 3.5 (C#).
  • Tested and debugged LNTS portal and back-end applications' functionality, fixing reported bugs and improving existing functionality. I also managed overall testing processes with Bugzilla.
  • Modified and adopted server-side logic for data exchange and for ad-hoc data reporting module with Oracle11g SP.
  • Developed and implemented an intranet-based application for a train tracking system for the State Border Guard Service at the Ministry of the Interior of the Republic of Lithuania.
Technologies: SQL, Database Design, C#, Oracle, Esri, ArcSDE, ArcGIS Server, ArcGIS, SQL Stored Procedures, JavaScript

ADF Pipelines Monitoring System for a DW Maintenance Team

Demanding users need to know about data loading delays, errors, and other problems. Therefore, I planned, designed, and implemented an integrated monitoring solution for a DW maintenance team.

This solution helped to see a clear picture of the situation in the short run and saved a lot of time in the longer run, avoiding debugging and helping to solve any quality problems.

XLSX File Load

For many years, my client struggled in loading external XLSX files from various locations due to data quality problems and even some "file opened and lock" problems. That resulted in failed pipelines, unrefreshed reports, and unhappy business users.

Developers tried to build their own solutions but kept getting the same problems while loading those files. So, I proposed and developed a universal XLSX file loader via configurations with error handling that allows developers to use the same package with everything they need for configuring metadata. After that, we even forgot that problem existed.

Migration of Microsoft PDW from On-premises to Azure DW

For this project, I planned the migration updating code, which included redesigning pipelines, packages, and the data structure. During the migration, I developed pipelines using Azure Data Factory and new data formats—like Parquet—available there. I continued working on data quality control and performance during and after the migration.

IKEA Wood Sourcing Risks Analysis

Wood is IKEA’s most important raw material, and they are one of the biggest buyers of wood in the world. To ensure that all the suppliers meet the requirements of the many rules that IKEA has on forestry, the suppliers need to register every future delivery of wood in WTS. After that, IKEA can analyze risks—such as illegal logging, forest legislation, protected species, and so on—for the area from where the wood is originated before they buy it. Geography is, of course, critical in those analyses.

For this project, I designed the system architecture and the database architecture. I also dealt with installation, data migration, DB structure development, SP, views, models in Python, map features, geoprocessing services, and data export and import services.

Black Call List Subsystem

I designed the architecture and developed integrated front and back-end applications for a black call list subsystem and an address data control and load subsystem, building a persistent layer (database schema).

Data Pipelines for OData API Services

I implemented an ASP.NET API for managing OData in the SQL Server database. I also created the database design and table, stored procedures for managing attribute data from JSON and binary files, and data load test procedures in PowerShell. For automation, I used Apache Airflow.

Azure ADF Pipelines to Load Data from Salesforce to Azure SQL

I built Azure ADF pipelines to load data from Salesforce to Azure SQL. I also created stored procedures to upsert incoming data, test cases for data and performance, and documentation for the application's maintenance team.
1994 - 1999

Master's Degree in Electrical Engineering

Kaunas University of Technology - Kaunas, Lithuania


Microsoft Certified Professional — SQL 2016 Business Intelligence Development



Getting and Cleaning Data



Cloudera Certified Professional: Data Scientist



Cloudera Certified Developer for Apache Hadoop CDH4



Machine Learning



ESRI Enterprise System Design Associate 10.1



CompTIA Certificate “CompTIA Linux+ (Powered by LPI)



LPI Certificate “OSS-DB Silver (PostgreSQL)



Enterprise System Design Associate 10



ISTQB-ISEB Certified Tester Foundation Level (CTFL)



CompTIA Project+ Certified



Oracle Database 11g Administrator Certified Professional



Microsoft Certified Technology Specialist: SQL Server 2008, Implementation and Maintenance



Microsoft Certified IT Professional: Database Developer 2008



REST APIs, ArcGIS, PySpark, Salesforce API


Microsoft Power BI, Visual Studio, GIS, Esri, FME, Salesforce CPQ, Apache Airflow, Docker Hub, Synapse, Spark SQL


Windows PowerShell, ADF, ASP.NET, Hadoop, Spark


SQL, C#, Python, Stored Procedure, XML, TypeScript, JavaScript, Cypher


Database Design, Testing, Agile Project Management, Automation, ETL, Business Intelligence (BI), Data Science


Azure SQL Data Warehouse, ArcGIS Server, Azure, Docker, Dedicated SQL Pool (formerly SQL DW), Oracle, Salesforce, Databricks, Linux


Microsoft Parallel Data Warehouse (PDW), SSAS Tabular, SQL Server Integration Services (SSIS), Azure SQL, Oracle PL/SQL, Microsoft SQL Server, SQL Stored Procedures, SQL Server DBA, IIS SQL Server, SQL Functions, JSON, PostgreSQL, PostGIS, SQL CLR, Data Pipelines, Master Data Management (MDM), Databases, SQL Server Analysis Services (SSAS), Neo4j, Database Modeling


Data Warehousing, DAX, Azure Data Factory, Programming, Design, IT Project Management, SQL Server Administration, ArcSDE, Data, User Requirements, Data Engineering, OData, Documentation, Data Warehouse Design, Data Warehouse Implementation, Data Analysis, Data Visualization, Data Cleaning, PL/SQL Tuning, Test Planning, Data Quality, Multidimensional Expressions (MDX), Master Data, Machine Learning, Training, Performance Optimization

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.


Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring