BI Developer

Head Office/Support Centre

BI Developer

Location –
Hybrid 1-2 days a week at our Support Centre in Coleshill.

Become a BI Developer

Reporting into the BI Development Team Lead, you will join a collaborative and supportive team of BI developers where you will get a chance to be involved in the full software development lifecycle with some fantastic projects. You will be comfortable working within a team using an Agile methodology and engaging with your colleagues to better understand and execute projects and BAU tasks. You will have an interest in problem solving, with the ability to diagnose and debug issues, giving concise and clear updates on progress.

You are a strong communicator and collaborator who can work within our development team to deliver high quality reports into production. You will be comfortable using SQL Management Studio, writing T-SQL, utilising SSRS and have a good understanding of data warehousing and best practices surrounding all of these.

You will have a can-do, team driven attitude with a real drive to produce high quality software that we can be proud of as a team. You will have a passion for doing things right, contributing to the already established coding standards, best practice, and process.

Our Culture 

The Works is an awesome place to… well, work! Our atmosphere is supportive, friendly, and inclusive. A second home-from-home where you can be your best and authentic you

Our environment is always moving and full of energy. Yet we still make space to share must-watch TV recommendations and our favourite page-turners. Because even superheroes need some downtime to fuel their imaginations! 

Your Mission

This role is to join the BI development team. As part of the team, you will be responsible for developing and maintaining our reporting suite split across a variety of technologies and techniques. We use a mix of T-SQL extracts, SSRS, DBT, Google BigQuery, Fivetran, Amazon S3 & Looker as a technology stack.  The work is an interesting mix of modernising old reports and developing greenfield reporting solutions. You will contribute to our sprint ceremonies and get involved in the full development lifecycle, developing, testing and deploying high quality reports through our environments into Production, using automated CI/CD pipelines. You will also be involved in maintaining and contributing to standards the team follow.

The key responsibilities are:

High Quality Code - You will take requirements provided by the business to then estimate, design, develop, test and deploy reports to meet the business needs. You will follow coding standards and write SOLID, re-usable code with a very low defect rate. You will contribute to coding standards and contribute ideas to the technology involved in our solutions.

Agile Planning - Contribute through our Agile planning ceremonies of stand ups, backlog refinement, planning and overview sessions. You will estimate work to the best of your ability and give concise updates on progress.

Support Applications - You will be involved in supporting reporting platforms and reports in production, working on priority issues when they arise. There is also an out of hours rotation of support we are responsible for. You will help our wider business with issues that are highly impactful.

Support Your Team - You will be working collaboratively with your team, supporting others when necessary, by giving advice and pair programming on problems.


Skills that will set you apart

  • Proficiency in T-SQL Databases
  • Proficiency in SSRS
  • Experience of SQL and database performance tuning including use of indexes and partitioning
  • Experience working in an Agile methodology
  • Proficiency at writing high quality code
  • Proficiency with Source Control tools such as Git
  • Demonstrable experience adapting to and learning new technologies
  • Excellent communication skills
  • Excellent Troubleshooting Abilities
  • Experience with Data Warehousing
  • Experience with a reporting tool such as PowerBI or Tableau



  • Experience with Performance Testing
  • Experience with DBT
  • Experience with Google Looker
  • Experienced with RedGate tools
  • Experienced with any other database technology
  • Experience with Prefect


Behaviours that will set you apart

  • PASSIONATE – In everything you do – you want to learn, you want to grow and you want to develop the service we offer.
  • STRONG COMMUNICATOR – Able to articulate issues, blockers and test results to an audience of varying levels of technical knowledge
  • HIGHLY ORGANISED – You can prioritise your workload, set expectations and keep your promises.
  • INNOVATIVE THINKING – You are able to “think outside the box” and are always looking for the next opportunity.
  • PROACTIVE - You always look for the next thing to pick up and are willing to help out where you might be needed

Our PERKS really are ‘The Works’

  • 25% Colleague Discount! - Plus, exclusive Double Discount days!
  • MyWorks - Access exclusive online discounts across hundreds of retailers, holidays, utilities deals, tech and more!
  • Holiday –33 days including bank holidays.
  • Holiday Purchase - Purchase an additional 5 days
  • Can-Do Academy - Grow your skills and career with instant access to further training and development in areas that interest you.
  • Wagestream - Claim early access to 50% of your wages as you earn them – for when ‘life’ happens!
  • Share Scheme - Unleash your inner Monopoly mogul and own a piece of The Works!
  • 24/7 support for you and your family - Through our partnership with the Retail Trust who provide an Employee Assistance Programme and so much more!
  • Healthcare Cash Plan – To support your everyday healthcare costs.
  • + Loads more! – Long Service Awards, pension, life assurance, Cycle to Work and optional charity giving.


Our Purpose

To inspire reading. learning, creativity and play - making lives more fulfilled.

Our Values

We are Crafty | We are Caring | We are Can-do


Apply now
  • Viki_People_Story.jpg

    I’m glad I went for the role - I’m loving every minute of it!

    Viki - Operational Trainer

    View more people stories
  • Nathan_People_Story.jpg

    Progression is definitely something that’s achievable here at The Works.

    Nathan - Store Manager & Area Training Manager

    View more people stories
  • Jacob_People_Story.jpg

    It helps a lot to work with people you really get on with.

    Jacob - Assistant Manager

    View more people stories
  • Grace_People_Story.jpg

    There’s lots of on-the-job training and you learn as you go along.

    Grace - Junior Buyer

    View more people stories
  • Dawn_People_Story.jpg

    There’s loads of freedom to use your own creative abilities.

    Dawn - Store Manager

    View more people stories
  • The_Works_Friday_0017_480x480.jpg

    Everyone in the store really made me feel at home.

    Dani - Supervisor

    View more people stories
  • Charli_People_Story.jpg

    It’s fast paced and all about thinking on your feet.

    Charli - Store Manager

    View more people stories
  • Female_colleague_smiling_with_arms_folded.jpg

    Everyone’s really approachable and the environment is very much open.

    Katie - Portfolio Manager

    View more people stories
  • Jevon.jpg

    I enjoy coming to work, and it’s rare to find that.

    Jevon - Customer Services

    View more people stories
  • Chiu.jpg

    "Everyone’s just as passionate about our products as I am."

    Chiu - Quality Assurance Manager

    View more people stories
  • Emily_-_Buying_Assistant.jpg

    What I love most are the people I work with. We just get on so well, we’re just like one big family!

    Emily - Buying Assistant

    View more people stories
  • Dylan_-_Sales_Assistant.jpg

    You do much more than just stand at the till… there’s merchandise, deliveries and opportunities to be really creative.

    Dylan - Sales Assistant

    View more people stories
  • Kayleigh_-_Assistant_Manager.jpg

    When it comes to our products, we all get just as excited about them as our customers do.

    Kayleigh - Assistant Manager

    View more people stories
  • Sam_-_Recruitment__Internal_Comms_Coordinator_.jpg

    Some people say it’s like a second family, but it genuinely is and we all help each other out wherever we can.

    Sam - Recruitment & Internal Comms Coordinator

    View more people stories
  • Kiran_-_Senior_Finance_Business_Partner.jpg

    When I first started at The Works, I realised straight away that everyone here just wants the best for you.

    Kiran - Senior Finance Business Partner

    View more people stories
  • Store_Manager_smiling_with_folded_arms.jpg

    I’ve never worked anywhere like The Works before. It’s fast paced and no two days are ever the same!

    Sharon - Store Manager & Area Training Manager

    View more people stories