North Macedonia

Business Intelligence Developer

• Responsible for building and maintaining end-to-end reporting and analytics solutions by transforming raw data into reliable, business-ready insights.
• Operates across the full BI pipeline, using Python for data preparation, SQL for core transformations and modeling, and Excel Power Query, DAX, and Power BI for analytical modeling, KPI creation, and reporting.
• Works closely with business stakeholders to understand requirements, ensure data accuracy, and deliver scalable, well-structured analytics that support operational and strategic decision-making.
• Use Python to clean, normalize, validate, and prepare raw data from multiple sources (files, databases).
• Perform sorting, deduplication, enrichment, and structural transformations prior to loading.
• Load processed datasets into the data warehouse.
• Develop and maintain SQL views, transformations, and aggregations within the data warehouse.
• Apply business logic, classification rules, and KPI calculations at the SQL layer.
• Optimize SQL queries for performance, consistency, and reusability.
• Maintain clean, well-structured fact and dimension logic to support downstream analytics.
• Consume SQL-based datasets in Excel Power Query for additional shaping and model preparation.
• Build robust Data Models with clear relationships and granularity control.
• Create advanced DAX measures and calculated columns for KPIs, SLA metrics, time intelligence, and performance tracking.
• Ensure correct handling of business calendars, working hours, and edge-case scenarios.
• Design and maintain Power BI dashboards and reports for operational and management-level insights.
• Create Excel-based analytical reports and pivots where required.
• Ensure consistency of KPIs and definitions across Excel and Power BI.
• Support ad-hoc analysis requests and deep-dive investigations.
• Validate data accuracy across the entire pipeline from source to report.
• Document logic, calculations, and transformation rules.
• Proactively identify data issues, gaps, and improvement opportunities.

Business Intelligence Analyst