I’m an experienced BI/Data Analyst/DBA with over 10 years of hands-on experience delivering Microsoft BI stacks, data warehousing, ETL, and reporting solutions for complex OLTP environments. I’ve built centralized BI portals, implemented BI360 data warehouses, and optimized performance across multiple BuilderMT/Sage/Sales Simplicity ERP integrations. I’m passionate about turning data into actionable insights and enabling data-driven decision making. I collaborate with finance and operations teams to develop dashboards and reports in SSRS, Power BI, and SharePoint BI portals. My career spans banking, real estate development, and ERP integration projects, where I’ve led data migrations, data quality initiatives, and performance improvements to support business growth, cost control, and risk reduction.

Malcom M Sankoh

I’m an experienced BI/Data Analyst/DBA with over 10 years of hands-on experience delivering Microsoft BI stacks, data warehousing, ETL, and reporting solutions for complex OLTP environments. I’ve built centralized BI portals, implemented BI360 data warehouses, and optimized performance across multiple BuilderMT/Sage/Sales Simplicity ERP integrations. I’m passionate about turning data into actionable insights and enabling data-driven decision making. I collaborate with finance and operations teams to develop dashboards and reports in SSRS, Power BI, and SharePoint BI portals. My career spans banking, real estate development, and ERP integration projects, where I’ve led data migrations, data quality initiatives, and performance improvements to support business growth, cost control, and risk reduction.

Next availability:
May 1, 2026

I’m an experienced BI/Data Analyst/DBA with over 10 years of hands-on experience delivering Microsoft BI stacks, data warehousing, ETL, and reporting solutions for complex OLTP environments. I’ve built centralized BI portals, implemented BI360 data warehouses, and optimized performance across multiple BuilderMT/Sage/Sales Simplicity ERP integrations. I’m passionate about turning data into actionable insights and enabling data-driven decision making.

I collaborate with finance and operations teams to develop dashboards and reports in SSRS, Power BI, and SharePoint BI portals. My career spans banking, real estate development, and ERP integration projects, where I’ve led data migrations, data quality initiatives, and performance improvements to support business growth, cost control, and risk reduction.

See more

Language

English
Fluent

Work Experience

Senior Business Intelligence Analyst (BI Consulting) at Brookfield Residential
July 1, 2023 - Present
Centralized reporting SQL Server 2012 ODS design and BI/DW/ETL development. Collaborated with SharePoint team for SharePoint BI portal deployment. Data analyst and ETL development - SQL, ETL, MS replication & SAGE SQL Gateway replication solutions extracting data from BuilderMT, Timberline accounting and Sales Simplicity OLTP applications into a centralized staging and operational data store for reporting and analytics. Collaborated with SharePoint team to setup and configure a SharePoint Business Intelligence portal with SSRS, Excel Services and Performance Point services integration to host reports and dashboards for Corporate Centralized BI Portal. Developer/Analyst - Collaborate with senior management and Business Analysts to develop new reports and migrate slow reports from 3 OLTP Builder applications to SharePoint BI portal. Timberline Accounting System Implementation and Reports setup – San Francisco. Setup System and User Timberline ODBC application connections on servers inc
Senior Business Intelligence Analyst at Brookfield Residential
August 1, 2016 - July 31, 2023
9 years in role focusing on centralized reporting, data warehousing, ETL/process optimization, and BI portal integration. Responsibilities included SQL Server/SSIS/SSAS development, data modeling for a centralized ODS/DW, BI360 data warehouses, and performance optimization.
Database Analyst & Report Developer at Brookfield Residential
August 1, 2014 - August 31, 2016
DBA and BI Data Warehouse professional responsible for reporting and data warehouse development, ETL processes, and MS Dynamics/Sage BuilderMT integration. Implemented centralized reporting improvements across multiple Builder applications.
DBA and Reporting Analyst at CFF Bank
October 1, 2011 - August 31, 2014
Administration and maintenance of Banking SQL Server & SSAS databases, maintenance plans, SSIS packages and SQL Agent jobs. Led report development lifecycle, collaborated with users to gather requirements, and delivered regulatory/compliance reports.
Data Analyst/Reporting & BI Consultant at Independent / IT Industry
August 1, 2014 - August 31, 2016
Performed BI/ETL implementations and data warehousing for MS Dynamics ERP, Sage, BuilderMT, Sales Simplicity, LMS and BI360 data warehouse projects for land and housing development accounts.

Education

MBA at University of Western Ontario, Ivey School of Business
January 11, 2030 - January 8, 2026
MSc in Analytical Chemistry at University of Alberta
January 1, 1986 - August 1, 1988
Business Intelligence Certificate at SAIT Polytechnic
January 1, 2011 - May 31, 2011

Qualifications

MCTS: SQL Server 2008, BI Development and Maintenance
January 11, 2030 - January 8, 2026
MCTS (BI) – Microsoft Certified Technology Specialist
January 1, 2011 - December 31, 2013
Data8.1x: Foundations of Data Science: Computational Thinking with Python
January 11, 2030 - January 8, 2026
DAT101x: Microsoft Professional Orientation: Data Science
January 11, 2030 - January 8, 2026
DAT225x: Developing a SQL Server Analysis Services Tabular Data Model
January 11, 2030 - January 8, 2026
Windows PowerShell Basics Certificate
January 11, 2030 - January 8, 2026

Industry Experience

Software & Internet, Professional Services, Financial Services, Real Estate & Construction, Education