Data Engineer
| Posting date: | 02 July 2024 |
|---|---|
| Salary: | £40,000.0 to £45,600.0 per year |
| Additional salary information: | £45,000 per year |
| Hours: | Full time |
| Closing date: | 09 July 2024 |
| Location: | Cardiff, Cardiff, CF3 0LT |
| Company: | Hays Specialist Recruitment |
| Job type: | Permanent |
| Job reference: | 4539547_1719910544 |
Summary
Your new company
You will be working for an established utilities organisation based in Cardiff, who provide services to over 3 million people across Wales and parts of England. To achieve their goals of delivering high quality services, this organisation employs a vast technology function that is critical to their operations. They are now looking to add a Data Engineer to this function.
Your new role
Based out of the Cardiff hub, you will be joining the Data Engineering team, belonging to the organisation's wider Data Team. This team plays a critical role in providing quality and reliable data to feed into analytics products used by the business for decision making. The Data Engineer role will participate in the technical planning and implementation of data structures and pipelines within both on-premise (Microsoft SQL Server) and cloud (Microsoft Azure) environments. You will work closely with Database Developers and the Lead Data Engineer to ensure developed solutions are robust, accurate and efficient. There will also be the opportunity to get involved with the latest cloud-based technologies and advanced analytics.
You will work on a number of on-premise SQL Servers, undertaking both database administrative activities, and building pipelines to feed data into analytics outputs, such as predictive models.
Key responsibilities
1. Designing and implementing high quality data engineering solutions on both on-premise and cloud based data stacks, ensuring compliance with architectural and data security requirements
2. Being able to work collaboratively as part of a team, whilst also being trusted to work individually where necessary. Approaching collaborative projects with others in a positive manner to overcome issues and challenges
3. Working closely with technical colleagues within key teams within Integrated Technology Services (ITS) - to ensure relevant information technology components and services are in place to accommodate developed solutions
4. Remain aware of new developments within the specialist field
5. Undertaking any other duties as required to meet the needs of the business.
What you'll need to succeed
Qualifications
- Relevant undergraduate degree (BSc) in computer science, mathematics or related discipline; OR relevant long term experience; OR MCSA/MTA certification.
Experience
- Approx 2 years' experience in any of the following or related fields: database management, data architecture, data platform management
- Experience using cloud-based data stack (e.g. Azure, AWS, GCP)
Knowledge & Skills
- Enthusiastic about putting our customers first every day
- Experience of data pipeline design and creation
- Database administration activities
- Data transformation approaches
- Python and SQL programming capabilities
- Data security approaches - e.g. permission models (AD, role-based etc.) and techniques to protect data in certain circumstances (e.g. encryption, masking)
Desirable
- An awareness of typical ingestion patterns (e.g. ETL, ELT) and their effective implementation with on-premise and cloud-based environments
- Knowledge of typical data modelling approaches (e.g. Kimball)
- Experience using the Microsoft data stack (especially Azure Data Lake, Azure Synapse, Azure Data Factory)
- An awareness of the full software/reporting lifecycle from planning and design through deployment and maintenance. From requirement gathering to report or dashboard solution.
- Awareness of the Microsoft BI Stack, including Analysis Services, Integration Services and Reporting Services, and Power BI
- Understanding of DevOps (or other source control technologies) - particularly code repositories and version control, containerisation methodologies, and application deployment practices (CI/CD pipelines)
What you'll get in return
Alongside a competitive annual salary, the organisation offers a flexible working model where you will be required to work from home as well as at the Cardiff office on some occasions. 33 days annual leave (including public holidays), as well as the following benefits;
* Variable pay schemes ((your salary band will remain the same, but performance depending, you could receive an incremental within-band increase and a yearly incentive)
* Enhanced employer pension contributions - Up to 11% employer contributions
* Enhanced family friendly policies
* Progression opportunities, including the ability to apply for funded training and coaching and mentoring programmes
* Reduction on gym memberships and high street shopping
* Cycle to work scheme
* Free on-site parking at all our sites
* Discount off all Welsh Water visitor attraction centres and gift shops
* Car-leasing scheme
* Health CashBack scheme
* An employee assistance programme for employees and their immediate family
What you need to do now
If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.
If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion on your career.
Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at hays.co.uk