Background in computer science, information technology or equivalent
Knowledge of Python, SQL – PowerBI, PowerBI, Power Automate/MS Flow
Knowledgeable in designing and implementing ETL processes
Experiences in data modelling / data warehousing
Excellence in Big data solutions including data modelling (structured/unstructured data; virtual data)
Analytical mind-set with potential of managing, communicating and selling solutions which cost effective and focused on business value.
Fluent in English (speaking and written), German will be nice to have
You have experiences working in agile teams
Create a Consumption Data Analytics Platform that helps in encompassesing the full beauty of MS-Azure stack and futuristic technology (Azure Functions, Snowflake, Power Automate, PowerBI) that includes the following tasks:
Analyse and automate/stabilize current ETL processes for End User consumption data
Perform (a) analysis, (b) suggestions for improvements and (c) implement changes based on suggestions
Develop ETL processes pertaining to all Cloud as well as External Labour related IT consumption data
Find out and implement ‘data driven’ solutions as per User story requirements in order to increase the transparency around our IT consumption, and create data insights.
Prepare an estimation of Cloud and External Labour costs for Application Owners
Define and implement ETL processes, data visualization and data model.
Develop transparency regarding consumption details for Cloud for Application Owners
Identification, defination and implementation of solutions for informing Application Owners in case a major application starts showing an unusual cloud consumption (push notification, automated mailing, or other)
Defining and implementing solution in order to allow Application Owners to add a Forecast per application (for cloud & external labour)
Develop data interface to Service Now/EAM database in addition to mapping relevant data to IT consumption data
Identifying and implementing solution for allocating external labour costs to the individual applications
PO requisitioners should be informed when they have ordered external labour and calculate the respective costs for which the external labour is working for (e.g. via Web interface)
Consultation for definition and implementation of KPIs for optimization of expenses.
Execution of data load processes for existing reports by ingesting raw data reports to Consumption Data Analytics Platform