Senior Power BI Analyst Programmer
*Hands-on business intelligence analyst/developer responsible for outlining the architecture as well as building visual analytics solutions via dashboards and reports.
*The key focus is support the Data Warehouse strategy and associated reporting development work streams enabling consolidation and transformation of core transactional data to support the use of operational, management and business intelligence solutions.
*As an analyst/developer you will be the link between the data warehouse and business, which includes participating in both DWH development and reporting projects to ensure efficiency
*The role also includes making sure that the data warehouse supports the reporting frontend Power BI platform
*Occasional travel between our offices in London, Huddersfield, Leeds and Bristol will be required
*Designing and building effective dashboard layouts and reports
*Utilising the navigation features in Power BI (e.g. bookmarks, drill-through's) to guide readers through a compelling data-driven story.
*Working with our testing team to manage the processes around client User Acceptance Testing (UAT) and fixing any defects identified.
*Publishing reports via the Power BI service
*Shaping an approach for governance and deployment of Power BI in the organisation, including advising on licensing, distribution/sharing, training and support.
*Interpreting the data/reporting requirements of business operational users and Link clients
*Understanding the needs of multiple stakeholders.
*Facilitating the negotiation of requirements amongst multiple stakeholders.
*Helping the business stakeholders envision the future and how their work will need to change to support the future.
*To support the exploration of proof of concepts and ultimately satisfying requirements
*To support the test phase of development
*Development and improvement of management reporting
Required capabilities that are particularly important for this role:
*Strong Power BI development skills and other visualisation tools
*Experienced in Data Analysis and Data Modelling
*Experienced in Data Warehousing
*Experienced in Microsoft SQL, MySQL and other RDBMS
*Able to work in an iterative, Agile approach.
*Ability to take client requirements, understand them and turn them into a powerful story told through engaging visuals in Power BI.
*Confident communicating with stakeholders of all levels including the ability to advise, train and support clients where necessary.
*Extensive experience working alongside development/project teams to deliver business needs.
*ETL concepts (experience with SSIS or similar advantageous)
*Dimensional modelling (e.g.: Kimball)
*Knowledge and experience of Prism and/or MSL