Job info	Job info details
Job title	Report Writer
Strategic team/Directorate	Children’s Services
Service	Learning and Partnership Hubs
Business unit	Quality Assurance
Responsible to (day to day issues)	Service Manager Business Intelligence
Accountable to (line manager)	Service Manager Business Intelligence
Salary grade	K
JE ref	CS69

1. Key purpose of job

• To lead on the creation and management of the Children’s Services Power BI and analytical solutions in order to turn data into knowledge.
• To be responsible for translating the day-to-day business needs of Children’s Services into technical specifications using Power BI and other systems.
• To work with Departments and the Business to identify Key Performance Indicators (KPIs), develop business rules and business analytics, create reports and dashboard, as well as other delivery methods.
• To be responsible for the conversion of raw data into meaningful insights through interactive and easy-to-understand dashboards and reports that meet the needs of all levels of the Service. 
• To be responsible for the development and administration of Power BI tools along with complete knowledge of the Power BI system.

2. Anticipated outcomes of post

• Continuing on the data improvement journey and troubleshooting/problem solving to ensure the stability of the information and data systems. 
• Delivering high quality outcomes data which is reliable, well presented, and accessible. 
• Ensuring Torbay Council have appropriate systems in place to record all necessary data and knowledge of cutting-edge systems technology. 

3. List key duties and accountabilities of the post

• As an Employee of Torbay Council all roles are expected to work in a way that ensures vulnerable children and adults are safeguarded and report any safeguarding concerns in accordance with established policies and procedures. The Designated Senior Lead for Safeguarding is the Chief Executive and Director of Children’s Services.
• To create complex reports using multiple tools such as SQL Server Reporting Services and Power BI for internal and external use.
• Decides which and writes scripts (in SQL Server using T-SQL) to extract the required data from the data warehouse, checking the accuracy of the data and releasing it as a report.
• Identifying and correcting errors in data, reporting and scripting.
• To be responsible for gathering and documenting functional and technical report requirements and for translating those requirements into reporting solutions. 
• To work with colleagues at all levels of the service, including business leaders at a strategic level and service users to understand the business reporting requirements and recommends suitable reporting solutions where necessary.
• To be responsible for the development of in-depth understanding of underlying data, data structures, and business uses to ensure any reports, dashboards etc. meet the needs of the service.
• To be responsible under the direction of the Service Manager Business Intelligence for the data warehouse development and work with SSAS, SSIS, and SSRS.
• To create test cases and work with the Quality Assurance Team through the Torbay Learning Academy to ensure accurate and complete testing.
• To create technical documentation of report logic and processes.
• To work with other Analysts from with the Service and across the Council to understand code changes that will impact reports.
• To guide other IT resources in coding and report writing best practices where necessary.
• To support the end-user community in the use of business intelligence tools to query databases and files for report outputs.
• To work within and across functional and technical teams across both the service and Council to support the acquisition of new skills and areas of expertise.
• To develop and assist with report training through the development of training tools and training of key staff.
• To be responsible for the management of multiple, simultaneous projects, often with competing priorities.
• To communicate and collaborate with team members, customers, and vendors from across both the service and Council as necessary.
• To be responsible for the handling of sensitive and confidential information in line with GDPR.

4. Budgetary/Financial Responsibilities of the post

• None. 

5. Supervision/Line Management Responsibilities of the post

• None. 

6. Working environment and conditions of the post

• Normal working conditions.

7. Physical demands of the post

• Normal physical effort. 

8. Specific resources used by the post

• Normal office and agile working equipment. 

9. Key contacts and relationships

• External - Software Providers, Partnership Bodies where Children Services is represented, Government Departments and Agencies including Department for Education, Department for Levelling Up, Housing and Communities, Ofsted, Youth Justice Board for England and Wales and HM Inspectorate of Probation.  Voluntary and Community Sector Across Torbay. Service Users.
• Internal - Staff at all levels within Torbay Council including the Children’s Services Senior Leadership Team.

10. Other duties

• To undertake additional duties as required, commensurate with the level of the job.

Other Information

• All staff must commit to the Workplace Equality, Diversity and Inclusion Practice and Policy.
• Torbay Council is committed to safeguarding and promoting the welfare of children and applicants must be willing to undergo the checks appropriate to the post applied for.
• The post holder is expected to work in a way that ensures vulnerable children and adults are safeguarded and report any safeguarding concerns in accordance with established policies and procedures. And are aware that the Chief Executive and the Director for Children’s Services are the Safeguarding Leads for the Council.
• This post is office based at Town Hall, Castle Circus, Torquay, TQ1 3DR but the post holder may be required to move their base to any other location within the Council at a future date.
• The post is eligible for hybrid working.
• You will be asked to complete a Criminal Records Self Declaration Form. Criminal convictions will only be taken into account when they are relevant to the post. You will only be asked to disclose ‘unspent’ convictions.
• The Council operates a Smoke-Free Policy and the post-holder is prohibited from smoking in any of the Council's buildings (including Council owned and Council leased buildings, but excluding designated areas in residential schemes), enclosed spaces within the curtilage of buildings, and Council vehicles. The Council does not permit smoking breaks within work time, however, in services where the flexi-scheme is in operation, employees may take reasonable break times outside of core hours, in accordance with flexi-time arrangements. Employees should follow the flexi-scheme procedure for agreeing time away from their duties in the normal manner with their immediate colleagues and line manager, with break start and finish times being recorded, as with any other break-time arrangement. 
• The post-holder is expected to familiarise themselves with and adhere to all relevant Council Policies and Procedures.
• The post-holder must comply with the Council’s Health and Safety requirements as outlined in the H&S policy appropriate to the role.
• The post-holder must be committed to the Council’s Core Values for employees – “Torbay Council employees are committed to being forward thinking, people orientated and adaptable - always with integrity”. Evidence will be sought during the probation and appraisal processes.
• If this post is customer facing, it will require the ability to fulfil all spoken aspects of the role with confidence and fluency in English.
• If you are required to access a government system such as HMRC, DWP or The Public services network (PSN) as part of your role with the Council you will be required to complete a basic disclose with your line manager before you can access these systems. Your manager will be required to complete a verification form that confirms your identity, nationality and immigration status, employment history and unspent convictions (third party).
• If you are required to use your own vehicle on Council business or drive a council vehicle you will be asked to provide information on any driving endorsements by accessing gov.uk/view-driving-licence and providing a code to your Line Manager in order to share your driving licence information with the Council.

Person Specification

Note for Candidate

All Candidates

The supporting statement on your application form will be used to assess ability to meet the essential requirements of the role, so you should explain how you meet each of the numbered essential requirements within your supporting statement. In a competitive situation, the desirable criteria may be taken into consideration, so you are encouraged to show how you also meet each of the desirable criteria.

Candidates who consider that they have a disability

Reasonable adjustments will be made to the job, job requirements or recruitment process for candidates with a disability.

If you consider yourself to have a disability you should indicate this on your application form, providing any information you would like us to take into account with regard to your disability in order to offer a fair selection interview.

Where ever possible and reasonable we will make adjustments and offer alternatives to help you through the application and selection process.

If you have indicated that you have a disability on your application form you will be guaranteed an interview if you clearly demonstrate in your supporting evidence how you broadly meet the essential requirements of the role.

Job info	Job info details
Job Title	Report Writer
Strategic team/Directorate	Children’s Services
Service	Learning and Partnership Hubs
Business unit	Quality Assurance

Skills and effectiveness

Essential skills and effectiveness

• Excellent communication, presentation and written skills should be comfortable with people as well as technology.
• Demonstrable use of system application skills that include programming logic, system analysis, system testing, documentation, troubleshooting, and user support.
• Ability to communicate business needs to technical staff as well as understand customer requirements and design user-friendly reports.
• Ability to work independently, problem solve and find creative solutions escalate issues and seek guidance as necessary.
• Able to work effectively at all levels of the organisation with ability to convey a correct sense of urgency based on customer or business impact.
• Report writing and data modelling. 
• Understanding algorithms and mathematics. 
• Ability to sort through complex issues and conduct comparative analysis of multiple solutions.
• Ability to manage complex and conflicting demands with changing timescales, including managing demands of direct reports.
• Excellent organisational and multi-tasking skills – i.e., prioritises and performs a variety of concurrent tasks with efficiency and minimal direction.
• Ability to demonstrate integrity, business ethics, and to be trusted with confidential information.
• Detail oriented. 
• This role requires the ability to fulfil all spoken aspects of the role with confidence and fluency in English.

Desirable skills and effectiveness

N/A

Knowledge

Essential knowledge

• Demonstrated knowledge of Microsoft SQL Reporting and Analysis Services.
• Demonstrated knowledge of Power BI.
• Knowledge of Oracle PL SQL and Tableau. 
• Knowledge of Oracle SaaS / Oracle Fusion data models and subject areas within Oracle’s Transactional Business Intelligence reporting solution.
• Knowledge of LCS (Liquid Logic). 
• Solid understanding of Data Protection/GDPR requirements. 

Desirable knowledge

• Knowledge of Children’s Services reporting needs and structure.
• Knowledge of statutory reporting requirements. 

Experience and achievements

Essential experience and achievements

• Implementation of new systems within a local authority service.
• Data warehouse management.
• Experience of Oracle PL/SQL, MSSQL and SQL Server Management Studio. 
• Significant postgraduate business experience.
• Significant postgraduate experience of direct client interaction and customer-service. 
• Experience in the creation of charts and data documentation including the explanation of algorithms, parameters, models, and relations. 

Desirable experience and achievements

• Performing DAX queries and functions in Power BI. 

Qualifications/professional memberships

Essential qualifications/professional memberships

• Relevant degree such as business or computer management or significant demonstrable experience. 

Desirable qualifications/professional memberships

• Prince 2 – Project Management. 

Other requirements

Other requirements of the job role

• Demonstrates a commitment to safeguard and promote the welfare of children and young people. 
• Ability to travel efficiently around the Bay/South West/UK in order to carry out duties. 
• Ability to accommodate unsociable hours when necessary. 
• Ability to accommodate occasional home-working.