Data Engineer
Job Type : Permanent, Full Time
Salary : £50000 – £70000/annum +15
Location: UK, Remote though willingness to travel for rare essential meetings required (expenses paid)
Work Pattern: Permanent
Clearance: Active SC Clearance or eligible to be security cleared to SC level
The Company
We are a specialist Data Engineering, Cloud and Analytics consultancy focused on supporting our clients in successfully delivering on their digital transformation programmes. Our aim is to ensure we deliver value from our client’s data using innovative approaches that improve their data capabilities, analytics and data governance.
With demand for our services from our clients at an all-time high and continuous growth and success within our market sector, we are embarking on a major recruitment drive and keen to recruit talented Data Engineers to join our Data Engineering & Insights practice.
The Role
The Data Engineer will support our software developers, database architects, data analysts and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. The right candidate will be excited by the prospect of optimizing or even re-designing our company’s data architecture to support our next generation of products and data initiatives.
Responsibilities: On-Premise Data Engineer
* Work directly with clients to understand their business problems and translate these into data solutions, from prototype to production-ready code
* Provide technical guidance and advice to help in the design and development of data solutions for data modelling and warehousing, data integration, and analytics.
* Implement SSIS packages to connect operational systems and data for analytics / BI workloads and systems
* You will design and develop scalable data ingestion frameworks to transform a wide variety of datasets;
* You will research, analyse, and help implement technical approaches for solving challenging and complex development and integration problems, supporting the build out of a strategy and roadmap;
* You will collaborate in developing and maintaining a knowledge base of best practices and delivery templates to standardize sales and delivery efforts.
Qualifications for Data Engineer
* Microsoft SQL Server expertise:
* Designing and creating tables, models, views and stored procedures etc.
* Expert understanding of SQL Databases
* Data warehousing design and modelling experience a must.
* Ability to design and create high performance ETL, data transformation and loading techniques from various sources ie Excel, CSV, Structured and unstructured data.
* An intermediate to advanced skill level within Visual Studio and SSIS, with experience of successfully leveraging these in a Enterprise Class environment for a minimum of 2-3 years.
* Preferable SSIS training to advanced level.
* Skills to identify and translate business requirements into technical ETL requirements.
* Ability to structure data designs into various consumption models (3nf, dimensional models)
* Understanding of Agile working methodology, teams and best-practice.
* Enterprise class development experience, code management and an understanding of release management.
* Experience of Code repositories such as TFS or GIT in an Enterprise Class environment.
What we offer to you?
* This position offers a prosperous future. We believe that our people are what makes us the company we are. We adopt a partnership model, ensuring that we all share in the success of the business. With only 4 levels in our hierarchy between Consultant to Partner, everyone is empowered to have a positive influence in the way we do things. A chance for you to grow your career with us, whist we scale-up our business.
* We offer a comprehensive private health insurance plan through Aviva, as the well-being of our team is one of our highest priorities.
* We also have a fun rewards scheme with Perkbox, which can offer discounts and freebies on a variety of goods and experiences.
* We support our employees progress through their careers, by offering to fund training programmes to help you upskill yourself.
* The chance to work in a supportive and growth focused environment and learn from senior subject matter experts whilst also securing a competitive salary and excellent bonus and benefits package.
* The chance to work at the forefront of the latest technologies and innovations, on cutting-edge projects and programmes that will allow you the autonomy to work independently.
* To be part of a team that embraces the strengths of diversity and inclusion. A collaborative outlook where your voice and ideas are always heard.
* A platform that will support and allow you to push your own ideas to deliver on projects successfully.
* We believe the best impact is the value we add, not the hours we sit at our desks. We promote a good work/life balance for all our staff and welcome discussions about flexible working.
Interested?
Then please get in touch by applying with your most recent copy of your CV including a contact number and we will contact you directly to discuss further.
We welcome applications from all suitably qualified people regardless of gender, race, disability, age or sexual orientation. All applications are assessed purely on merit, against the capabilities and competencies required to fulfil the position.
Essential Requirements:
* Candidates must be resident in the UK and legally able to work without a VISA
* Candidates must be SC cleared or eligible for SC clearance (resident in the UK for a period of 5 years without a break exceeding 6 months)
More Information
- Address Nationwide
