Senior SQL Report Specialist

What will you be doing?

You will be writing database queries and developing and managing new and existing scheduled and self-serve reports across a range of WNC/BIPI databases and management information systems to support services. These currently include adults social care, public health, early help and education, and children’s social care, but may expand to include other areas moving forward. 

Working closely with others in the BIPI team, IT, and service areas, you'll support development of new data flow, pipelines, and data models to streamline reporting and enable reporting from new systems. 

You will support the exploration and implementation of new self-service data visualisation and analytical tools, and the potential implementation of a new data warehouse. 

To find out more about our team, watch this short film:

About you

We are looking for someone experienced at working with data, who is proactive, able to manage their own workload effectively, and has a self-reliant approach to problem solving. You will need to have good technical and communication skills. 

Strong technical skills in querying standard databases such as SQL Server, Oracle, and PostgreSQL and using common reporting and data visualisation tools such as SSRS, Power BI, and SAP Business Objects are essential. Skills working with and developing data warehouses/data lakes to integrate data from multiple sources, and development of data models are also important. 

You will need:  

• Experience in technical report design with excellent technical knowledge and skills to be able to interpret report specifications and write technical reports in SQL. 

• Excellent interpersonal and communication skills to build strong working relationships across the organisation to ensure a collaborative approach to Business Intelligence activities, explaining and demonstrating technical changes to systems to stakeholders not of a technical background. 

• Experience in the research, development and support of business requirements, including the design of reports to highlight data errors (Data Quality), inconsistencies and database errors.  

• Experience of sound report writing methodology and good practice (e.g. testing practices and sign off) 

• Experience of data warehouse design and development 

• Experience of planning and managing complex long term data projects 

• Experience of managing a team of professionals within a busy environment

Our benefits

We offer a wide range of benefits to our employees, these include:

• Generous annual leave entitlement starting at 28 days annual leave per year, 29 days for senior managers (pro rata, depending on how many hours per week you work), plus bank holidays. An additional 5 days, linked to continuous service, and ability to purchase up to 6 weeks additional leave per year.
• Cycle to Work scheme. 
• Local Government Pension Scheme plus immediate life cover (3 times your annual salary from day one) and ill-health protection.
• Employee discounts with local and national retailers, days out, finance, health and beauty, travel and eating out plus lots more.
• Car Lease scheme
• Payment of professional subscription / membership - If your job description requires that you are registered with or are a member of a professional body, WNC will pay for your professional subscription or membership fees.
• Employee Assistance Programme - We have an employee support programme run by Health Assured, an independent, external organisation. Health Assured is available for you and your immediate family members, 24 hours a day, 7 days a week, 365 days a year and includes telephone counselling, legal advice, bereavement support and medical information.
• Ongoing training and development opportunities.
• A variety of flexible working options to support your work/life balance, including full or part time, term time, 9-day fortnight, etc. (subject to business needs).
• Our West Ways of Working – We want our workforce to thrive, and we equip our employees with the right technology to support hybrid and collaborative working, on or off site, depending on the role.
• Making a difference - If you want to use your skills and experience with an organisation that are genuinely invested in making a difference, are committed to improving people's lives, and whose success has a direct impact on the wellbeing of your family, friends and people in your local area, then West Northamptonshire Council is the place for you.

About us

We’re a new council, following one of the largest shake-ups in local government reform in recent history. As a new authority, we’re embarking on an exciting journey to deliver exceptional services for our residents, customers and communities.  

Our vision at West Northamptonshire Council is ‘to make West Northants a great place to live, work, visit and thrive’. We truly stand by this and work hard every day to make this a reality. Our corporate values, THRIVE, stand for: Trust, High Performance, Respect, Innovate and Empower, they underpin everything we do and how we deliver services. 

At West Northants Council, it’s about our people. People who thrive with ambition, bubble with new ideas, demand better ways of working, caring about every detail, and who never shy away from a challenge. Our culture is a gateway for new experiences. A place to forge new opportunities. To empower you in your career and unite you with like-minded people.

When potential is unlocked, talent thrives.

Choose a career that offers you a true sense of achievement, fills you with pride and challenges you in a positive way, every day.

West Northants Council, where careers thrive.