Job Vacancy KNOWLEDGE Education Essential Degree and / or professional qualification in an appropriate discipline Evidence of strong commitment to Personal Development Experience Essential Support and development of data analytics or business intelligence solutions. Relevant programming languages e.g. R, SQL, VBA Use of MS Excel with PowerQuery, VBA, and Business Objects Presentation and communication of complex information to a range of service users Proven track record of meeting objectives Provision of customer focused services within a best practice framework Development of policies and procedures Working with others to identify information requirements and developments specifications and reports to meet those needs Desirable Working in a public sector environment Experience of Council systems such as SEEMiS Designing, maintaining, and querying databases Experience with Google Looker Studio. CLOSING DATE - Sunday 11 th May 2025 INTERVIEW DATE - Week commencing 19 th May 2025 Job Advert Position Title: Data Analyst Directorate: Children, Young People & Partnerships Working from Home: Hybrid Location: Fairfield House, Dalkeith Contract Status: Permanent Hours of Work: 36 hours per week Working Pattern: Mon to Friday Weeks per year: 52 Please note that it is Midlothian Councils policy that successful applicants will be appointed to the first point on the salary scale. Based on 36 hours over 52 weeks per year, the minimum actual salary for this position is £41,802.34 per annum. Requirements Compliance with the mandatory Cabinet Office PSN (Public Sector Network) Code of Connection requires the Council to meet a baseline personal security standard. This requires completion of a disclosure check for all employees who can access official information. The fee for this PSN Disclosure check will be met by the council. Additional Information If you have difficulty applying for this post or accessing attached documents, or if you have a disability and reasonable adjustment is required, please call 0131 271 3063 to speak to a member of the Recruitment Team stating the post reference number. Midlothian Council is currently undergoing a period of transformation, changing and improving the way it delivers services in Midlothian. As a consequence, there are a number of existing employees for whom we are committed to seeking suitable alternative employment within the Council in accordance with our legal obligations. Candidates are advised that, for some vacancies, internal candidates in this situation will be interviewed before the wider selection pool and a slightly longer delay may be experienced before application outcomes can be advised to you. Thank you for your patience in this matter. If you are a trainee of a Midlothian Council Training Programme, have a disability or you are a care experienced young person you are eligible for a guaranteed interview if you meet the essential criteria for the post.