Looking for an exciting and rewarding career?

theidol.com is looking for an ETL Developer (Extract, Transform, Load) to manage the ETL process within the organisation and implement technical solutions to support those processes.

The Idol is an award-winning, rapidly growing tech company based on the edge of the Lake District National Park in Cumbria. It’s the ideal setting to get out, enjoy a walk, be inspired, and conceive our next innovative product or solution. We’ve been leading online innovation since 1999 and specialise in creating cutting-edge web applications and solutions for customers and businesses of all sizes.

We are part of the Legal & General Group and partner with household brands such as Go.Compare and ComparetheMarket. We pride ourselves on innovation and early adoption of new technologies and working practices.

Apply Now

If you feel you have the skills and experience required to join the team at theidol.com, please send us your CV, contact details and a short statement about you and your suitability for the role.

Apply
Job purpose

Reporting to a Solution Architect, the ETL Developer will work closely with our Business Intelligence, Data Management and Development teams in support of our regulated insurance products markets (customers looking for Travel, Pet, Annuities, Life and Death in Service insurance). The role has a focus on data, data storage architecture, extraction, formatting, and displaying data to end users, and is responsible for managing the ETL process and implementing technical solutions to support those.

Principle accountabilities
  • Transferring data between transactional and warehouse solutions.
  • Documenting, diagramming, and visualising data objects, their relationships, systems, and processes.
  • Consulting with data management teams, stakeholders, architects, developers, and Heads of Department to gather requirements and solution knowledge.
  • Conducting data modelling, representing the relationship between various data objects.
  • Testing the performance of the designed solutions and data before and after extraction and load.
  • Presenting data visualisation dashboards and tooling to stakeholders based upon carefully considered functional and non-functional requirements.
  • Creating and maintaining data pipelines to securely transfer data within and outside the organisation.
  • Identifying weaknesses and troubleshooting any issues with the developed solution, transfer mechanism, warehouse, and data integrity.
  • Supporting the loading of data into BI Dashboard environment and supporting the creation and maintenance of dashboards.
  • Being aware of emerging new technologies, identifying potential use cases and championing a data-driven approach to developing solutions.
  • Consider, relevant to your role, the needs and objectives of all our customers, including vulnerable customers, to ensure that they receive good outcomes.
Person specification

Knowledge, experience and qualifications

  • Knowledge of development languages such as JavaScript, Python and Go, and common data definition structures such as JSON and XML.
  • Experience with Kafka and knowledge of data visualisation best practices.
  • Extensive knowledge of data manipulation languages and frameworks such as SQL, across multiple platforms.
  • Experience applying best practices in design and software patterns, ensuring solutions are clear, maintainable, and understood by the whole team.
  • Some experience as an ETL developer or other data focussed development role preferred.
  • Understanding of data security best practices.
  • Experience, or at least a very solid understanding, of agile operations.

Behaviours

  • Diagnosing stakeholder requirements and translating these into well-designed solutions based on the needs of customers in the relevant target markets.
  • Influencing conversations with colleagues and stakeholders to ensure best practice solutions are designed that help customers make timely and informed decisions.
  • Providing verbal and written communication that is clear and concise to colleagues, senior management as well as stakeholders.
  • Being prepared to be challenged as well as take the initiative.
  • Flexible and adaptable – capable of changing direction where required, showing flexibility to meet new demands and quickly leaning and mastering new and existing technologies.
  • Self-managing own workload and continually meeting agreed deadlines and delivery targets.
  • Multi-tasking – managing several concurrent projects and prioritising demands.
  • Being approachable and friendly, and contributing to a positive and active working environment.
  • Demonstrating self-driven learning (although training will be provided where needed).

Scope
  • This is a full-time Monday to Friday role working an average 37.5 hours per week.
  • Flexible home/office working supported. There is a requirement to attend the office in Cumbria approximately twice a month or as frequently as is required to meet the role requirements (expenses will be provided depending on your location).
  • Salary in the range of £30,000 - £55,000 depending on experience, 25 days holiday plus public holidays, plus performance rated bonus, enhanced pension, and generous private medical, insurance, family and sickness benefits, and share schemes.
  • A full role profile can be downloaded - here

Over to You

If you have a genuine enthusiasm and an ability to quickly adapt to new technologies, you may be just what we’re looking for!

Apply here...

Please enter a name
Please enter a valid email address
Please use Word or PDF format
Please upload your CV
The privacy notice describes how we collect and use personal information about you when you apply for a job at theidol.com, in accordance with our obligations under data protection legislation. By pressing submit you agree that you have read and understood the privacy notice for applications for jobs.

What’s in it for you?

Your Money

Taking care of your financial wellbeing, and making your money go further.

letter I shape

Performance bonus

Annual bonus based on individual performance.

letter D shape

Yearly pay increases

We review your salary annually, to make sure we’re paying you fairly.

letter O shape

Pension scheme

Up to 10% employer pension contribution.

letter L shape

Share scheme

Access to our Legal & General share schemes.

Your Health

Taking care of your physical and mental wellbeing.

letter O shape

Work life balance

Hybrid home or office working to help strike the perfect balance for you, while supporting your expenses to visit the office.

Health and Dental Insurance

Access to private medical plans for you and your family.

Employee Assistance Programme

Free, day-to-day wellbeing and counselling service.

Virtual GP

Fast and direct access to a Virtual GP and Mental Health service.

Tailored office environment

Life at Team Idol.

Social events

Exceptional events delivered by our social committee team.

Breakout rooms

Spacious meeting rooms and breakout areas.

Drinks and snacks

Complimentary hot and soft drinks, free fruit and a lunch allowance while at the office.

Free parking and charging

Access to electric charging points and no need to worry about parking charges!

Your life

Protecting you and your family.

letter O shape

Death in service insurance

Insurance to protect you and your family at 8 times your salary.

Holidays

Generous holiday allowance and the ability to buy and sell holidays according to your needs.

Work+Family Space

Access to advice, guidance, resources to balance work and caring responsibilities.

Income protection

Support if you are unable to work in the long-term due to illness or injury.

The Idol office

Where we are


Based in Eden Business Park, our modern office space reflects our culture and how we want to work. Step outside and you’re instantly looking out onto the Thacka Beck Nature Reserve.

We love where we live and we’re proud to remain a homegrown Cumbrian technology business. This pride extends to embracing our role in the community to champion, inspire and develop digital skills.

What to expect


We create a rewarding working environment for our teams to develop, collaborate and enjoy. Expect high energy, creative flair, attention to detail and an embraced adoption of new technologies.

Working in agile development squads, our teams freely exchange ideas and expert knowledge - sharing this both with each other and our clients. This approach encourages for continuous improvement, ensuring the projects we deliver are as truly considered and innovative as possible.

designer workingchatting over lunch
pool table in the officeperson working on computer

Find your balance


Adopting a healthy work life balance is an essential part of our culture. We offer flexible working hours, remote or blended home/office working, as well as funded social events.

Our modern, custom-built office is the perfect working environment for our teams, with spacious social working areas, free hot/cold drinks and fresh fruit. Facilities include an on-site gym, showers and table tennis.

table tennis in the officecycling in to the office

Challenge yourself

Continuous professional development is more to us than ticking a box. It underpins our approach and belief in the value of personal and professional growth.

Training is accessible to everyone in all roles and across all levels, enabling you to develop and deliver your best work with us.

Working with you, we’ll identify and build a tailored development plan. Training opportunities include short courses and bootcamps, through to apprenticeships and industry-recognised qualifications.

customer services on the phonediscussing work

You’re in good company


It’s important, dare we say essential, to enjoy what we do and have fun at work. Our staff-led social events team organises exceptional social events, including Christmas parties, axe-throwing, cheese and wine evenings, bake off events and even trips to the Crystal Maze!

Our annual summer party brings everyone together in the heart of the Lake District for an evening of live music, free food and drink.