Data Analyst - SQL/Housing Software

Job Description
Are you an experience data professional with experience across data analysis & insight, data management, and data cleansing? Do you have strong Excel skills and a background working with Social Housing &/or Property Asset Management data? If this describes you, then let Informed Recruitment help you achieve your potential with an exciting opportunity as a Data Analyst, providing you with opportunity to make a real difference. As a specialist provider of IT resource to the Housing & Property Technology markets, we are partnering with a Social Enterprise undertaking an exciting expansion and looking to bolster their services to customers and offering you the opportunity to work on some exciting projects as well as BAU.
The objective of the role will be to act as a data steward for a company and ensure that the organisation can be reliably informed by their data. Your day-to-day activities will cover a breadth of tasks from reviewing data and providing report, insight, and analysis, undertaking market research, identifying opportunities where data suggests and all associated documentation. You will also compline and maintain a Data Register, deliver performance monitoring, benchmarking, and analysis; compile all statutory reporting returns such as Housemark or NROSH; develop reports & dashboards; act as a data liaison for all system implementations & upgrades; and facilitate data literacy across the organization.
Must Have

• A commercial track record in data, information or performance analysis and an understanding of the principles of data management, data manipulations, and data cleansing.
• Experience working with Social Housing &/or Property Asset Management data sets.
• At least a basic understanding of SQL scripts, and the desire to learn and become more advanced.
• MS Excel skills to VLOOKUP, XLOOKUP & Pivot chart/table capability
• Identification of data errors through exception reporting and subsequent data cleansing.
• Experience working with data from multiple sources.

Nice to have / Will Strengthen Application

• Free hand SQL scripting to interrogate data sets.
• Advanced MS Excel skills including Power Pivot Tables, DAX, VBA, and/or macros.
• Business Intelligence tools - Power BI, SSRS, or MS Report Writer.

• Experience working with data sets from social housing and / or with social housing management or property asset management systems (Such as Civica Cx, NEC Housing, MRI/Orchard, Aareon QL, Capita One/OPENHousing, MIS ActiveH, or similar.)

As an individual you will be an excellent communicator, adept at liaising at all levels with a variety of stakeholders. You will also be highly analytical with a keen eye for problem solving, excellent presentation skills, and meticulous record keeping. This role is home based, outside of IR35, and an exciting time to join the organisation embraking on flagship projects. Interview slots are available, so please apply without delay.