SG Data Solutions

Founded by William Sjölin Gram

Transforming raw data into actionable intelligence through robust data architecture and analytics solutions

About Me

Bridging the gap between data and business value

William Sjölin Gram

My Journey

My journey started with an education in mathematical finance and economics and a job in risk management at the Danish Central Bank. Since then, I have gone from data analytics and dashboarding through to building datamarts and now to building data platforms.

I have partnered with organizations across finance, public sector, and consulting - both as an in-house specialist and trusted advisor — to optimize data infrastructure and derive meaningful insights. My approach combines technical expertise with business acumen to deliver practical, scalable solutions.

My Approach

My approach starts with people and purpose. Building something remarkable means understanding business objectives, team dynamics, and end-user needs. I strive to nurture a culture of collaboration, engagement, and empowerment, always contributing to an environment where every team member can thrive and succeed together.

Every project begins with understanding the unique challenges and goals at hand. Through collaborative development and well-documented processes, I commit to delivering a solution designed for smooth integration into your existing team and processes.

Workshop
Workshop

What I Do

  • Design and implement robust data pipelines
  • Build flexible and scalable data warehouse solutions
  • Develop business intelligence dashboards
  • Optimize data processes and infrastructure
  • Establish data governance and audit frameworks

Professional Competencies

Technical expertise meets business understanding

Domain Expertise

Financial Markets

Extensive experience in regulatory reporting, risk management, and financial data modeling. Deep understanding of banking operations and compliance requirements.

Banking & Finance

Deep understanding of financial institutions, regulatory requirements, and external reporting. Experience with personal and commercial banking, and financial reporting.

Property Portfolio Management

Expertise in real estate data management, portfolio analysis, and property performance metrics. Focus on data-driven property management and valuation.

Business Intelligence

Expertise in transforming raw data into actionable insights. Strong background in dashboard development and KPI monitoring.

Data Engineering

Proficient in designing and implementing data pipelines, ETL processes, and data warehouse solutions. Focus on scalability and maintainability.

Technical Expertise

Cloud & Infrastructure

  • Azure Data Factory
  • Azure Functions
  • Azure Data Lake
  • Azure SQL Database

Data Engineering

  • MS SQL Server
  • Teradata SQL
  • PostgreSQL

Programming and Analytics

  • Python Analytics Stack pandas, numpy
  • FastAPI Development REST APIs, async operations
  • R & Shiny Statistical analysis, dashboarding

Business Analytics and Reporting

  • Advanced Excel Analytics Financial modeling, Performance analytics
  • Business Intelligence Reporting solutions

Methodologies & Practices

  • Agile Scrum Experience with PI planning, sprint management, and daily standups
  • Project Management Stakeholder management and critical delivery coordination

Experience

November 2024 - Present

Founder & Data Solutions Consultant

SG Data Solutions
  • Independent data engineering and analytics consultancy
  • Delivering end-to-end data solutions for clients
  • Specializing in cloud infrastructure and business intelligence
March 2023 - October 2024

Senior Management Consultant

Implement Consulting Group
  • Led cross-industry data platform implementation projects
  • Designed performance pay systems and quality management frameworks
  • Delivered solutions across Financial Services, Construction and Public sectors
August 2021 - February 2023

Management Consultant

PwC
  • Spearheaded tax reporting engine transformation project
  • Led migration from mainframe to modern EDW solution
December 2017 - July 2021

Risk Manager

The Danish Central Bank
  • Managed currency reserve risk assessment
  • Developed and maintained risk assessment tools
  • Designed daily credit ratings reporting system
August 2015 - November 2017

Assistant Analyst

The Danish Ministry of Business and Financial Affairs
  • Conducted financial services industry analysis
  • Contributed to regulatory impact assessments
  • Developed entrepreneurship support initiatives

Projects

My portfolio of projects

Financial Services Data Migration

Regulatory Reporting Solution

Nordic Financial Services Data Center

Implemented the migration of mission-critical regulatory reporting from mainframe to modern EDW solution, affecting millions of customer records across multiple Nordic financial institutions.

19 Month Project
20+ Reports
HR Analytics Financial Modelling Compensation

Performance Pay Transformation

Global Engineering Consultancy

Led comprehensive analysis of performance pay models through multiple transformation phases, combining financial modeling with industry benchmarking to optimize compensation structures across global locations.

2 Project Phases
Global Scale
Cloud Architecture Data Integration Property Management

Cloud Data Platform

Property Portfolio Management

Developed a cloud-based data platform for property portfolio management, enabling efficient data integration and analytics across multiple property portfolios.

15 Month Project
3+ Source system integrations

Blog

My blog posts on data, technology and business

Contact

Get in touch

Let's Connect

Available for consulting and collaboration opportunities

Schedule a Meeting

Book a consultation

Location

Copenhagen, Denmark

GitHub

View Projects

Business Details

CVR: 45100901