Report Engineer

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.

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 is one of the largest and most successful estate agency and property services providers in the UK and as of March 2021 also encompasses Countrywide. Founded in 1936 and with a network of over 1,250 branches nationwide, the Group combines residential sales and lettings expertise with a range of consumer and corporate services including new homes, mortgage services, conveyancing, EPC provision, surveying, corporate lettings, asset management, land & planning, LPA receivers and auctions.

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.

CF00522