Role Purpose
The Senior BI Developer position is an integral part of the Analytics & Insight team within the Digital and Information function. The Senior Developer is responsible for leading the design and implementation of advanced business intelligence solutions using Microsoft Power BI, alongside the on-going support and iterative development requirements on those solutions. This strategic role involves leveraging Microsoft Azure, using best practice and appropriate methodologies, to enhance data-driven decision-making processes and deliver sophisticated analytics that drive business success. The senior developer will serve as a key technical lead, guiding junior developers and interfacing with senior stakeholders to align BI initiatives with organisational goals.
Key Responsibilities
1. Leadership in BI Development: Develop sophisticated dashboards and reports in Power BI as required, focusing on data visualisations and analytics tailored to meet evolving business needs. An appetite to challenge and critique data integrity to ensure meaningful and accurate information to support the business reporting requirements.
2. Advanced Data Solutions Design: Architect robust data models and database strategies utilising Microsoft Azure to enhance data integration and facilitate comprehensive BI environments that support business decisions.
3. Stakeholder Engagement and Support: Serve as a senior BI partner to business stakeholders, building strong relationships and ensuring that BI initiatives are closely aligned with key business strategies. Regularly engage with stakeholders to gather feedback and refine BI tools to better serve their decision-making needs.
4. Strategic Analytics Implementation: Utilise advanced analytics to extract strategic insights that influence business outcomes. Lead efforts in predictive and prescriptive analytics within Power BI to forecast trends and model business scenarios.
5. Collaboration & Development: Partner with other developers and data engineers to promote a culture of continuous learning and improvement across the BI team and the wider business. Own BI initiatives, ensuring they deliver valuable insights, and are adopted by business end-users.
Requirements
6. Experience: At least years of significant experience in BI development, with a focus on Microsoft Power BI. Strong ability to analyse data and implement BI solutions that directly impact business strategies and outcomes.
7. Communication: Excellent communication skills with proven ability to engage, influence, and provide critical insights to senior management and key stakeholders.
8. Collaboration : Experience working collaboratively with development teams, DevOps engineers, and other stakeholders to streamline Power BI development processes using Azure DevOps.
9. Expertise in Power BI: Proficiency in creating complex Power BI reports, dashboards, power query, DAX, data models, data integration from various data sources.
10. Data Modelling: Strong understanding of data modelling concepts including relationships, DAX calculations, and optimisation techniques.
11. Power BI Dataflows: Proficiency in creating and managing Power BI Dataflows to ingest, transform, and prepare data for analysis and reporting.
12. Data Visualisation: Ability to design visually appealing reports and dashboards, using initiative to design effective data visualisations to convey insights to stakeholders.
13. SQL Proficiency: Solid understanding of SQL for data manipulation, querying, and performance tuning.
14. Version Control: Familiarity with version control systems like Git for managing Power BI projects and collaboration.
15. Azure DevOps: Knowledge of using Azure DevOps Boards to manage workload.
16. Governance & Security: Understanding of implementing security best practices for Power BI, including role-based access control (RBAC).
17. Problem-Solving Skills: Ability to troubleshoot and resolve technical issues related to Power BI reports, data connections, and performance.