You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Ilija KjamilovIK

Ilija Kjamilov

Data Analyst | Power BI Developer, BigQuery, SQL

โ‚ฌ350/day
Skopje, MK
3-7 years

Average response time: 1 hour

About Ilija

๐™„ ๐™—๐™ช๐™ž๐™ก๐™™ ๐™›๐™–๐™จ๐™ฉ, ๐™ง๐™š๐™ก๐™ž๐™–๐™—๐™ก๐™š ๐™‹๐™ค๐™ฌ๐™š๐™ง ๐˜ฝ๐™„ ๐™จ๐™ฎ๐™จ๐™ฉ๐™š๐™ข๐™จ ๐™ฉ๐™๐™–๐™ฉ ๐™ฉ๐™ช๐™ง๐™ฃ ๐™ข๐™š๐™จ๐™จ๐™ฎ ๐™™๐™–๐™ฉ๐™– ๐™ž๐™ฃ๐™ฉ๐™ค ๐™˜๐™ก๐™š๐™–๐™ง ๐™™๐™š๐™˜๐™ž๐™จ๐™ž๐™ค๐™ฃ๐™จ. ๐™๐™ง๐™ค๐™ข ๐™Ž๐™Œ๐™‡ ๐™ข๐™ค๐™™๐™š๐™ก๐™จ ๐™ฉ๐™ค ๐™™๐™–๐™จ๐™๐™—๐™ค๐™–๐™ง๐™™ ๐™™๐™š๐™ซ๐™š๐™ก๐™ค๐™ฅ๐™ข๐™š๐™ฃ๐™ฉ ๐™–๐™ฃ๐™™ ๐™™๐™–๐™ฉ๐™– ๐™ซ๐™ž๐™จ๐™ช๐™–๐™ก๐™ž๐™ฏ๐™–๐™ฉ๐™ž๐™ค๐™ฃ, ๐™„ ๐™™๐™š๐™จ๐™ž๐™œ๐™ฃ ๐™ฉ๐™๐™š ๐™ฅ๐™–๐™ฉ๐™, ๐™™๐™ค ๐™ฉ๐™๐™š ๐™ฌ๐™ค๐™ง๐™ , ๐™–๐™ฃ๐™™ ๐™จ๐™๐™ž๐™ฅ. ๐™„ ๐™ค๐™—๐™จ๐™š๐™จ๐™จ ๐™ค๐™ซ๐™š๐™ง ๐™‹๐™ค๐™ฌ๐™š๐™ง ๐˜ฝ๐™„, ๐™˜๐™ก๐™š๐™–๐™ฃ ๐™Ž๐™Œ๐™‡, ๐™จ๐™ฉ๐™ง๐™ค๐™ฃ๐™œ ๐˜ฟ๐˜ผ๐™“, ๐™–๐™ฃ๐™™ ๐™™๐™–๐™จ๐™๐™—๐™ค๐™–๐™ง๐™™๐™จ ๐™ฅ๐™š๐™ค๐™ฅ๐™ก๐™š ๐™–๐™˜๐™ฉ๐™ช๐™–๐™ก๐™ก๐™ฎ ๐™ช๐™จ๐™š.

๐™’๐™๐™–๐™ฉ ๐™ฎ๐™ค๐™ช ๐™ฃ๐™š๐™š๐™™


๐Ÿ”น A Power BI dashboard that is fast, clear, and trusted
๐Ÿ”น SQL and DAX that give the same number every time
๐Ÿ”น Simple updates and scheduled refresh, not manual work

๐™’๐™๐™–๐™ฉ ๐™„ ๐™™๐™š๐™ก๐™ž๐™ซ๐™š๐™ง


๐Ÿ”น End to end Power BI delivery: requirements, model, data visualization, handoff
๐Ÿ”น SQL foundations and reusable DAX measures
๐Ÿ”น Clean, fast dashboard development with the right KPIs and RLS
๐Ÿ”น Automation for refreshes and reporting using Power BI service and Power Automate

๐™ƒ๐™ค๐™ฌ ๐™ฌ๐™š ๐™ฌ๐™ค๐™ง๐™ 


๐Ÿญ. Scope and KPIs: we define the decision and the minimum dashboard development to support it
๐Ÿฎ. Data prep: source analysis, SQL modeling, Power Query M, transformations that keep Power BI fresh
๐Ÿฏ. Modeling: star schemas, DAX measures, consistent data visualization and performance
๐Ÿฐ. Build: focused Power BI pages, simple navigation, fast visuals
๐Ÿฑ. Automate: gateway setup, refresh schedules, row level security RLS, report distribution
๐Ÿฒ. Handoff: docs and training so your team runs the BI stack with confidence

๐™๐™š๐™˜๐™ ๐™จ๐™ฉ๐™–๐™˜๐™ 


๐Ÿ”น Power BI, SQL, DAX, Power Query M, data modeling, ETL automation, reporting automation
๐Ÿ”น Power Automate, SharePoint, embedded analytics, data cleaning, data transformation, data wrangling
๐Ÿ”น KPI design, SSMS and SQL Server, scheduled data pipelines, row level security RLS, BI consulting

๐™„ ๐™–๐™ข ๐™–๐™ซ๐™–๐™ž๐™ก๐™–๐™—๐™ก๐™š, ๐™ก๐™š๐™ฉโ€™๐™จ ๐™˜๐™๐™–๐™ฉ!
  • English

    Native or bilingual

  • German

    Conversational

Remote only
Primarily works remotely

Experience

  • Freelance
    BI Developer & Data Analyst
    May 2023 - Today (3 years and 2 months)
    โ€ข โ–ช Delivered 150+ Power BI, Tableau and Looker Studio dashboards across healthcare, recruitment, ecommerce and operations industries
    โ€ข โ–ช Built end-to-end BigQuery data warehouses connecting multiple API sources including CIN7, Xero, Zoho CRM, Tago.IO (IoT), Wialon (fleet tracking) and affiliate platforms
    โ€ข โ–ช Managed single-client engagements exceeding 2,300 hours โ€” acting as primary BI partner for data modeling, pipeline setup, dashboard delivery and stakeholder reporting
    โ€ข โ–ช Connected Power BI and Looker Studio to Sage, SQL Server, Azure SQL, Google Sheets and REST APIs via Power Query M, Skyvia and SyncHub
    โ€ข โ–ช Built Power Automate and Zapier workflows for scheduled report delivery, Slack/Teams alerts and SharePoint automation
    โ€ข โ–ช Delivered complete documentation and training handoffs so clients can manage BI stacks independently
    Microsoft Power BI BigQuery
  • ProCredit Bank Macedonia
    Management Information Systems Specialist
    August 2022 - May 2023 (9 months)
    โ€ข โ–ช Built and maintained the bank's internal SQL-based reporting infrastructure โ€” writing complex stored procedures, ad-hoc queries and optimized data extracts with strict SLA deadlines
    โ€ข โ–ช Developed Power BI dashboards for credit portfolio analysis, branch performance and operational KPIs used by senior management daily
    โ€ข โ–ช Created RDL reports and data visualizations in Visual Studio for regulatory and compliance reporting
    โ€ข โ–ช Worked with OLAP cubes, multidimensional models and ETL pipelines in SQL Server Management Studio
    โ€ข โ–ช Automated recurring subscription reports eliminating hours of manual reporting work per week
  • Agile Pro Solutions
    CRM Specialist & Data Analyst
    March 2022 - August 2022 (5 months)
    โ€ข โ–ช Built dashboards and reports in Zoho Analytics; managed CRM workflows and automations in Zoho CRM
    โ€ข โ–ช Integrated two software systems using Power Automate and migrated data using Skyvia
    โ€ข โ–ช Designed marketing campaign reports and visuals in Zoho Analytics; implemented Google Analytics tracking for landing pages

Recommendations

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • MSc
    Ss. Cyril and Methodius University
    2014
    MSc
  • BS
    Ss. Cyril and Methodius University
    2012
    BS

Categories