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