SQL Data Engineer

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 SSE 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 SSE projects.
• Creating analytics products for SSE'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

Guidant Global is acting as an Employment Business in relation to this vacancy.