Data engineer

Role: Data Engineer Salary: GBP40,000 - GBP50,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 - GBP500 reward on first day of employment followed by GBP500 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 #39;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