Business Intelligence Analyst
- Recruiter
- e.surv Chartered Surveyors
- Location
- Kettering
- Salary
- Competitive
- Posted
- 22 Mar 2017
- Closes
- 30 Mar 2017
- Sectors
- Accountancy
- Contract Type
- Permanent
- Hours
- Full Time
Business Intelligence Analyst e.surv Chartered Surveyors is the country's largest provider of residential valuation services. That means we do more valuations for lenders than any other surveyor in the UK. To put it into numbers we complete one valuation every four minutes. We're part of the LSL Property Services PLC Group of companies, which includes household names Your Move and Reeds Rains, as well as the mortgage broker network First Complete. We work with lenders, intermediaries, social housing entities and estate agents in addition to private customers. ROLE DETAILS To promote e.surv as part of the LSL Group through excellent customer care, and communication, ensuring service turnaround and quality requirements are met on all occasions. To provide an efficient, effective and accurate Management Information to all customers both internal and external and achieve operational excellence in all aspects of activities, processes and procedures undertaken. To undertake additional duties as required by any Team Leader and above and to provide support to all colleagues to ensure the objectives of e.surv are met. In the absence of the Team Leader ensure by co-operation all team tasks are completed. Develop and maintain excellent staff relationships with internal colleagues and external clients, suppliers and customers and present a professional image at all times. RESPONSIBILITIES Design and production of Management Information (MI) reports primarily within the Business Objects BI4.x suite and other tools as required. Design and production of client reporting packs within service level agreements. Production of recurring and one-off adhoc MI for distribution to clients and directors of LSL, often to tight deadlines, using appropriate data validation to ensure accuracy. Management of scheduled reports and servers on a daily basis to ensure resolution of any failures. Conduct daily data integrity checks against operational systems to ensure data received from various sources are complete and correct. Build Extract, Transform & Load (ETL) processes using specialised software such as SAP Data Services and Microsoft SQL Server, adhering to best practice. Create and modify SQL stored procedures and manage and maintain databases, data warehouses and data marts primarily in SQL Server 2008-2014 to ensure efficient reporting and future-proofing. Preparation of semantic layers in the SAP Information Design Tool and maintenance of the same, in addition to maintenance of legacy semantic layers in the Universe Design Tool. Extraction of appropriate data and preparation of geographical heat maps using third party tools such as Geoplan with the data. Identify new reporting opportunities to provide new views of the business above and beyond specific requests from business users. Work with other business areas to ensure business and system changes are accounted for in the MI processes. Adherence to the MI Team's change control and documentation procedures. Ensure company Data Protection policy and security processes are adhered to. To provide support to all colleagues to ensure the objectives of e.surv and LSL Group are met. Promote e.surv in all written and oral communications.