We are looking for a Report Engineer to join our Group Technology 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.
We offer a hybrid working arrangement with 1 or 2 days per week in our Milton Keynes office.
Key Responsibilities
* 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 and skills required:
Essential
* 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
Highly Desirable
* Experience of undertaking performance reviews and optimisation activities
* Experience in data warehousing and cubes
Connells Group UK is an equal opportunities employer and positively encourages applications from suitably qualified and eligible candidates regardless of sex, race, disability, age, sexual orientation, transgender status, religion or belief, marital status, or pregnancy and maternity.