Power BI & Reporting Specialist

Quick Facts

• Role: Power BI & Reporting Specialist

Description

Build and manage the company’s reporting in Power BI—from connecting data sources and creating the data model to publishing dashboards for leadership. Gather, clean, and integrate data from accounting, CRM, sales and project systems, and Excel into a trusted single source of truth, then automate recurring management outputs. Use Microsoft Copilot across Power BI and Microsoft 365 to accelerate DAX measures, data preparation, and result summaries.

Responsibilities

• Develop and maintain corporate reporting in Power BI (data connections, modeling, dashboards)

• Collect, clean, and link data from accounting, CRM, commercial and project systems, and Excel

• Produce regular management and controlling outputs: monthly results, plan fulfillment, revenue/cost/margin trends by product and customer

• Support planning and budgeting with plan vs. actual comparisons, forecasts, and sensitivity analyses

• Define standardized metrics and KPI documentation so teams use consistent definitions

• Automate reporting using Power Automate with scheduled dataset refresh and distribution

• Present results clearly to leadership with your own interpretation of what the numbers mean

• Use Copilot in Power BI, Fabric, and Microsoft 365 to speed up DAX work and analytics workflows

Requirements

• Minimum 3 years of experience in reporting, BI, or controlling

• Advanced Power BI skills: star schema modeling, relationships, DAX, Power Query (M), and Power BI Service (publishing, permissions, scheduled refresh)

• SQL knowledge: write queries, join tables, and prepare data for the model

• Advanced Excel skills

• Practical Copilot knowledge in Power BI, Excel, and Microsoft 365, with the ability to validate outputs

• Understanding of corporate finance: income statement, margin, cash flow, plan vs. actual

• Independence and careful, accurate work (you will be the sole person in the role)

• Communication skills to discuss with leadership and explain conclusions to non-numeric colleagues

• English for reading technical documentation

Benefits

• Direct impact on company decision-making with close work with leadership

• Opportunity to build reporting architecture from the start and choose best practices

• Hybrid work and flexible working hours

• Stable Czech company with 30+ years of history and own products

• Training and paid Microsoft certifications (e.g., PL-300, Fabric)

• Office location in Prague 4 (Krč)

• 5 weeks of vacation

• Meal allowance (CZK 130 per worked day)

• Sports and cultural events

• In-company language courses

• Contribution to pension savings and Multisport card