Senior Data Engineer (BI and ETL) Full Time

Methods Business and Digital Technology Limited

Methods Analytics is currently recruiting for a Senior Data Engineer to join our team on a permanent basis.

This role is expected to be remote with require flexibility to travel to client sites.

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.
• Creating effective data visualisation, appropriate to the audience
• 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.

Ideal Candidates will demonstrate:

• Experience of creating PowerBI solutions and dashboards from row level data including data structure optimisation through to visualisation and dashboard creation.
• Strong T-SQL Development including debugging & troubleshooting
• Experience in SQL Server Integration Services (SSIS)
• 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
• Good experience with ETL

o Infrastructure, Azure Data Factory/SSIS, SQL (On-prem/Cloud),

• Good experience with Analytical/Reporting

o SQL (On-prem/Cloud), Analysis Services/Tabular Data Model, Power BI/Tableau/T-SQL

• Understanding of analytical tools; you are numerate.

Desirable Skills & Experience:

• Experience with NoSQL type environments, Data Lakes, Lake-Houses (Cassandra, MongoDB or Neptune)
• Have experience with Python, Scala or Java
• Have cloud based experience, preferably with AWS and/or 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 (ie 1 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
• Knowledge of Healthcare data, specifically NHS Data sources such as HES, SUS PbR

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)