Available to hire
Data analyst with 9 years of experience turning large-scale behavioural and financial data into decisions. Currently owning subscription and product analytics on a consumer platform with 100M+ monthly active users, leading cohort/funnel analysis, churn and LTV tracking, and rigorous validation so stakeholders see reliable numbers.
Daily work includes advanced multi-step SQL on MPP engines (Athena/Presto/Redshift-class), governed BI delivery (Power BI/Tableau/Superset/Amplitude), and practical AI-assisted workflows for prompt-driven SQL generation and analytical QA (Claude + MCP-based tooling). Experienced in remote, fast-paced multi-timezone teams with strong data quality and reconciliation discipline.
Skills
Experience Level
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Language
English
Fluent
French
Fluent
Work Experience
Data Analyst — Subscription & Product Analytics at The Weather Company
February 1, 2026 - PresentOwn subscription revenue and user-behaviour analytics on a consumer platform with 100M+ monthly active users. Build cohort and funnel analyses across trial-to-paid conversion, churn and MRR for senior stakeholders. Write complex multi-step SQL on petabyte-scale data using Athena/Presto (window functions, CTEs, large joins) and apply performance tuning and query optimisation. Traced a reconciliation gap across billing sources (RevenueCat, Zuora) that materially inflated reported conversion rates. Designed event-tracking governance across 150+ events, including deduplication and metric-definition documentation. Use AI-assisted workflows daily (prompt-driven SQL generation, automated insight summaries, and QA with Claude + MCP-based tooling).
Analytics Engineer / Power BI at Alchemee SARL — Arendt & Medernach Luxembourg
March 1, 2025 - January 31, 2026Developed self-serve dashboards on governed data using Power BI semantic models and DAX measures, including row-level security (RLS) on a Databricks/Delta Lake Medallion platform. Drove reporting automation and performance optimisation.
Data Engineer / Analytics Engineer at Sword Group — Quintet Private Bank
May 1, 2024 - February 28, 2025Built ELT pipelines on Azure Synapse and delivered Power BI reporting for compliance and security analytics. Implemented validation and quality controls for sensitive regulatory datasets.
BI Consultant at Orange Business — Banque de Luxembourg
September 1, 2023 - March 31, 2024Delivered SSIS ETL pipelines for finance data and supported T-SQL optimisation and reporting requirements with finance teams.
Business Intelligence Engineer Consultant at Quintet Private Bank
September 1, 2023 - November 24, 2025Optimized 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, 2023Enhanced 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.
Business Intelligence Engineer at ING Luxembourg
August 1, 2023 - August 1, 2023Enhanced 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.
BI Consultant — Semantic Modeling Lead at DataFab — ING Luxembourg
March 1, 2022 - June 30, 2023Led migration of regulatory reporting (CRS, MiFIR, IFRS 9) from SAP BusinessObjects to Power BI. Mentored junior BI analysts and supported semantic/model governance for reporting delivery.
Senior Business Intelligence Developer at Caisse Dépôt et Placement Québec
March 1, 2022 - March 1, 2022Elevated 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, 2020Reduced 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 Developer at Caisse Dépôt et Placement Québec
January 1, 2020 - January 1, 2020Reduced 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.
Senior BI Developer / Data Modeler at CDPQ (Caisse de dépôt et placement du Québec)
June 1, 2018 - March 31, 2022Provided high-performance T-SQL data modelling and executive reporting for an institutional investor. Produced Excel-based financial summaries alongside Power BI dashboards and supported investment decision workflows using Bloomberg datasets. Worked on ERP data extraction from Dynamics 365 F&O into a SQL Server warehouse and reporting in Power BI, then embedded back into Dynamics for business users.
Business Intelligence Consultant at CGI
May 1, 2018 - May 1, 2018Enhanced 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.
BI Consultant at CGI — Client: Masonite International
February 1, 2017 - May 31, 2018Used EasyMorph alongside SSIS to clean, harmonise and reshape SAP ECC data across finance and supply chain for enterprise reporting. Gathered requirements directly with plant leadership and head of after-sales.
Business Intelligence Intern at SSENSE
January 31, 2017 - January 31, 2017Improved 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 Intern at SSENSE
January 1, 2017 - January 1, 2017Improved 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.
BI Intern at SSENSE
June 1, 2016 - January 31, 2017Supported data preparation and transformation activities as a BI intern in Montreal.
Education
Master's in Business Intelligence And Analytics at University of Sherbrooke
January 11, 2030 - January 1, 2016DESS in Information Technology at UQAM University
January 11, 2030 - January 1, 2015Certificate in E-Commerce at HEC Montreal
January 11, 2030 - January 1, 2014Master's degree in Business Intelligence And Analytics at University of Sherbrooke
January 11, 2030 - January 1, 2016DESS in Information Technology at UQAM University
January 11, 2030 - January 1, 2015Certificate in E-Commerce at HEC Montreal
January 11, 2030 - January 1, 2014Master's in Business Intelligence and Analytics at University of Sherbrooke
January 1, 2016 - January 1, 2016Graduate Diploma (DESS) in Information Technology at UQAM
January 1, 2015 - January 1, 2015Qualifications
Azure Fundamentals (AZ-900)
January 11, 2030 - November 24, 2025Power BI Data Analyst (PL-300)
January 11, 2030 - November 24, 2025Data Engineering on Microsoft Azure (DP-203)
January 11, 2030 - November 24, 2025Fabric Analytics Engineer Associate (DP-600) [Upcoming]
January 11, 2030 - November 24, 2025Fabric Data Engineer Associate (DP-700) [Upcoming]
January 11, 2030 - November 24, 2025CRS Regulatory Reporting
January 11, 2030 - November 24, 2025MiFIR Regulatory Reporting
January 11, 2030 - November 24, 2025IFRS9 Compliance Reporting
January 11, 2030 - November 24, 2025Microsoft Certified: Power BI Data Analyst Associate (PL-300)
January 11, 2030 - August 27, 2026Microsoft Certified: Azure Data Engineer Associate (DP-203)
January 11, 2030 - August 27, 2026Microsoft Certified: Azure Fundamentals (AZ-900)
January 11, 2030 - August 27, 2026SAP Certified — MySAP ERP ECC 6.0: Fundamentals & Integration of Business Processes
January 1, 2015 - August 27, 2026Industry Experience
Financial Services, Healthcare, Manufacturing, Software & Internet, Professional Services, Media & Entertainment, Other
Skills
Experience Level
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Hire ISMAIL OUENNICH today
To get started post up your job and then invite ISMAIL OUENNICH to your job.