I'm a results-driven BI professional with nearly nine years of experience turning raw data into actionable insights. I design scalable, high-performance analytics solutions using Power BI, SQL, DAX, Python, and Azure Synapse, focusing on data integrity, governance, and regulatory reporting (CRS, MiFIR, IFRS9). Across finance, technology, healthcare, and manufacturing, I enable self-service analytics, mentor data teams, and optimize cloud-based infrastructures. I'm Microsoft-certified (AZ-900, PL-300, DP-203) and passionate about empowering decision-makers with data-driven insights.

Ismail Ouennich

I'm a results-driven BI professional with nearly nine years of experience turning raw data into actionable insights. I design scalable, high-performance analytics solutions using Power BI, SQL, DAX, Python, and Azure Synapse, focusing on data integrity, governance, and regulatory reporting (CRS, MiFIR, IFRS9). Across finance, technology, healthcare, and manufacturing, I enable self-service analytics, mentor data teams, and optimize cloud-based infrastructures. I'm Microsoft-certified (AZ-900, PL-300, DP-203) and passionate about empowering decision-makers with data-driven insights.

Available to hire

I’m a results-driven BI professional with nearly nine years of experience turning raw data into actionable insights. I design scalable, high-performance analytics solutions using Power BI, SQL, DAX, Python, and Azure Synapse, focusing on data integrity, governance, and regulatory reporting (CRS, MiFIR, IFRS9).

Across finance, technology, healthcare, and manufacturing, I enable self-service analytics, mentor data teams, and optimize cloud-based infrastructures. I’m Microsoft-certified (AZ-900, PL-300, DP-203) and passionate about empowering decision-makers with data-driven insights.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert

Language

English
Fluent
French
Fluent

Work Experience

Business Intelligence Engineer Consultant at Quintet Private Bank
September 1, 2023 - November 24, 2025
Optimized regulatory reporting by streamlining Power BI reports, enhancing data accuracy and governance compliance. ELT Pipeline Development – Engineered and maintained ELT pipelines using Azure Synapse. Regulatory Compliance & Reporting – Designed and implemented Power BI dashboards tailored for CRS, IFRS9, and MiFIR reporting. Big Data Processing & Integration – Extracted and processed large-scale datasets from Office 365 Management API, improving data accessibility. Data Modeling & Accuracy – Constructed and validated data models, ensuring robust analytical insights and precise reporting. Stakeholder Collaboration – Partnered with business and IT stakeholders to gather data requirements, refine BI solutions, and enhance reporting efficiency.
Business Intelligence Engineer at ING Luxembourg
August 31, 2023 - August 31, 2023
Enhanced operational efficiency by automating and refining business intelligence solutions, reducing reporting turnaround time. Enterprise Reporting Development – Developed and deployed SAP BO reports and Power BI dashboards. Advanced Data Processing – Engineered PL-SQL objects to handle complex data transformations and enhance reporting capabilities. Data Visualization Enablement – Conducted workshops and training sessions, ensuring stakeholders could interpret and utilize BI dashboards effectively. Mentorship & Leadership – Provided technical mentorship to junior BI analysts, fostering best practices and accelerating skill development. Compliance & Risk Management – Designed and optimized regulatory reporting solutions for CRS, MiFIR, and IFRS9, improving compliance monitoring.
Senior Business Intelligence Developer at Caisse Dépôt et Placement Québec
March 1, 2022 - March 1, 2022
Elevated data quality standards by implementing proactive monitoring, and improving the accuracy and reliability of financial and investment reports. ETL Pipeline Engineering – Designed and optimized ETL workflows with SSIS, automating data integration for improved efficiency. Data Architecture & Modeling – Created and validated conceptual, logical, and physical data models, ensuring optimal system compatibility. Query Optimization – Developed high-performance T-SQL scripts to streamline data transformation and enhance analytics. Financial Data Insights – Analyzed and optimized Bloomberg data, enabling more accurate and data-driven financial decision-making. BI Self-Service Enablement – Designed and deployed interactive Power BI dashboards, empowering business teams with self-service analytics.
Business Intelligence Developer at Caisse Dépôt et Placement Québec
January 31, 2020 - January 31, 2020
Reduced manual reporting workload by automating HR analytics dashboards, increasing efficiency and data accuracy. Dashboard Development – Built and maintained Power BI dashboards to support HR analytics and workforce planning. Data Warehousing & MSBI Solutions – Designed and managed MSBI solutions (SSRS, SSAS, SSIS) to optimize enterprise data processing. BI Migration & Enhancement – Led the migration of HR reports from Tableau to Power BI, improving visualization performance and accessibility. HR Analytics & Data Marts – Developed data marts to centralize and streamline HR reporting. Cross-Team Collaboration – Worked with solution designers to refine enterprise data management strategies and align with business needs.
Business Intelligence Consultant at CGI
May 1, 2018 - May 1, 2018
Enhanced reporting efficiency by optimizing database queries, and reducing report processing times. Data Warehousing & OLAP Solutions – Designed and optimized OLAP cubes and data warehouses, improving analytical performance. End-to-End BI Development – Engineered SSRS, SSIS, and SSAS solutions, ensuring seamless business intelligence operations. Performance Optimization – Refined T-SQL queries, significantly enhancing report processing efficiency. Technical Documentation & Training – Provided documentation and technical training to streamline BI adoption.
Business Intelligence Intern at SSENSE
January 31, 2017 - January 31, 2017
Improved data quality and accuracy by designing robust data validation frameworks. Data Cleansing & Reconciliation – Standardized and reconciled data across multiple sources, ensuring consistency across NoSQL and SQL databases. Data Quality & Validation – Developed a data quality framework for postal code analysis, enhancing data accuracy. Big Data & Analytics Initiatives – Assisted in big data projects, recommending tools to optimize analytical capabilities. Data Governance Implementation – Established data quality control measures, strengthening business intelligence processes.
Business Intelligence Engineer at ING Luxembourg
August 1, 2023 - August 1, 2023
Enhanced operational efficiency by automating and refining business intelligence solutions, reducing reporting turnaround time. Enterprise Reporting Development – Developed and deployed SAP BO reports and Power BI dashboards, aligning with business objectives and regulatory mandates. Advanced Data Processing – Engineered PL-SQL objects to handle complex data transformations and enhance reporting capabilities. Data Visualization Enablement – Conducted workshops and training sessions, ensuring stakeholders could interpret and utilize BI dashboards effectively. Mentorship & Leadership – Provided technical mentorship to junior BI analysts, fostering best practices and accelerating skill development. Compliance & Risk Management – Designed and optimized regulatory reporting solutions for CRS, MiFIR, and IFRS9, improving compliance monitoring.
Business Intelligence Developer at Caisse Dépôt et Placement Québec
January 1, 2020 - January 1, 2020
Reduced manual reporting workload by automating HR analytics dashboards, increasing efficiency and data accuracy. Dashboard Development – Built and maintained Power BI dashboards to support HR analytics and workforce planning. Data Warehousing & MSBI Solutions – Designed and managed MSBI solutions (SSRS, SSAS, SSIS) to optimize enterprise data processing. BI Migration & Enhancement – Led the migration of HR reports from Tableau to Power BI, improving visualization performance and accessibility. HR Analytics & Data Marts – Developed data marts to centralize and streamline HR reporting. Cross-Team Collaboration – Worked with solution designers to refine enterprise data management strategies and align with business needs.
Business Intelligence Intern at SSENSE
January 1, 2017 - January 1, 2017
Improved data quality and accuracy by designing robust data validation frameworks. Data Cleansing & Reconciliation – Standardized and reconciled data across multiple sources, ensuring consistency across NoSQL and SQL databases. Data Quality & Validation – Developed a data quality framework for postal code analysis, enhancing data accuracy. Big Data & Analytics Initiatives – Assisted in big data projects, recommending tools to optimize analytical capabilities. Data Governance Implementation – Established data quality control measures, strengthening business intelligence processes.

Education

Master's in Business Intelligence And Analytics at University of Sherbrooke
January 11, 2030 - January 1, 2016
DESS in Information Technology at UQAM University
January 11, 2030 - January 1, 2015
Certificate in E-Commerce at HEC Montreal
January 11, 2030 - January 1, 2014
Master's degree in Business Intelligence And Analytics at University of Sherbrooke
January 11, 2030 - January 1, 2016
DESS in Information Technology at UQAM University
January 11, 2030 - January 1, 2015
Certificate in E-Commerce at HEC Montreal
January 11, 2030 - January 1, 2014

Qualifications

Azure Fundamentals (AZ-900)
January 11, 2030 - November 24, 2025
Power BI Data Analyst (PL-300)
January 11, 2030 - November 24, 2025
Data Engineering on Microsoft Azure (DP-203)
January 11, 2030 - November 24, 2025
Fabric Analytics Engineer Associate (DP-600) [Upcoming]
January 11, 2030 - November 24, 2025
Fabric Data Engineer Associate (DP-700) [Upcoming]
January 11, 2030 - November 24, 2025
CRS Regulatory Reporting
January 11, 2030 - November 24, 2025
MiFIR Regulatory Reporting
January 11, 2030 - November 24, 2025
IFRS9 Compliance Reporting
January 11, 2030 - November 24, 2025

Industry Experience

Financial Services, Healthcare, Manufacturing, Software & Internet, Professional Services

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert