I am an experienced Microsoft Azure BI Data Architect with 21 years of hands-on experience in integrating and developing data warehouses and BI solutions. I have worked with both real-time and batch data across cloud and on-premises environments, and I am a Microsoft Certified Trainer (MCT) for BI and BizTalk. I have delivered Azure-based data warehouses, tabular cubes, and KPI-driven reporting, leveraging Azure Synapse Analytics, Data Factory, SSIS/SSAS, and Power BI. I focus on GDPR-compliant architecture, cost-optimized data platforms, and enabling developers to be productive with familiar tooling. I enjoy collaborating with clients to deliver measurable business outcomes and have a proven track record of delivering high-quality BI solutions on time across complex, multi-source environments.

Nishil Jain

I am an experienced Microsoft Azure BI Data Architect with 21 years of hands-on experience in integrating and developing data warehouses and BI solutions. I have worked with both real-time and batch data across cloud and on-premises environments, and I am a Microsoft Certified Trainer (MCT) for BI and BizTalk. I have delivered Azure-based data warehouses, tabular cubes, and KPI-driven reporting, leveraging Azure Synapse Analytics, Data Factory, SSIS/SSAS, and Power BI. I focus on GDPR-compliant architecture, cost-optimized data platforms, and enabling developers to be productive with familiar tooling. I enjoy collaborating with clients to deliver measurable business outcomes and have a proven track record of delivering high-quality BI solutions on time across complex, multi-source environments.

Available to hire

I am an experienced Microsoft Azure BI Data Architect with 21 years of hands-on experience in integrating and developing data warehouses and BI solutions. I have worked with both real-time and batch data across cloud and on-premises environments, and I am a Microsoft Certified Trainer (MCT) for BI and BizTalk. I have delivered Azure-based data warehouses, tabular cubes, and KPI-driven reporting, leveraging Azure Synapse Analytics, Data Factory, SSIS/SSAS, and Power BI.

I focus on GDPR-compliant architecture, cost-optimized data platforms, and enabling developers to be productive with familiar tooling. I enjoy collaborating with clients to deliver measurable business outcomes and have a proven track record of delivering high-quality BI solutions on time across complex, multi-source environments.

See more

Experience Level

Expert
Expert
Expert
Expert

Language

Norwegian
Fluent
English
Fluent

Work Experience

Senior Microsoft BI Architect at Knish Technologies AS
August 1, 2023 - November 1, 2025
Current role delivering Azure Fabric-based data warehouse solutions using Data Factory, Spark Pools, and Power BI datasets to host tabular cubes and Python notebooks (PySpark/SparkSQL). Designed Bronze-Silver-Gold data layers, integrated Dataverse Synapse Link, and IoT data; performed cost optimization for Spark pools and ensured GDPR-aligned architecture and developer usability.
Senior Microsoft BI Architect at Knish Technologies AS
July 31, 2023 - July 31, 2023
Led the OBOS Digital BI Information Platform with Azure Synapse Analytics, dedicated SQL Pools, serverless pools, Spark Pools, and Azure Analysis Services; built data pipelines reading from FTP, SQL DB, Synapse Link, and Dataverse; integrated Dynamics CRM; implemented Dataverse Synapse Link and IoT data integration; conducted cost analyses and aligned architecture with Microsoft recommendations.
Senior BI Software Consultant at Veidekke AS
August 31, 2021 - August 31, 2021
Senior BI Architect responsible for Microsoft BI data warehouse projects; migrated SSIS packages to Data Factory/Logic Apps, built cubes in SSAS Tabular, and created Power BI dashboards; migrated Dynamics 365 ERP sources; designed and implemented Azure-based BI platform.
Senior BI Software Consultant at EVRY AS
March 31, 2016 - March 31, 2016
Senior BI Software Consultant for Microsoft BI and BizTalk projects; contributed to Evry Financial Reporting including financial, billing, and sick leave reports; implemented SSIS/SSAS solutions and access control design; supported PerformancePoint and Excel-based reporting.
Senior BizTalk Consultant at Crayon AS
May 1, 2011 - May 1, 2011
Senior BizTalk consultant working on BizTalk/SharePoint projects; designed integrations, migration to newer servers, and ensured ETL/BI data flows between systems.
Senior BizTalk Consultant at Hands AS
February 1, 2009 - February 1, 2009
Senior BizTalk/Dynamics AX projects; led integration efforts and maintained BizTalk environments for enterprise-scale processes.
Senior BizTalk Consultant at CapGemini India
April 1, 2008 - April 1, 2008
Senior BizTalk Consultant performing client engagements across BizTalk projects, including design and development of integration solutions.
Senior BizTalk Consultant at Wirpo Technologies (India)
April 1, 2007 - April 1, 2007
Senior BizTalk Consultant delivering BizTalk-based integrations for multiple clients.
Junior BizTalk Consultant at Byzan System (India)
August 1, 2006 - August 1, 2006
Junior BizTalk Consultant contributing to BizTalk projects and integration tasks.
Junior Developer at Rajguru Enterprises
June 1, 2005 - June 1, 2005
VB/SQL development role providing early career support and maintenance duties.

Education

Bachelor of Computer Engineering at Mumbai University, Mumbai, India
January 1, 2000 - January 1, 2004
Pre-University College with Majors in Computers at Goklibai College, Mumbai, India
January 1, 1998 - January 1, 2000

Qualifications

Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
June 1, 2024 - November 1, 2025
Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI (DP-500)
July 1, 2023 - November 1, 2025
Azure Data Engineer Associate (DP-203)
July 1, 2022 - November 1, 2025
MCTS: SQL Server 2008, BI Development and Maintenance
May 1, 2010 - November 1, 2025
MCTS: Office SharePoint Server 2010 - Application Development
May 1, 2010 - November 1, 2025
MCTS: BizTalk Server 2004
January 1, 2005 - November 1, 2025
MCTS: BizTalk Server 2006
January 1, 2008 - November 1, 2025

Industry Experience

Software & Internet, Professional Services, Other