Ecotricity Home
  • My Ecotricity Jobs
  • Register

Data Engineer - SQL Python

Location:
Stroud
Salary Details:
Competitive + benefits
Advertising End Date:
02 Jan 2019
About The Role

The Data Engineer is responsible for delivery of meaningful data to enable business objectives, continually innovating to make this service better with advancements in technology to the ultimate goal of being an entirely data-led organisation.

Specifically you will design and build real-time data pipelines and microservices using an optimal mixture of Microsoft Azure Cloud and AWS, also building and deploying data processes for the transformation and delivery of data for analytics and data science.

About You

You will have been a competent data developer, data engineer or full stack developer who is comfortable picking up new technologies as and when you need them. You’ll have implemented solutions to data problems which are both creative and elegant, pushing boundaries and disrupting traditional ways of working thanks to advances in technology. You will ideally have worked using cloud environments in an agile manner using open source languages as well as the more traditional ones.  You will be comfortable in solving complex problems, maintaining a high standard for development in a collaborative fashion with data analysts, data scientists, product owners, DBAs and external stakeholders.  We want critical thinkers who are able to confidently challenge assumptions, business cases and approaches if there might be a better option.

What you will do

Responsibilities

  • Design and develop secure data pipelines and integrations using a mixture of SQL, NoSQL and open source languages on RDBMS, Azure and AWS according to what is best suited to the problems at hand.
  • To continually evolve our data platform, optimising the use of micro-services, data lake, SQL/NoSQL, ELT, PaaS data models and open source to continually drive forwards our data capability.
  • Work closely with other software and data engineers using peer-to-peer knowledge sharing for design and development.
  • Interpret the needs of business stakeholders and enable our strategic objectives with data.
  • Responsible to maintain quality of data which informs a single source of truth in respect to information
  • To deliver, wherever possible, a metadata-driven approach to data extraction and transformation - permitting data flow to be transparent to analysts and business stakeholders.
  • Uses agile devops practices.
  • Performance tuning data artefacts as well as fundamental code tuning.
  • Optimize code performance and processing methods.
  • Perform design validation, reconciliation and error handling across the entire ELT process (initial, incremental).
  • Contributes proactively to continual improvement of standards and best practices for code development.

Additional Responsibilities

  • Working closely with the Software Engineering function as well as agile infrastructure teams to benefit the entire organisation

What you will bring

Knowledge, skills and experience:

Programming using data libraries in Python.
Experienced with Microsoft SQL Server Data Tools.
Experience with Apache Spark, Hadoop, EMR, and Hive or another similar map-reduce platform.
Experience developing complex SQL queries, stored procedures and triggers required.
Experience of writing and optimising stored procedures, as well as performance tuning techniques.
Understanding of Kimball Data Warehouse concepts in theory and practice.
Excellent skill at performance tuning scripts.
Success working in a team based environment with good interpersonal skills.
Ability to work productively on your own.
Experience with Agile development practices.
Experience with CI/CD processes and DevOps.

About Us
Ecotricity is the greenest energy company in Britain. In fact, when we started back in 1995, we were the first green electricity company in the world.

Our mission was and remains to change the way energy is made and used – after introducing green electricity to the world, we introduced green gas to Britain in 2010 too.

Our model is unique: we use our customers’ energy bills to fund the building of new sources of green energy. We like to refer to this as turning ‘bills into mills’ – energy bills into energy mills, whether that’s wind, sun, sea or gasmills.

We’ve built over seventy wind and sun parks across Britain, we’re planning to build Britain’s first ever Green Gasmills, and through Britwind, our small wind company, we design, build and deliver small wind turbines to landowners and businesses throughout Britain and the world!

We don’t just focus on energy though – we built and run the Electric Highway, Britain’s leading network of electric car chargepoints, we helped Forest Green Rovers become the greenest football club in the world, and launched Britain’s greenest mobile phone service, Ecotalk.

We’re a not-for-dividend company too – which means we’re free to use the money we make for our mission and our mission alone.

We do all of this with the help of our customers – and the awesome team of people here at Ecotricity. Our people believe in our mission – they’re amazing at what they do, and they make a difference every day they come into work.