Data Engineer


You will be part of the reecetech Technology Services team, reporting to the BI and SQL Server Lead. You will be a key BI technical resource working in the Business Intelligence and Data Warehousing team whilst also working closely with the Business Performance and Analytics team.

The role will involve you designing, maintaining and supporting solutions for the in-house BI environment. You will require SSAS, SSIS and SSRS skills using MS SQL Server, data visualization / analytics tools, ETL, data warehouse and tabular cube solutions.

OUR PURPOSE

To improve the lives of our customers and our people by striving for greatness every day

POSITION RESPONSIBILITIES

The role will involve you supporting and maintaining solutions for the in-house BI environment. You will be part of the I.T. Operations Services team, reporting to the SQL Tech Lead, where you will play a key role in supporting and working closely with the Business Performance & Analytics team. The role will require various skill sin the SQL environment and a good understanding of data visualization / analytics tools, ETL, Data warehouse, Cube and reporting.

  • Design and develop ETL processes
  • Establish knowledge of Reece data for accurate population, manipulation and retrieval of data
  • Integrate production systems into the data warehouse for development of data models and relational / dimensional modelling
  • Provide maintenance and enhancements to the enterprise data model
  • Performs data analysis and other reporting tasks. This involves data investigation and cleansing
  • Creation, maintenance and troubleshooting of ETL jobs
  • Creation and maintenance of database objects in coordination with the BP&A team
  • Creation of technical documentation for all systems and processes implemented
  • Own all aspects of Change, Problem and Incident Management for the entire BI environment
  • Develop and maintain sound working knowledge of the Reece business, specifically the function Business Intelligence plays within the organisation
  • The primary duties of this position occur during business hours, however there is some evening and weekend work related to projects, planned maintenance, and on-call support

KEY SKILLS, QUALIFICATIONS AND EXPERIENCE

  • Experienced background in Microsoft based ETL and T-SQL development to develop, maintain and improve Microsoft Analysis Services cubes / data models, SQL procedures and views
  • Strong experience with Microsoft SQL Server 2014 / 2016
  • BI Solution Design and Implementation utilising SSIS, SSAS, SSRS, Azure, Excel
  • Ability to apply good analysis and design skills, critical thinking, and analytical problem-solving abilities
  • Strong ability to understand business needs and translate these into realistic IT solution oriented requirements
  • Adhere to coding standards, best practices, and contribute to the improvement of these best practices
  • Strong knowledge of SQL with the ability to write complex SQL queries
  • Understanding of Business Intelligence solutions: operational and analytical, strong knowledge of relational, multi-dimensional and tabular database architectures
  • Proven experience in designing and implementing data warehouse solutions and dimensional modelling
  • Experience in resolving complex client and stakeholder related queries
  • Experience in data warehouse design and best practices
  • Strong experience in developing dashboards and data visualisations using MS Power BI
  • Minimum of 2 years’ experience creating advanced reports using Microsoft SSRS
Are you viewing this job on LinkedIn? Click here to apply