BI Developer

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

Desirable

• 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

#LI-Hybrid