BI Developer

Purpose of the role

The Business Intelligence team at Sykes Cottages is responsible for turning our business data into meaningful, accurate and useful information to help the business make sound commercial decisions and plan accurately.

Due to the continued expansion and success of the business, we are recruiting for an additional developer to join our busy – but friendly and close-knit – team who possess a wide range of skills and experience between them.

The ideal candidate will be someone with significant experience as a Business Intelligence developer using the Microsoft BI Stack with particular expertise in complex ETL. In addition to this the successful applicant will be someone who relishes a challenge, shows enthusiasm and has a passion for data.


Essential Experience

=        Microsoft BI Stack specialist

=        Expert level t-SQL and SSIS

=        Strong general SQL server knowledge

=        Strong data analysis skills

=        Performance tuning of t-SQL and SSIS.

=        At least 3 years SQL Server data warehousing development experience.

=        Solid understanding of data warehouse design principles including Kimball, ODS and Staging.


Desirable Experience

=        Experience working Large volumes of data (Billions of row tables)

=        Experience working with Snapshot grain / Semi Additive data

=        Working with data visualisation tools

=        Experience with AWS

=        SSAS skills

=        Experience in a busy e-commerce environment


Core Accountabilities

The BI Developer will be responsible for working with the BI team to help the business to achieve its strategic goals. This will include managing business data and building reporting tools to help to meet business requirements.


Key accountabilities will include:

=        Working with colleagues across the business to scope and define new business requirements, assisting and guiding with technical specifications where required

=        Delivering enhancements to business critical business intelligence solutions

=        Producing and maintaining key business reports

=        Producing high quality data warehouse solutions using appropriate technologies

=        Working with the BI team to deliver projects on time, to a high specification

=        Sharing and promoting

=        Any other duties as are within the scope, spirit and purpose of the job as requested by your line manager.


Note: This Role Profile reflects the present requirements of the post. As duties and responsibilities change and develop the role profile will be reviewed and be subject to amendment in consultation with the post-holder.


Role/Department/Specific Responsibilities

=        Attend departmental meetings and represent the department at internal and external meetings.

=        Recommend changes to systems and procedures to improve the efficiency of the site operations. Continually review operational practices to ensure best practice is delivered at all times.

=        Work in accordance with the Data Protection Act (1998) and to ensure all new systems and data are secure.


About Us

Sykes is one of the UK's leading independent holiday cottage rental providers. By 2020, we're aiming to be Number One in the UK. It's an ambitious goal, but that hasn't stopped us succeeding before. Our success has been recognised both within and beyond our industry - we've won a prestigious "Best in Industry" award at the British Travel Awards for the last five years, and have been recognised by the London Stock Exchange Group as one of the "1,000 companies to inspire Europe". We're a fast-paced, exciting company to work for, but haven't forgotten our roots from Sykes' founding days at a kitchen table. 

Although we work hard, we also believe in rewarding that hard work. In addition to salaries, we offer a generous benefits package including:


=        33 days’ holiday (including bank holidays)

=        An additional day off during the week of your Birthday

=        Annual bonus scheme

=        Staff pension

=        Private Medical

=        Death in Service payment

=        Subsidised park and ride passes

=        Enhanced Maternity and Paternity pay

=        Long service awards - cash payments and increases in holiday allowances

=        Staff discount on cottage holidays

=        Free worldwide travel insurance (including family members)

=        Wellness extras, including free annual flu jabs, reflexology sessions and free fruit supplied in the office


Working hours will be Monday - Friday, 9am - 5:30pm