BI Data Analyst
Core
Design, develop, maintain, and improve Power BI reports, dashboards, semantic models, and paginated reports to turn data into actionable insights for business users.
Role type
BI Data Analyst
Builds
Power BI reports, dashboards, semantic models, and paginated reports
Domain
Finance / Business Intelligence
Deliverable
dashboards & analysis
Required skills
Power BI, DAX, SQL, dimensional modeling, data warehousing, requirements gathering, data validation
Preferred skills
Microsoft Fabric, Azure Data Factory, SSRS, SSIS, fintech domain knowledge, Agile delivery
Technologies
Power BI, SQL Server, Microsoft Fabric, Azure Data Factory, SSRS, SSIS, Python
Responsibilities
Design, develop, maintain, and improve Power BI reports, dashboards, semantic models, and paginated reports. Write, troubleshoot, and validate SQL queries against Microsoft SQL Server source systems. Partner with business teams to gather requirements, define KPIs, and translate business questions into reporting solutions. Apply dimensional modeling and data warehouse practices, including facts, dimensions, star schemas, and Kimball-style concepts. Validate data to confirm the accuracy, completeness, and consistency of reports and dashboards. Document report logic, data definitions, business rules, and known data limitations.