For one of our clients in Düsseldrof we’re looking for a freelance Consultant Data Analytics (m/f)

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