About the Role:

We’re looking for a Data/ BI Engineer to join the IT department to help us fulfil the ambitious goals of the organisation. Many of these goals need to be supported with quality data and our ability to process this data at scale.

You will be part of a team of data engineers that use SQL Server and AWS to produce data sources for reporting and analytics. You will shape data into new models for analysis, integrate new data into the environment and maintain the data platform.

The core of our platform is built on MS SQL Server, but we’re expanding and learning to use more AWS services such as Athena, Glue and Sage Maker.

You will make a considerable contribution to our business, helping us make better decisions from the insights your data will provide.

Key Responsibilities:

The Data/ BI Engineer will:

• Work with the Data Product Owner to scope, plan & estimate new data processing needs.
• Build data pipelines (SQL/ SSIS/ AWS Glue/ Athena) to ingest data from internal/ external data stores and transform the data as needed.
• Have strong experience of Microsoft SQL Server databases and SSIS
• Have strong T-SQL knowledge and be able to debug, optimise, and performance tune existing complex SQL Server procedures/ functions.
• Collaborate with our business users to clarify requirements
• Integrate data from our systems into our data warehouse to produce our “source of truth” for all reporting and analysis
• Have sound knowledge of cloud data pipeline tools (AWS preferred), architecture, big data systems and how to scale these to process high data volume/ velocity. Experience here is a plus.
• Be passionate about data quality and the service we provide through data to our customers.

About the Person:

We understand everyone has their strengths and performs to their best in different ways, but some of our most successful people here:

• Are passionate, curious and excited about data
• Have an appetite for personal development
• Display great self awareness around time management and prioritisation
• Are diligent and conscientious
• Show adaptability and resilience
• Have personal drive
• Are solution focused
• Are trusted by others and offer support
• Communicate well with others within their own department and across the business
• Are a team player, show accountability and embrace responsibility

Skills/ Experience:

• SQL Server (T-SQL, Query Optimisation, Indexing, Partitioning)
• SSIS
• Powershell
• Data Modelling
• Python
• Strong analytical & problem solving skills.
• AWS (Glue, Lambda, Redshift, Athena)
• Experience in big data technologies would be great.