Internship Power BI & Data – Hatio

The internship at Hatio involves writing SQL queries, building Power BI datasets, creating dashboards, and ensuring data accuracy while supporting ad hoc analysis requests. The role requires effective communication to translate business questions into report requirements.

Write and maintain SQL queries (views/stored queries/scripts) to extract data from DB tables safely and efficiently. Understand the business questions (ops, sales, warehouse, finance) and translate them into report requirements and metrics. Build Power BI datasets: data modelling (star schema), relationships, calculated columns/measures (DAX), and refresh logic. Create dashboards and reports with drilldowns, filters, and clear definitions (metric logic, date logic, exclusions). Set up scheduled refresh (gateway if needed), monitor failures, and fix breaking changes when the DB schema shifts. Validate data accuracy: reconciliation against source tables and spot checks with stakeholders. Document everything: data dictionary, query notes, metric definitions, and refresh/runbook steps. Support ad hoc analysis requests and small automation tasks (export, parameterised queries, basic ETL improvements).