Business Intelligence Expert

Expert with a consulting background at McKinsey & Company. I specialize in designing and owning high-impact BI solutions that transform complex data into strategic business assets.

Proven track record in Credit Risk and Regulatory Alignment, translating business needs into scalable reporting tools using Power BI, SQL, and Python.

Rafal Paluszak

Featured Project: GUS Financial Monitor

A comprehensive analytical tool monitoring the financial health of Polish economic sectors based on aggregated GUS (F-01) data. Supporting benchmarking and sectoral risk assessment.

Data Architecture & Pipeline

From raw API data to automated business insights.

  • Extraction

    Python scripts communicating with GUS API (BDL), optimizing large-scale data retrieval.

  • Storage

    Cloud repository on AWS S3 (Data Lakehouse approach) for secure and scalable source file storage.

  • Logic & BI

    Advanced DAX for financial measures and Power Query for automated ETL and unification.

Professional Experience

Santander

Senior BI Data Analyst Expert | Santander

Jul 2024 - Present

  • Led strategic work on PKD regulatory change, ensuring compliance for 10,000+ client records
  • Built core dashboards used by 300+ monthly users, including directors and credit officers
  • Owning daily customer mapping built in SQL and integrated via automated ETL
McKinsey

Senior Solution Delivery Analyst | McKinsey & Company

Jun 2020 - Jun 2024

  • Enhanced Tableau dashboards for NWC analysis used in 30+ client projects annually
  • Developed long-term tracking tools for large-scale monthly performance monitoring
  • Mentored and upskilled 3 junior team members in technical BI delivery

Let’s connect and share insights

I am passionate about solving complex data challenges and exploring innovative BI architectures.
Whether you want to discuss industry trends, need ad-hoc consulting, or help in turning data into a competitive advantage – let’s talk.