Your new role
The role will help design, develop, support and enhance the use of MS SQL and related reporting solutions, dashboards, and other visual summaries of application data tomunicate performance and progress to various stakeholders across a range of business applications.
Key Responsibilities:
1. Development and maintenance of integrated reporting solutions across a range of business applications
2. Report development in Power BI Suite
3. Migration of SSRS reports to Power BI
4. Integrity and audit check data for application into reporting solutions.
5. Maintain understanding of various business application database structures
6. Act as SQL technical authority to Engineering team with ability to optimise and enhance SQL queries
7. Investigate and maintain alternative delivery formats ( dashboards, grouping, drilldown, matrix (pivoted)) to achieve maximum benefit from the underlying data.
What you'll need to succeed Essential
8. Excellent skills in T-SQL and SQL Server
9. Experience of Migration of SSRS to Power BI
10. Experience in building dashboards and reports using Power BI
11. Experience in SSRS
Highly Desirable
12. Experience of undertaking performance reviews and optimisation activities
13. Experience in data warehousing and cubes
14. Experience of MS Fabric and Azure Data Landscape
Desirable
15. Experience of SSIS data import packages using ETL procedures
16. Power Automate for Report Distribution