Report Engineer
We are looking for an 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
1. Development and maintenance of integrated reporting solutions across a range of business applications
2. Integrity and audit check data for application into reporting solutions
3. Maintain understanding of various business application database structures
4. Support ad-hoc report generation or data extracts via T-SQL queries
5. Act as SQL technical authority to Engineering team with ability to optimise and enhance SQL queries
6. Interpret written functional requirements and technical specification documents and translate into reporting deliveries
7. Investigate and maintain alternative delivery formats (e.g. grouping, drilldown, matrix (pivoted)) to achieve maximum benefit from the underlying data
8. Contribute to improve the overall engineering processes / methodologies followed by the team
9. SSIS package development for reporting imports
10. Report model ownership and updates as requested from key system stakeholders
11. Report development in SSRS
12. Assist as needed with staff training of Report Builder or equivalent self-service reporting solutions in the wider business
13. 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
14. Experience in building reports using Power BI
15. Excellent skills in SQL Server
16. Experience of SSIS data import packages using ETL procedures
17. Experience of producing reports using SSRS
Highly Desirable
18. Experience of undertaking performance reviews and optimisation activities
19. 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