The Senior BI Analyst/Developer position is an integral part of the Analytics & Insight team within the Digital and Information function. The Senior Developer is responsible for delivering the design and implementation of customer and client-facing dashboard solutions using Microsoft Power BI, alongside ongoing support and iterative development of those solutions. This strategic role involves leveraging Microsoft Azure, using best practices and appropriate methodologies, to enhance data-driven decision-making processes and deliver sophisticated analytics that drive client insights. The Senior Developer will serve as a key technical lead, guiding junior developers and coordinating with senior stakeholders, including members of the Sales team, to deliver value through reporting and insights.
Key Responsibilities
- Leadership in BI Development: Develop sophisticated dashboards and reports in Power BI, focusing on data visualisations and analytics tailored to meet evolving business needs. Challenge and critique data integrity to ensure meaningful and accurate information supports business reporting requirements.
- Advanced Data Solutions Design: Architect robust data models and database strategies utilizing Microsoft Azure to enhance data integration and facilitate comprehensive BI environments supporting business decisions.
- Stakeholder Engagement and Support: Act as a senior BI partner to business stakeholders, building strong relationships and aligning BI initiatives with key business strategies. Engage regularly to gather feedback and refine BI tools for better decision-making support.
- Strategic Analytics Implementation: Use advanced analytics to extract strategic insights influencing business outcomes. Lead efforts in predictive and prescriptive analytics within Power BI to forecast trends and model scenarios.
- Collaboration & Development: Partner with other developers and data engineers to foster continuous learning and improvement. Own BI initiatives ensuring valuable insights are delivered and adopted by end-users.
Technical / Professional Qualifications / Requirements
- Experience: Significant experience in BI development, focusing on Power BI, delivering client-facing dashboards. Strong ability to analyze data and implement solutions impacting clients and business outcomes.
- Data Visualisations: Ability to design visually appealing reports and dashboards, using effective visualizations to convey insights to stakeholders.
- Communication: Excellent skills in engaging, influencing, and providing insights to senior management and external clients.
- Collaboration: Experience working with development teams, DevOps engineers, and stakeholders to streamline Power BI development using Azure DevOps.
- Expertise in Power BI: Proficiency in creating complex reports, dashboards, Power Query, DAX, data models, and data integration from various sources.
- Data Modelling: Strong understanding of data modelling concepts, relationships, DAX calculations, and optimization techniques.
- Power BI Dataflows: Proficiency in creating and managing Dataflows for data ingestion, transformation, and preparation.
- SQL Proficiency: Solid understanding of SQL for data manipulation, querying, and performance tuning.
- Version Control: Familiarity with version control systems like Git for project management and collaboration.
- Azure DevOps: Knowledge of using Azure DevOps Boards for workload management.
- Governance & Security: Understanding of implementing security best practices, including RBAC, for Power BI.
- Problem-Solving Skills: Ability to troubleshoot and resolve technical issues related to reports, data connections, and performance.