Freelance BI Consultant
Bankdata needed to get data from a Trade Management System (TMS) into the data warehouse model in such a way that trade orders could be used directly in reporting without having to guess what the numbers meant or if they were complete. I worked on-site as a freelance BI consultant, focusing on building the SQL Server scripts that delivered data to the tables others reported on, while also incorporating data quality and reconciliation, so discrepancies became visible early instead of turning into discussions when someone was already looking at a report.
Other parameters: Scope: Full time; Employment type: Freelancer via broker (7N); Core delivery: Trade orders from Trade Management System (TMS) integrated into the data warehouse model, with scripts delivering data to tables that others built reports on.
The core of the task was to get Trade Management System (TMS) data included as part of the data warehouse model, so trade orders could be part of reporting in a consistent way, ensuring reporting didn't become a question of which source one happened to trust that day.
The work consisted of building and maintaining the data foundation that allowed TMS data to be included in the data warehouse model, where I primarily delivered scripts for the tables upon which reporting and analysis were built by others, ensuring the boundary between the data foundation and reporting was clear, and there was a predictable pipeline from source to reporting.
To ensure reporting was reliable, I worked with data quality and reconciliation so that discrepancies between expected and actual data foundations could be discovered before they turned into errors in reports or manual explanations that varied depending on who was asked.
Cooperation was primarily within the DWH team, with interfaces to developers from the TMS team, aiming to clarify how data should be understood and used, and delivering a foundation that could be consumed in reporting without requiring continuous specialized knowledge from the people who had been closest to the source.
Bankdata is a Danish IT company (data center) that develops and operates digital products, platforms, and infrastructure for several Danish banks, which jointly own the company. Bankdata has approximately 1,000 employees and has offices in Fredericia, Silkeborg, and Aarhus, among others.
For more information, visit bankdata.dk.