Power BI Developer

Job Description

Power BI Administrator & DeveloperLocation: UK (Job is not location specific - could be London / Leeds / Newcastle, etc.)Salary: £36,716 - £48k plus bonus and benefitsPurpose of the Job: To support the development and maintenance of core technologies especially Microsoft Power BI cloud based services to ensure the solution within a specified domain meet the needs of the business.To deliver information management and data analytics services to IT Managers utilising the Common Data Hub and data visualisation tools (e.g. Power BI) and the MS Power platformKey Accountabilities: Power BI Analyst Developer*Produce technical designs as part of elaboration in projects*Provide accurate (+/- 10%) estimates of timescales for projects*Use corporate standards to communicate technical design for approval*Assess technical / business risks whilst on projects, with appropriate mitigation*Develop robust and accurate reporting solutions using a range of tools and techniques*Develop code to meet user requirements and internal controls framework*Create documentation for operational applications and IT support processes*Perform integration testing to ensure units of code work together prior to release for UAT*Regression test core code to ensure no impact on unchanged functionality*Prepare and submit release instructions for UAT and Production*Support bug fixing during testing phase of development lifecycle*Support Application Support Analysts and DBAs throughout the release process*Troubleshoot, resolve and document end user problems*Support the EDW Manager in managing the design, modelling and construction of a corporate data warehouse, supporting data marts and reporting infrastructure using AWS and Microsoft BI technology*Support the EDW Manager in managing data warehouse schemas to ensure a robust and flexible framework is utilised to support efficient reporting development*Support the UK Data Hub Manager in managing technical issues and requests for additional information to ensure the consistent, timely provision of data and information to internal customers in line with Service Level Agreements*Support the UK Data Hub Manager in the creation and on-going management of a UK-wide BI Competency Centre, including but not restricted to governance structures, business and technical support processes and development approachesPower BI Capacity Administrator (secondary role)*Take on the Microsoft Power BI Capacity Administrator role for the UK*Monitor performance and capacity of the UK Microsoft Power BI Capacity and take appropriate action to scale and uplift the capacity when required.*Support the UK Data Hub Manager in the budget planning for future scalability and support of the UK Microsoft Power BI Capacity*Implement and develop the UK Power BI Gateway hosted on the AWS Common Data Hub*Research resource hungry workspace applications to Identify areas for, and support delivery of, improvements to reduce support overhead, cost of ownership and improve the customer experience*Assist Power BI users to migrate existing content from the Standard to the capacityOutcome, Results and Key Performance Indicators:Power BI Analyst Developer*Contribute to maintenance and support activity*Contribute to managing against SLAs*Support technical delivery to time, scope and quality*Ensure no negative business impact from BI releases*Ensure all BI solutions meet agreed Service Level Agreements*Provide technical training and advice to other team members and the wider business*Develop code to meet the internal coding standards*Support the capture of business and information requirements as part of BI development projects*Analyse and interpret data for MI and reporting purposes*Participate in projects and strategic initiatives that require data integration, data migration or data warehousing to support efficient reporting development*Support the evaluation, selection and implementation of BI technologies*Comply with all internal controls and governance frameworks*Ensure Power BI gateway and UK Data Hub provide workspace owners with the required access to data to develop and implement the BI reporting needs of the business.*Support the management and maintenance of the BI architecture to ensure that it is fit for purpose and maximises return on investmentKnowledge and Skills: The job holder will have:*Excellent working knowledge of Microsoft Power BI*Working knowledge of user experience design and data visualisation techniques and best practices*Working knowledge of Microsoft Office 365 and interactions beween MS Teams, Sharepoint, Outlook, and PowerBI*Knowledge of Data Warehouses, ETL and other BI Platforms*Knowledge of AWS is desireable*Knowledge of Quicksight; Glue; Redshift; Snowflake; Informatica; SAP Data Services; or Business Objects is beneficial*Able to demonstrate a practical approach to problem solving*Able to communicate technical issues and concepts to a wide ranging audience*Able to work with data analysts in the wider operational business to build new and improve existing workspace applications*Proven ability to organise and produce work within deadlinesExperience: The job holder will have:*Experience of developing and maintaining a Capacity and Power BI Gateway at Enterprise level*Experience in transforming business requirements into practical BI solutions using formal project management methodologies*Experience of interacting with and managing the expectations of a wide range of stakeholders both within IT and in the wider business *Experience with the Wider MS Power Platform capabilitiesCertes Computing (and all of its subsidiary companies) is committed to promoting equality and diversity in its business operations.