Nicolas Kalns - Senior Data Analyst

Q: Where is Nicolas based?

Nicolas is based in Whitefield, United Kingdom .

Q: What languages does Nicolas speak?

Nicolas speaks the following languages: English (Native), Latvian (Native) .

Q: How many years of experience does Nicolas have?

Nicolas has at least 13 years of experience. During this time, Nicolas has worked in at least 7 different roles and for 19 different companies . The average length of individual experience is 1 year and 8 months . Note that Nicolas may not have shared all experience and actually has more experience.

Q: What is Nicolas's latest experience?

Nicolas's most recent position is Senior Data Analyst at Snap Analytics .

Q: What companies has Nicolas worked for in recent years?

In recent years, Nicolas has worked for Snap Analytics , ING , Chaucer Insurance , Specsavers , and MVF .

Q: Which industries is Nicolas most experienced in?

Nicolas is most experienced in industries like Banking and Finance , Insurance , and Retail . Nicolas also has some experience in Advertising , Construction , and Tourism and Hospitality .

Q: Which business areas is Nicolas most experienced in?

Nicolas is most experienced in business areas like Business Intelligence , Information Technology (IT) , and Supply Chain Management . Nicolas also has some experience in Procurement and Purchasing , Finance , and Marketing .

Q: Which industries has Nicolas worked in recently?

Nicolas has recently worked in industries like Banking and Finance , Retail , and Advertising .

Q: Which business areas has Nicolas worked in recently?

Nicolas has recently worked in business areas like Business Intelligence , Information Technology (IT) , and Supply Chain Management .

Recommended expert

Whitefield, United Kingdom

Experience

Jul 2025 - Sep 2025

3 months

Senior Data Analyst

Snap Analytics

Provided data analysis skills for a customer remediation consultancy project
Used Snowflake, SQL, ELT and data modelling expertise to support the reporting requirements initiation phase

Jul 2024 - Feb 2025

8 months

Data Modeller

ING

Extracted and reformatted data into simple 3NF data models aligned with data framework standards
Curated data using analysis, modelling and mapping skills to enable a customer self-serve loan pricing option
Saved ING staff time by allowing customers to self-serve changes rather than via staff

Nov 2023 - Apr 2024

6 months

Data Consultant

Chaucer Insurance

Collected business requirements and obtained climate data for every geolocation over forty years
Employed Python scripts and different vendor APIs to ingest data into Snowflake, benchmarking timings and storage costs
Reduced data ingestion time from six days to seven hours
Documented an end-to-end solution to test risk pricing models and validate Snowflake platform suitability

Mar 2023 - Nov 2023

9 months

Data Modeller

Specsavers

Engaged stakeholders and captured data flows for manufacturing and supply chain reporting
Analyzed XML code and ETL jobs to create fully documented source-to-target data lineage
Developed logical data models and ETL transformation rules to replace an expensive BI vendor
Enabled flexible reporting and significant licensing cost savings by decommissioning Pentaho

Jul 2022 - Feb 2023

8 months

Analytics Engineer

MVF

Gathered business reporting KPIs for a new salesperson commission scheme
Built a new system with medallion layer data models, data pipelines and visualisations using Dbt, Snowflake and Looker
Identified and rectified an error in the existing system that had distorted commission calculations
Enabled implementation of new monetary incentives for salespeople

Sep 2021 - Jun 2022

10 months

Analytics Engineer

Dojo

Analyzed disparate sources of card machine orders to optimise the procurement process
Designed a common data model and built medallion layer models populated by ELT pipelines using Dbt on GCP
Created Looker dashboards to provide full inventory of card machines across the merchant network
Improved merchant relationships by meeting demand and providing accurate inventory tracking

Apr 2021 - Sep 2021

6 months

Data Business Analyst

TUI

Profiled data across Oracle and Snowflake to assess system suitability for a new enterprise data warehouse
Documented classification of systems for inclusion based on quality, reliability and suitability

Feb 2021 - May 2021

4 months

Data Modeller

National Health Service (NHS)

Interpreted bespoke non-relational ECG and EEG datasets for consolidation into new Health Trusts
Created Kimball facts and dimension models and populated them via ETL pipelines in Azure Data Factory
Provided consistent data formats for migration and holistic reporting across multiple hospitals

Mar 2020 - Dec 2020

10 months

Data Business Analyst

Hoist Finance

Conducted as-is analysis with subject matter experts to enable holistic reporting of customer digital usage across eight countries
Designed medallion layer data models and populated them using Dbt transformation rules in Snowflake
Delivered self-service Tableau visualisations, reducing call centre operational costs by increasing digital service usage

Dec 2019 - Mar 2020

4 months

Data Business Analyst

American Insurance Group

Facilitated business requirement sessions and wrote concise user stories for a new Casualty insurance system
Developed SQL testing scripts to validate software outputs against defined results
Identified and resolved software errors, ensuring stakeholder confidence in the new system

Feb 2019 - Aug 2019

7 months

Data Consultant

Aldermore Bank

Analyzed and parametrized existing SQL scripts to automate monthly marketing campaign setup
Reduced manual effort from three weeks to less than five minutes

Mar 2018 - Jan 2019

11 months

Data Business Analyst

Lloyds Banking Group

Captured new business requirements and data attributes for a commercial lending data warehouse
Provided technical ETL specifications and updated data warehouse models
Developed a generic data profiling script that uncovered lineage inaccuracies and enabled error correction

Nov 2017 - Dec 2017

2 months

Switzerland

Data Modeller

Bank for International Settlements

Designed Data Vault methodology models and source-to-target mappings for trading system changes
Used BIML to generate SSIS ETL code for staging, EDW, data marts and SSAS cubes for Tableau reporting

Jul 2017 - Sep 2017

3 months

Data Business Analyst

TSB Bank

Captured requirements, scope, priorities and business measures for a new enterprise data warehouse
Conducted data profiling of source systems and defined transformation rules to minimise delays and costs

Oct 2016 - May 2017

8 months

Data Business Analyst

Kier Plc

Analyzed Oracle E-Business Suite structures to replicate legacy reporting via SQL and Excel
Engaged business stakeholders to define reporting needs and produced enriched reports
Resolved reporting gap and improved cashflow through faster invoice payments

Apr 2016 - Aug 2016

5 months

Australia

Senior Data Analyst

University of Melbourne

Validated new Oracle E-Business Suite reporting by producing an independent report set
Facilitated stakeholder workshops to resolve critical business issues and anomalies
Ensured business confidence by matching new software reports to independent checks

Nov 2014 - Apr 2016

1 year 6 months

Australia

Senior Database Administrator

Insurance Australia Group

Reviewed Data Vault and medallion layer models for a three-year EDW build
Provided DBA support and ETL assistance to seven development streams and forty-plus developers
Signed off on data models and optimised EDW performance while balancing business milestones

Jun 2013 - Nov 2014

1 year 6 months

Sweden

Data Solutions Designer

Nordea Bank

Implemented Detica AML product on a new platform to meet financial regulations
Designed Unix bash and SQL ingestion scripts for one-off and ongoing AML data migration
Enabled compliance with regulators through accurate and timely data population

Jul 2012 - Feb 2013

8 months

Australia

Senior Database Administrator

Insurance Australia Group

Reviewed Kimball data models and provided DBA support for a new data warehouse
Reduced Informatica MDM tool open time from five minutes to five seconds

Jun 2010 - Jun 2012

2 years 1 month

Germany

Senior Database Administrator

Zurich Insurance

Delivered DBA, performance tuning and data modelling services across multiple countries
Communicated technical issues to diverse stakeholders and improved report refresh frequency from 25 to 2 minutes

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Banking and Finance (5 years), Insurance (5 years), Retail (0.5 years), Advertising (0.5 years), Tourism (0.5 years), and Healthcare (0.5 years).

Banking and Finance

Insurance

Retail

Advertising

Tourism

Healthcare

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Business Intelligence (13 years), Information Technology (9 years), Supply Chain Management (1.5 years), Procurement (1 year), Marketing (0.5 years), and Finance (0.5 years).

Business Intelligence

Information Technology

Supply Chain Management

Procurement

Marketing

Finance

Summary

Senior data consultant and career contractor delivering reliable data solutions across banking, insurance, healthcare, and government. Blends a deep understanding of traditional data modelling (3NF, Entity Relational Models, Dimensional Modelling (Kimball), Data Vault) with modern cloud technologies i.e Snowflake, Databricks, GCP, AWS and Dbt.

Focused on delivering clean, well-structured, and well-documented data that supports business reporting and analytics. Brings consistency, data clarity, technical depth, is intuitive and has reputation for being dependable and detail-oriented. Works effectively in fast-paced, evolving environments, often where requirements are not clearly defined, brings structure, logic, and momentum to the projects.

A consultant who can work independently using initiative but never forgets the benefits of teamwork and sharing tips and swapping ideas. Key strength is understanding business data and being able to explore complex data structures to provide clear and accurate source to target mappings.

Accomplished communicator in translating complex technical information to non-technical audiences. Having worked in multiple roles, fully appreciative of different needs of business and technical staff.

Skills

Databases: Snowflake, Google Big Query, Sql Server, Oracle, Db2, Postgres, Teradata, Netezza, Databricks, Mysql
Etl / Elt: Data Build Tool (Dbt), Azure Data Factory (Adf), Ssis, Datastage, Informatica
Visualisation: Tableau, Looker, Power Bi
Data Modelling: Kimball, Dimensional Modelling, Inmon, 3nf, Data Vault, Star Schema
Modelling Tools: Erwin, Er/studio, Visio, Draw.io, Visual Paradigm, Oracle Data Modeler, Uml
Programming And Scripting Languages: Sql, Python, T-sql, Pl/sql, Shell Scripting, Stored Procedures
Data Skills: Analysis, Profiling, Quality, Migration, Cleansing, Integration, Visualisation

Languages

English

Native

Latvian

Native

Education

Bachelors degree in computer science · computer science

Certifications & licenses

Advanced Dba Db2 10.5, Db2 Sql/Pl Stored Procedures, Db2 Applications Developer, Solutions Designer Infosphere, Netezza PuredData For Analytics

IBM

Business Analytics: From Data To Decisions

Imperial College London

Certified Associate Pl/SQl Developer

Oracle

Certified Professional Database 11g Database Administrator

Oracle

Data Analysis For Management (quantitative modelling techniques)

London School of Economics

Data Vault 2.0 Certificated Practitioner CDVP2

Dan.Linstedt.com

Data Vault Data Modelling 1.0 Certification CDVDM

Genesee Academy

Dbt Developer And Dbt Fundamentals

DBT Labs

MCSE: Data Management And Analytics, Data Platform, BI Development

Microsoft

Snowflake: COF-C02 - SnowPro Core Certification

Snowflake

Tableau Certified Data Analyst, Desktop Associate And Desktop Specialist

Tableau

Profile

Created

February 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Nicolas based?

Nicolas is based in Whitefield, United Kingdom.

What languages does Nicolas speak?

Nicolas speaks the following languages: English (Native), Latvian (Native).

How many years of experience does Nicolas have?

Nicolas has at least 13 years of experience. During this time, Nicolas has worked in at least 7 different roles and for 19 different companies. The average length of individual experience is 1 year and 8 months. Note that Nicolas may not have shared all experience and actually has more experience.

What roles would Nicolas be best suited for?

Based on recent experience, Nicolas would be well-suited for roles such as: Senior Data Analyst, Data Modeller, Data Consultant.

What is Nicolas's latest experience?

Nicolas's most recent position is Senior Data Analyst at Snap Analytics.

What companies has Nicolas worked for in recent years?

In recent years, Nicolas has worked for Snap Analytics, ING, Chaucer Insurance, Specsavers, and MVF.

Which industries is Nicolas most experienced in?

Nicolas is most experienced in industries like Banking and Finance, Insurance, and Retail. Nicolas also has some experience in Advertising, Construction, and Tourism and Hospitality.

Which business areas is Nicolas most experienced in?

Nicolas is most experienced in business areas like Business Intelligence, Information Technology (IT), and Supply Chain Management. Nicolas also has some experience in Procurement and Purchasing, Finance, and Marketing.

Which industries has Nicolas worked in recently?

Nicolas has recently worked in industries like Banking and Finance, Retail, and Advertising.

Which business areas has Nicolas worked in recently?

Nicolas has recently worked in business areas like Business Intelligence, Information Technology (IT), and Supply Chain Management.

What is Nicolas's education?

Nicolas holds a Bachelor in computer science.

Does Nicolas have any certificates?

Nicolas has 11 certificates. Among them, these include: Advanced Dba Db2 10.5, Db2 Sql/Pl Stored Procedures, Db2 Applications Developer, Solutions Designer Infosphere, Netezza PuredData For Analytics, Business Analytics: From Data To Decisions, and Certified Associate Pl/SQl Developer.

What is the availability of Nicolas?

Nicolas will be available from February 2026.

What is the rate of Nicolas?

Nicolas's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.