Data Engineer (Cloud)

Methods Analytics is currently recruiting for a Data Engineer (Cloud) to join our team on a permanent basis. This role will require flexibility to travel to client sites, and is expected to be largely remote with occasional travel to our offices based in Sheffield, London or Bristol.

About Methods Analytics:

Methods Analytics exists to improve society by helping people make better decisions with data. Combining passionate people, sector-specific insight and technical excellence to provide our customers an end-to-end data service. We are a specialist data consultancy specialising in supporting the public sector through a collaborative, creative and user centric approach, using data to do good and solve difficult problems.

We value discussion and debate as part of our approach. We will question assumptions, goals and process – but do so with respect and humility. We relish difficult problems, and overcome them with innovation, creativity and technical freedom to help us design optimum solutions. Ethics, privacy and quality are at the heart of our work, we treat data with respect and support our customers in pursuit of these same ends. Our people are positive, dedicated and relentless. Data is a vast topic, but we strive for interactions that are engaging, informative and fun in equal measure but maintain a steely focus on outcomes and delivering quality products for our customers.

Requirements

The Data Engineer (Cloud) will be:

• Working with other members of the delivery team across a mix of large and small projects and be responsible for translating data into valuable insights that inform decisions for small to large transformation projects and programmes.
• Responsible for identifying and using the most appropriate analytical techniques, developing fit-for-purpose, resilient, scalable and future-proof data services that meet user needs and design and write and iterate code from prototype to production-ready.

• Communicating effectively across organisational, technical and political boundaries to understand the context and how to make complex and technical information and language simple and accessible for non-technical audiences.
• Providing, support and mentoring to a team of engineers and helping to grow the skills and knowledge of the delivery team
• Aware of and keep up to date with advances in digital analytics tools and data manipulation products.

Ideal Candidates will demonstrate:

• Extensive experience with Microsoft Azure, specifically Azure Data Factory and Azure SQL.
• Experience with Relational Database and Data Warehousing design
• Experience processing large volumes of structured/semi-structured data (mainly CSV/JSON)
• Knowledge of data cleaning, wrangling, visualization and reporting, with an understanding of the best, most efficient use of associated tools and applications to complete these tasks
• DevSecOps experience, such as using Git, CI/CD and Unit Testing

• Experience with coding or scripting in Python
• Experience in T-SQL development, including debugging & troubleshooting
• An ability to translate business requirements into technical specifications
• Good experience with Analytical/Reporting architecture
• Understanding of how to expose data from systems in order to collect, collate, cleanse, synthesise data (for example, through APIs or flat files) and link data from multiple systems.

• A good understanding of Data Governance principles and the safe handling and processing of Personal Identifiable Data
• Knowledge of how to produce data models and understand where to use different types of data models.
• Ability to promote best practice and continued development across the business

Desirable Skills & Experience:

• Knowledge or and experience in SDLC or a software development background
• Knowledge or and experience of Azure Databricks and/or Synapse
• Experience with containerisation (Docker, Kubernetes, AWS ECS/EKS, Redshift)

Benefits

Methods Analytics is passionate about its people; we want our colleagues to develop the things they are good at and enjoy.

By joining us you can expect

• Autonomy to develop and grow your skills and experience
• Be part of exciting project work that is making a difference in society
• Strong, inspiring and thought-provoking leadership
• A supportive and collaborative environment

As well as this, we offer:

Development access to LinkedIn Learning, a management development programme and training

Wellness 24/7 Confidential employee assistance programme

Social - office parties, pizza Friday and commitment to charitable causes

Time off 25 days a year

Pension Salary Exchange Scheme with 4% employer contribution and 5% employee contribution

Discretionary Company Bonus based on company and individual performance

Life Assurance of 4 times base salary

Private Medical Insurance which is non-contributory (spouse and dependants included)

Worldwide Travel Insurance which is non-contributory (spouse and dependants included)

Benefits Platform offering various retail and leisure discounts