Report Engineer

Connells Group

Central Milton Keynes, United Kingdom

2 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Languages

English

Job location

Central Milton Keynes, United Kingdom

Tech stack

Systems Engineering

Business Software

Databases

ETL

Data Warehousing

Database Storage Structures

Microsoft SQL Server

Power BI

SQL Databases

SQL Server Reporting Services

SQL Server Integration Services

T-SQL

Data Import/Export

Job description

We are looking for a Report Engineer to join our IT Engineering Team in Milton Keynes. You will help design, develop, support and enhance the use of MS SQL and related reporting solutions across a range of business applications., * 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