SQL Data Engineer

Remote Working with ad hoc travel required

Inside IR35

The primary focus for this role is on provision of a Data Warehouse solution to support the data quality for Power BI reporting

Experience

Ability to take client requirements, understand them and turn them into a high quality, performant data warehouse solution
Confident communicating with stakeholders of all levels including the ability to advise, train and support staff and clients where necessary
Strong data analysis and data modelling skills
Knowledge of Azure Dev Ops Data Model for Analytics is desirable
Previous experience of producing similar requirement is essential
Ability to deliver powerful story told through engaging visuals in Power BI
Understanding how the full suite of Power BI products work is essential
Excellent understanding of agile methodology, OKRs and programme delivery.

Key Responsibilities

Goal of project is to deliver an enterprise view of our client's portfolio delivery across all business areas.
Standardise data from across project tracking tools to show the cumulative benefits delivered from agile change programmes
Create a data model and Power BI outputs that allow teams and stakeholders drill down and share key results and benefit metrics across our client's projects.
Creating analytics products for our client's Value Realisation Office (VRO).
Create ETL process to consume data from Azure Dev Ops, MSFT Project Online, excel project tracking sources.
Create a data model to help the VRO track projects value delivery, prioritisation, and Objective Key-Results (OKRs)
Provide technical support and guidance through prototyping, testing, build, and launch of Data Warehouse solution and Power BI products.
Data Modelling – Validation of data in SQL Data Warehouse and Developing calculations in DAX which are accurate and performant on large datasets.
Designing effective layouts using Data Visualisations best practises.
Create Power BI reports / dashboards / scorecards detailing the delivery of business value from internal change programmes. Results are to be shared with stakeholders of all levels
Undertaking data analyses to support decision making
Develop user manual / training documentation and share knowledge with colleagues
Self-starter/able to work independently and proactively offer solutions
A track record of working in an agile environment
Ability to organise and manage own time according to agreed project priorities and deadlines
Experience of working with Azure Dev Ops Data Model for Analytics, and consuming data via Rest APIs or OData feeds is desirable.
Professional experience with Microsoft Azure data stack (Azure Dev Ops, Azure Data Factory, Azure Databricks, SQL) is desirable
Knowledge of Power Automate and Power Apps is desirable

ersg are an equal opportunities employer; we are committed to promoting equality of opportunity for all job applicants. We do not discriminate against applicants on the basis of age, sex, race, disability, pregnancy, marital status, sexual orientation, gender reassignment or religious background; all decisions are based on merit