Data Engineer

BI Data Developer/Engineer.

Business Intelligence / SQL / Azure SQL data warehousing / Microsoft SQL Server or Azure SQL DB / ETL / ELT / Data Lake / Kimball data modelling / Azure DevOps

The Data engineers will build and deliver the components of an effective Analytics platform; leveraging data warehouse storage, utilising Azure Data Factory for data integration and Power BI for end-user data analytics and reporting.

This role will play a critical part in the architectural design and implementation of these elements - capable of meeting a wide range of reporting/analytics needs. This role will encompass a mix of hands-on technical development and strategy development; supporting the faculty to continue its journey to develop its analytics platform on next-generation technology.

Skills needed

• SQL Data Warehousing
• Experience of cloud architectures and solutions, especially Azure ADF
• Azure Data Factory with experience building and debugging pipelines.
• Microsoft SQL Server
• Data modelling
• Develop BI/MI solutions
• Azure Data Lake

Desirable Skills and Knowledge

• Azure DevOps/Jira
• Agile development
• Power BI (Tabular Model)
• Kimball data modelling
• DAX
• Meta-data driven ETL

What you will be doing:

• Work in an agile, proactive manner delivering high-quality solutions in agreed timescales.
• Design and develop ETL/ELT processes, data warehouse database architecture, Tabular Model, reports and dashboards; in-line with company reporting strategy and best practise.
• Design and develop models and databases both relational and dimensional to support reporting requirements.
• Assist in developing standards for data warehouse, data ingestion, data access layers and BI solutions
• Help mentor, steer and supervise your team from a technical standpoint while influencing technical direction
• Ensure the University maintains a low technical debt & identify an area for automation (CI/CD pipelines) and continuous improvement