Data Engineer

Role: Data Engineer

Salary: £40,000 - £50,000

Location: Dorset (1 day a week onsite)

Overview

The Data Engineer will work closely with IT, Finance and Operations to deliver the business reporting requirements within a timely and consistent manner. They are required to develop and provide trusted data on performance, financial positions to aid decision making across the business. They also to provide tactical information to end users to support process.

Benefits

• Up to 10% matched pension scheme with Standard Life
• Death in Service: 4 x salary
• Annual Car Parking permit
• Purchase monthly during probationary
• 27 days holiday (+ 8 Bank Holidays)
• Discretionary performance related bonus scheme
• Annual Flu Jab
• Employee Recruitment scheme - £500 reward on first day of employment followed by £500 reward after 12 months of employment. (T&Cs apply)
• Long service loyalty awards
• Simply Health - They provide Level 1 cover , however you can pay an additional premium to increase your level of cover and add your partner. Children under the age of 24 can be covered free of charge.

Skills

• Hold qualifications in related disciplines such as Statistics, Mathematics and Data Sciences
• Experienced in working Microsoft Cloud Data and Automation technologies
• Experienced working with Tableau and or Power BI
• Experienced in data warehousing for SQL Server and or ADF
• Experienced working with Windows SQL Servers
• Experienced in SSIS XML and other forms of data transformations
• Experienced in writing SQL scripts including procedures in Oracle and T-SQL
• Proficient in Excel
• Experienced in creating presentation layers and business intelligence pyramids

Accountabilities

• Work with management to aid the society's ongoing Data Strategy
• Automate the collection of disparate data sources to Data Lakes and Data Warehouses
• Production of underlying SQL (tables, views, stored procedures, SSIS packages etc.) to enable production of critical datasets.
• Work closely with the subject matter experts to ensure data accurately reflects the business requirements
• Work across all functions to test and produce reporting solutions
• Publish team specific interactive dashboards with conclusions
• Demonstrate a thorough understanding of the data within our core systems
• Develop timely, efficient and reliable reporting solutions
• Integrate reporting solutions into the wider business applications
• Manage Tableau, ADF and SQL Server reporting deployments
• Create, maintain and produce ad-hoc reports; support specific data investigations
• Enable self-service business intelligence that give business end-users access to information without direct IT involvement
• Analyse data to create and support business cases and effect change within the business
• Conduct any administration duties required across reporting ecosystem
• Work closely with IT team to exploit Infrastructure technology to optimise production

In Technology Group Ltd is acting as an Employment Agency in relation to this vacancy.