Senior ICT Engineer/Designer (Data Management)

International Sponsorship – this role is not open to international sponsorship 

|Salary £43,421 - £48,474 per annum | Permanent | Full Time, 37 hours per week | Hybrid working, with a base at County Hall, Preston |   

Pay Award Pending

We have a new opportunity for a Senior ICT Engineer/Designer in our Data Management Team 

About the Team:

Lancashire County Council's in-house Digital Services team have a vacancy for an ICT Engineer/Designer to continue their career in a dynamic, innovative department with over 450 staff within its data management team.   

This vacancy will utilise your skills and experience enabling you to support the transformation of our Digital Services and add real value to the Council and its citizens.  

About the Role:

This role will give you opportunities for: 

• Influencing the business to align with the digital data strategy, enabling LCC to become a digital first organisation 
• Designing, building, and deploying efficient, scalable, automated ETL/ELT pipelines 
• Developing Azure Synapse pipelines which load data into Azure Data Lake/warehouse  
• Creating dimensional data models enabling toolset like Power BI to take full advantage of created data assets 
• Supporting development work, ranging from conducting data reviews to capturing data stories, helping customers make sense of their business data. 
• Liaising, advising, and negotiating with key stakeholders on requirements and proposing innovative solutions that meet their needs 

About you:

We are looking for an enthusiastic team player who is eager to demonstrate and use their expertise in data management, problem-solving and communication to play a vital part in the delivery of a data management capability, while at the same time developing the skills of the less experienced members of the team.

You will have detailed knowledge of Microsoft Azure cloud platform.  

Over and above, you will have experience of:   

• SQL Server (SQL Server Management studio) 
• Visual Studio   
• Microsoft Azure data fundamentals including, Azure Data Lake, Azure Synapse and Azure SQL 
• Experience working in an Agile environment (ideally utilising Azure DevOps) 

This role is for candidates who would like to create, grow, and deliver innovative solutions at pace helping LCC transform into a data-driven organisation.  

Why join us… 

Benefits: there's fabulous flexibility and the opportunity to create the work life balance you'll love with up to 31 days annual leave plus bank holidays, 2 additional days at Christmas and then an additional 20 days that can also be purchased.  We have a relocation allowance available for this role so up to £8,258, plus a generous local government pension with shared cost AVCs available. In addition, we then also have a benefits package which has everything from dog care to day care, holidays at home or abroad, long service awards, Medicash, support groups, cycle to work schemes and eye tests plus much more.  Further details are available on the LCC Vacancies website. 

Development: you'll get support and development along the journey – there will be time for supportive reflection and supervision for yourself, opportunities for personal growth and development, professional qualifications, multidisciplinary initiatives, mentoring, the opportunity to make a difference, feel valued and achieve the job satisfaction you've always wanted 

Inclusivity: we don't have a "one size fits all" idealism, we embrace diversity and that includes around personal and family requirements so appreciate that you'll want to be working from home when you can, your hours may vary or change and for us – delivering successful outcomes is more important than watching the clock 

Flexibility: this is a hybrid role that involves a blend of both remote and on-site working. We believe this approach allows for flexibility while maintaining the collaborative and interactive aspects that are integral to our team's success. It is essential to note that while remote work will be a part of this role, there is an expectation that you will be required to attend our office on a regular basis. We therefore expect candidates to reside within a commutable distance from our County Hall offices in Preston, Lancashire. 

Further information:

For an initial informal and confidential chat please contact Vishal Mistry, Tel 01772 532672 

Please note that applications cannot be accepted via email and should be submitted online via the LCC Vacancies website. 

How To Apply:

View the Job Description and Person Specification for details of the role.   

Please ensure you have uploaded and attached your supporting statement to evidence how you meet the criteria for the role.  The panel may be unable to shortlist you for interview without this evidence. 

Closing date for applications: 26 May 2024

In return Lancashire County Council offers a range of benefits, which can be found on LCC Vacancies website.

We reserve the right to close down a vacancy early, before the closing date, if we receive sufficient applications. 

Job Description and Person Specification