Senior ETL Developer

Plusnet PLC
30 Nov 2017
08 Dec 2017
Contract Type
Full Time
About the job

This is a great opportunity for a self-starter who is looking to develop their career and that of others. You will have the opportunity to contribute to shaping plans and the overall direction of the team, by taking ownership of MI project development including designing the overall data solution.

The Data Warehouse is a MySQL/Linux based Data Store with data coming from a variety of sources including but not exclusively MySQL based.

“IDC forecasts that by 2025 the global datasphere will grow to 163 zettabytes (that is a trillion gigabytes) that’s ten times the 16.1ZB of data generated in 2016. All this data will unlock unique user experiences and a new world of business opportunities.”

You will be glad to know that at PlusNet we don’t have that much data! But the opportunities for the business and an improved customer experience is the same. The Data Platform team is at the heart of those opportunities. As a Senior ETL Developer within the Data Platform team you will be part of the process of extracting, transforming, consolidating the complex available datasets from a wide variety of sources into useable data sources within the data warehouse that the wider business can use to drive performance and improve productivity. Essential to this is being a team player, who is proactive in developing others.

Is it easy? – No

Is it rewarding? – That depends on you.

Do you have the drive to be responsible for the development and maintenance of the Data Warehouse ensuring that not only your work but also that of other team members is delivered from a technical perspective, and assisting in developing the toolset to encompass the needs of the business moving forward?

Do you have the enthusiasm to utilise information from various data sources to produce management information, work with complex databases to provide recommendations as to the best information, and interpret stakeholder requirements?

As a Senior Data Platform Developer you will...

·Be responsible for management of data infrastructure projects from start to finish; providing relevant plans, documentation and communication

·Be required to attend meetings with Senior Stakeholders independently and act as a representative for data platform team

·Code in SQL and approved scripting languages to the published development guidelines and coding standards

·Peer review code to ensure that it follows the team development guidelines and conforms to the coding standards

·Peer review documentation to ensure that sufficient information is available to enable problem resolution and provide on-going support

·Ensure consistency of output so that all live reporting maintains the “one version of the truth”

·Produce detailed specification documentation that can be used by business stakeholders to verify that their requirements will be met and by peers to provide accurate estimates of work required

·Design solutions for reporting output based on the requirements laid out in a specification

·Provide input in the design of project sized pieces of work

·Provide feedback to stakeholders and line management during all phases of work to a level that ensures progress can be monitored effectively

·Document all work to a standard that provides peers with sufficient information to review it effectively and provide on-going support

·Prepare for and attend regular 1 to 1 meetings with line management

·Prepare materials for and deliver training to end users to support and enable effective use of all reporting

·Deliver timely and accurate solutions for approved ad hoc requests

·Log time spent working via approved mechanisms to enable effective reporting and management

·Provide accurate estimates of work to fulfil requirements in response to specification and design documentation, logged via approved mechanisms

In order to apply your experience should look like…

Technical Skills

·Very Strong experience of database development

·Very Strong experience of SQL and stored procedures

·Experience of ETL processes, multi-dimensional modelling and data warehouse design

·Experience of MySQL

·Knowledge of relational database design and query tuning

·Knowledge of Linux operating systems and shell scripting (bash)

Personal skills

·Ability to work as part of a team and help others develop is essential

·Excellent written, presentation and oral communication skills

·Strong data manipulation/transformation skills

·Solid analytical skills

·Good commercial awareness

·Ability to interpret raw data

·Some experience of statistical modelling

·Strong cross-functional thinking, able to grasp business priorities

·Reliable, well-organised, accurate, results-oriented

·Strong organisational skills, able to work under time pressure

About Plusnet

Plusnet is a Yorkshire based ISP with a unique brand identity. It’s a fast paced environment yet our offices have a distinctly friendly and informal feel to them - we know that you can do great business without the suits. We believe in making a difference, team work and putting the customer first in everything that we do. It’s an approach that’s allowed us to keep delivering award winning products and services for nearly 20 years!

Whatever your career ambitions, Plusnet is committed to giving you the skills and support that you need in order to achieve your goals; whether it’s training and development or just a breather over a game of table tennis or pool!

Of course there’s lots of other reasons to work at Plusnet; we’ll support you through a wide range of “Plusnetter” perks including free staff broadband & phone packages, pension, bonus & shares scheme and numerous discounts on items such as cinema tickets, mobile tariffs, city parking, gym memberships and much more!

So, if you’re looking to think creatively, challenge yourself and make the decisions that matter - we’d love to hear from you!

This job was originally posted as