Back to search
- Development and maintenance of integrated reporting solutions across a range of business applications
- Integrity and audit check data for application into reporting solutions
- Maintain understanding of various business application database structures
- Support ad-hoc report generation or data extracts via T-SQL queries
- Act as SQL technical authority to Engineering team with ability to optimise and enhance SQL queries
- Interpret written functional requirements and technical specification documents and translate into reporting deliveries
- Investigate and maintain alternative delivery formats (e.g. grouping, drilldown, matrix (pivoted)) to achieve maximum benefit from the underlying data
- Contribute to improve the overall engineering processes / methodologies followed by the team
- SSIS package development for reporting imports
- Report model ownership and updates as requested from key system stakeholders
- Report development in SSRS
- Assist as needed with staff training of Report Builder or equivalent self-service reporting solutions in the wider business
- Work alongside other technical staff within the Infrastructure and Development teams to maximise the performance and robustness of the underlying databases
- Experience in building reports using Power BI
- Excellent skills in SQL Server
- Experience of SSIS data import packages using ETL procedures
- Experience of producing reports using SSRS
- Experience of undertaking performance reviews and optimisation activities
- Experience in data warehousing and cubes
