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 visualizations 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 ensuring BI initiatives align with key business strategies. Engage regularly with stakeholders to gather feedback and refine BI tools.
- 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 across the BI team and wider business. Own BI initiatives, ensuring valuable insights are delivered and adopted by end-users.
Technical / Professional Qualifications / Requirements
- Experience: At least 3+ years of significant experience in BI development, focusing on Microsoft Power BI, delivering client and customer-facing dashboards. Strong ability to analyze data and implement BI solutions impacting clients and business outcomes.
- Data Visualizations: Ability to design visually appealing reports and dashboards, using initiative to create effective data visualizations for stakeholders.
- Communication: Excellent skills to engage, influence, and provide critical insights to senior management and key stakeholders, including 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 Modeling: Strong understanding of data modeling 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 managing Power BI projects.
- Azure DevOps: Knowledge of using Azure DevOps Boards to manage workloads.
- 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.