Requirements:

Work closely with the key business leads, senior management teams, and ICT to raise the profile and effectiveness of business intelligence & performance management
To advise and work with Senior Management and colleagues across OH to develop and implement a consistent, strong approach to business intelligence.
Ensure single figures can be reported and avoid duplication in KPI and other corporate information
To carry out Data Modelling and identify dimensions and types of granularity according to the business needs for reporting
To develop new ad-hoc reports and maintain and build on existing reports
To facilitate the day-to-day collation and management of the monthly and quarterly Key Performance Indicator data and commentary
To gather business requirements and then directly develop business intelligence
Assist the implementation of systems, policies, procedures, guidance, and supporting governance for those with responsibilities in data.
Support the evolving and expanding challenges in data.

Key Responsibilities:

Take business requirements and convert them into technical requirements
Developing visual reports, dashboards, and KPI scorecards using Power BI
Excellent in analytical thinking for translating data into informative visuals and reports
Communicate with all levels of staff
Create reports for requested projects
Participation/feedback on data warehouse design Essential knowledge, skills and experience
Data Analysis, Design, Implementation, Administration, OLAP, ETL, Data Warehousing, Data Mining, and Data Modelling
Expert knowledge in Power BI, Datasets, ETL, PBI Dashboards.
Experience in configuration and maintain Report Manager and Report Server for SSRS, SSIS, Deploy and Schedule the Reports in Report Manager
Experience in developing parameterised reports, sub-reports by time period (year, quarter, month weekday)
Experience in full Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance)
Advanced experience with Microsoft Office packages, for example, Excel, Visio and Project.
Ability to analyze data using pivot tables and formulae within Excel to extract information, interpret trends and issues.
Excellent numeracy skills, able to analyse, interpret and present information.
Excellent written communication skills for effective correspondence, written statements, report writing and statistical work.
Excellent verbal communication skills
Ability to work within a fast paced changing environment and respond to internal and external pressures.
A proactive approach to problem-solving.
Business Analysis/Requirements gathering
Able to prioritise work and negotiate a delivery timeline with senior stakeholdersGood understanding of MS Dynamics D365 CRM.

Skills:

To disseminate information to colleagues and senior management where appropriate.
Strong communication skills written and oral
Ability to analyse and map out complex information and processes.
Ability to lead on projects and achieve results.
Ability to undertake computer assisted analysis.
Excellent time management, organisation skills and work under pressure.
Ability to work effectively independently and to meet deadlines.
Demonstrable understanding of equality issues, respecting and valuing individuals' diversity and the variety of their contributions. Desirable knowledge, skills, and experience
Housing System knowledge/experience.
Project management
Data Quality activities
Azure
Data Warehouse methodology and experience of development of one
SQL Server Analysis Services
3-5 years working with Power BI & Microsoft Dynamics CRM Professional qualifications or memberships

• BS/MS in Computer Science or Information systems or equivalent

Power Bi Report developer