Senior Data Engineer (Azure Data Factory)
United Kingdom - Remote
Applications have closed
Methods
Delivering end-to-end business & technical solutions that are people-centred, safe, & designed for the futureMethods Analytics is currently recruiting for a Senior Data Engineer to join our teamon a permanent basis. This role will be mainly remote, but will require flexibility to travel to client sites, and our officesbased in Sheffield, Bristol and London at least once a month.
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 use a collaborative, creative and user centric approach data to do good and solve difficult problems. We ensure that our outputs are transparent, robust and transformative.
We value discussion and debate as part of our approach. We will question assumptions, ambition 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 and we will not sacrifice these for outcomes. We treat data with respect and use it only for the right purpose. 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
Ideal Candidates will demonstrate:
- Extensive experience in designing and delivering data pipelines.
- Have experience leading or mentoring a team of data engineers.
- At least one recent year of experience designing and building Azure Data Factory data flows.
- At least one recent year of experience ingesting data into an Azure Data Lake.
- At least one recent year designing data models for large datasets, including creating dimensional models as outputs for ingested data.
- Understanding of the purpose of Data Catalogues.
- Strong T-SQL Development including debugging & troubleshooting.
- Solid Relational Database design skills with an eye for performance optimisation.
- an ability to translate business requirements into technical specifications.
- Attention to detail and ability to QA own and other team member's work.
The Senior Data Engineer 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.
- Working with other members of the delivery team you will be 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.
- Working with the Lead Data Engineer to support the growth and development of the team.
- Aware of and keep up to date with advances in digital analytics tools and data manipulation products.
- Collecting, collating, cleansing, synthesising and interpreting data to derive meaningful and actionable insights.
- Understanding of how to expose data from systems (for example, through APIs), link data from multiple systems and deliver streaming services.
- Producing data models and understand where to use different types of data models.
- Provide training, support and mentoring to a team of Data Engineers and helping to grow the Engineering team.
- Ensuring that risks associated with deployment are adequately understood and documented.
Other Desirable Skills & Experience:
- Experience in SQL Server Integration Services (SSIS).
- Good experience with ETL
- SSIS, SSRS, T-SQL (On-prem/Cloud),
- Experience with NoSQL type environments, Data Lakes, Lake-Houses (Cassandra, MongoDB or Neptune).
- Have experience with Python.
- Have cloud based configuration experience, preferably with Azure.
- Knowledge of statistics principles necessary to interpret data and apply models. For example, knowledge of errors and confidence intervals to understand whether a relation seen in the data is real.
- Exposure to high performing, low latency or large volume data systems (i.e. 0.5 billion+ records, terabyte size database).
- Working within a continuous integration environment with automated builds, deployment and unit testing.
- Exposure to iterative/agile development methodologies such as SCRUM.
- Experience of working in a consultancy.
- Experience working in Government departments or agencies.
- With sector knowledge such as Central or local government, Defence, Healthcare, Police, etc.
- With data format / type experience such as NHS Data sources such as HES, SUS PbR, HL7.
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
Flexible Working – including home working and part time
Social – office parties, breakfast Tuesdays, monthly pizza Thursdays, Thirsty Thursdays, and commitment to charitable causes
Time Off – 25 days of annual leave a year, plus bank holidays, with the option to buy 5 extra days each year
Volunteering – 2 paid days per year to volunteer in our local communities or within a charity organisation
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)
Enhanced Maternity and Paternity Pay
Travel – season ticket loan, cycle to work scheme
For a full list of benefits please visit our website (www.methods.co.uk/careers/benefits)
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile APIs Azure Cassandra Data pipelines Engineering ETL HL7 MongoDB NoSQL Pipelines Privacy Python RDBMS Scrum SQL SSIS Statistics Streaming Testing T-SQL
Perks/benefits: Career development Flex hours Flex vacation Health care Medical leave Parental leave Salary bonus Startup environment
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Lead Data Analyst jobs
- Open Data Science Manager jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open Data Manager jobs
- Open Sr Data Engineer jobs
- Open Power BI Developer jobs
- Open Principal Data Engineer jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Data Scientist II jobs
- Open Product Data Analyst jobs
- Open Senior Data Architect jobs
- Open Sr. Data Scientist jobs
- Open Business Data Analyst jobs
- Open Big Data Engineer jobs
- Open Data Analyst Intern jobs
- Open Manager, Data Engineering jobs
- Open Azure Data Engineer jobs
- Open Junior Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Data Product Manager jobs
- Open Principal Data Scientist jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open GCP-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Java-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open APIs-related jobs
- Open Deep Learning-related jobs
- Open PyTorch-related jobs
- Open Snowflake-related jobs
- Open Consulting-related jobs
- Open TensorFlow-related jobs
- Open PhD-related jobs
- Open CI/CD-related jobs
- Open NLP-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Hadoop-related jobs
- Open LLMs-related jobs
- Open Databricks-related jobs
- Open Data warehouse-related jobs