Beschreibung
Hello Everyone!Kommlink is currently looking for a freelance Consultant Data Analytics (m/f) for a remote project.
Project description: the client aims to further enhance the Consumption Data Analytics Platform (CDAP) which is the single source of truth for all IT consumption related data to provide transparency of used services to application owners, management and end users.
Task description
Further develop the the client’s Consumption Data Analytics Platform which encompasses the full beauty of MS-Azure stack and state of the art technology (Snowflake, Power Automate, Azure Functions, PowerBI) which includes the following tasks:
Analyse and further automate/stabilize current ETL processes for End User consumption data
Conduct (a) as-is analysis, (b) recommendations for improvements and (c) implement changes based on (b)
Develop ETL processes for all Cloud and External Labour related IT consumption data
Define and implement ‘data driven’ solutions based on User story requirements below to increase the transparency around our IT consumption, and create data insights.
Create overview of Cloud; External Labour costs for Application Owners
Definition and implementation of ETL processes, data model and data visualization
Create transparency on the consumption details for Cloud for Application Owners
Definition and implementation of ETL processes, data model and data visualization
Provide transparency of application utilization and costs for Application Owners
Definition and implementation of ETL processes, data model and data visualization
Identify, define and implement solutions to inform Application Owners in case a major application shows unusual cloud consumption (automated mailing, push notification or other)
Identify, define and implement solution to allow Application Owners to add a Forecast per application (for cloud & external labour)
Create data interface to the client’s Service Now/EAM database and map relevant data to IT consumption data
Identify, define and implement solution to allocate external labour costs to the individual applications
PO requisitioners will be informed in case they have order external labour and shall be able to costs to the respective costs the external is working for (e.g. via Web interface)
Create transparency on the consumption details for External Labour for Application Owners
Definition and implementation of ETL processes, data model and data visualization
Consult the client in the definition and implementation of KPIs for spend optimization
Execute the data load processes for existing/already designed reports by ingesting raw data reports to Consumption Data Analytics Platform
Skills:
Background in computer science, information technology or equivalent
Capable of Python, SQL - Snowflake, PowerBI, Power Automate/MS Flow
Knowledgeable in designing and implementing ETL processes
Experiences in data modelling / data warehousing
You deliver conceptual brilliance with a track record for (big) data solutions incl. data modelling (structured/unstructured data; virtual data)
You have an analytical mind-set with the ability to manage, communicate and sell solutions which focus on business value while being cost effective
You’re business fluent in English (speaking and written), German will be nice to have
You have experiences working in agile teams
Project start: April 2021
Project location: Remote
Project duration: 5+ months
In case you speak English and and are eligible to work in the EU, you can share your CV to !