Business Intelligence Developer

Job Purpose

BI Solution Design and Reporting

• Design semantic data models using star schemas, relationships, hierarchies, and calculation groups.
• Build DAX measures and reusable Power Query transformations.
• Develop interactive, parameterized, drill-through, paginated, executive, and operational reports.
• Apply data visualization principles and iterate designs with stakeholders.

Business Partnership and Data Integration

• Elicit, clarify, and document reporting requirements, KPIs, and metric definitions.
• Connect and integrate data from SQL Server, APIs, files, and internal business systems.
• Build monitored dataflows and dataset refresh pipelines.
• Validate data quality and reconcile data across sources.

Performance, Governance, and Security

• Optimize data models, DAX, queries, dataset size, refresh cost, and report performance.
• Implement row-level security and role-based access.
• Manage workspaces, apps, gateways, capacities, deployments, and scheduled refreshes.
• Enforce data governance, sensitivity labelling, and controlled report sharing.

Documentation and Enablement

• Maintain data dictionaries, metric definitions, model documentation, runbooks, data lineage, and design decisions.
• Report on report adoption, usage, and data-quality metrics.
• Support user enablement and self-service BI adoption.

Qualifications and Experience

• Bachelor's or Master's degree in Computer Science, Information Systems, Data Analytics, or a related field.
• 4+ years of hands-on Power BI solution development with deep DAX and Power Query expertise.
• Strong data modelling and advanced SQL skills.
• Experience delivering executive-level dashboards and self-service analytics.
• Microsoft, Fabric, or Azure data certifications are a strong advantage.
• Financial services or regulated-industry exposure is preferred.

Functional Skills

• Advanced Power BI, DAX, Power Query M, semantic modelling, and report design.
• Strong SQL Server and T-SQL, including query performance tuning.
• Power BI Service administration, workspaces, apps, gateways, capacities, and row-level security.
• Familiarity with Microsoft Fabric, Azure data services, dataflows, Excel, Power Automate, and cloud-native Azure or AWS design.

Behavioral Skills

• Integrity, sound judgment with data, attention to detail, and commitment to accuracy.
• Curiosity, analytical problem-solving, ownership, accountability, and delivery focus.
• Strong stakeholder management and clear structured communication.
• Collaborative, team-first mindset.