BI Developer

We are seeking a talented and experienced BI Developer to join our growing data analytics team. In this role, you will be responsible for designing, developing, implementing, and maintaining robust Business Intelligence solutions using Microsoft Power BI. You will work closely with business stakeholders, data engineers, and analysts to understand requirements, transform data, and create insightful reports and dashboards that empower data-driven decision-making across the organization.

Key Responsibilities:

• Collaborate with business users and stakeholders to gather, analyse, and document reporting requirements.
• Connect to various data sources (e.g., SQL Server, Azure SQL Database, Excel, SharePoint, APIs, Dataverse) and perform data extraction, transformation, and loading (ETL) using Power Query (M language).
• Develop efficient and scalable data models within Power BI, establishing relationships and hierarchies.
• Write complex DAX (Data Analysis Expressions) formulas to create measures, calculated columns, and calculated tables for advanced analytics.
• Design, develop, and deploy visually compelling and interactive Power BI reports and dashboards adhering to best practices for UI/UX and performance.
• Implement appropriate security measures, including Row-Level Security (RLS), to control data access.
• Publish, schedule, and manage Power BI datasets, reports, and dashboards within the Power BI Service (workspaces, apps).
• Monitor and optimise the performance of Power BI solutions.
• Provide training and support to end-users on Power BI reports and dashboards.
• Troubleshoot and resolve issues related to data models, reports, and data refreshes.
• Maintain comprehensive documentation for developed solutions.
• Stay up-to-date with the latest features and best practices in Power BI and the broader Microsoft data platform ecosystem.
• Collaborate effectively with data engineers, data scientists, and other IT team members.

Required Qualifications & Skills:

• Proven experience working as a Power BI Developer or in a similar BI role.
• Strong proficiency in Power BI Desktop, including Power Query (M), Data Modelling, and DAX.
• Demonstrable experience in designing and developing effective data visualizations and dashboards.
• Solid understanding of database management systems, data warehousing concepts, and ETL processes.
• Experience querying databases using SQL.
• Excellent analytical, problem-solving, and critical-thinking skills.
• Strong communication and interpersonal skills, with the ability to translate business requirements into technical solutions.
• Bachelor's degree in Computer Science, Information Technology, Data Science, Business Analytics, or a related field, or equivalent practical experience.
• Ability to manage multiple tasks and projects simultaneously.

Preferred Qualifications & Skills:

• Experience with Power BI Service administration (managing gateways, capacities, deployment pipelines).
• Knowledge of Azure data services (e.g., Azure Data Factory, Azure Synapse Analytics, Azure SQL Database, Azure Data Lake Storage).
• Microsoft Certification (e.g., PL-300: Microsoft Power BI Data Analyst).
• Experience with other BI tools (e.g., Tableau, Qlik).
• Understanding of UI/UX principles for dashboard design.
• Experience with Python or R for data analysis is a plus.
• Familiarity with Agile/Scrum methodologies.