Development of a data infrastructure for the automated provision of various socio economic data to support strategical decision-making

• Design, development, testing, and monitoring of ELT-processes from data sources into Data Warehouse and Data Lake
• Analysis of new variably structured data sources to be integrated
• Implementation &expansion ofdata modelsforan optimal data and reportingarchitecture
• Design of automated data quality and data availability processes to ensure Service Level Agreements
• Design, development and implementation of improvements of the data engineering workflow using CI/CD and templating Solutions
• Analysis and optimization of Solutions in production.
• Development of PoCs for use cases in the area of Streaming technologies

Design, development, deployment, Operation and continuous improvement of an in-house enterprise data warehouse as a central data source for all internal and external reporting.

• Requirementsgatheringand documentation oftheexistingdata infrastructure
• Design of the new data platform
• Development of the data model and ELT pipelines
• Automation of the development and deployment process
• 3rd-level support and process optimization of the data platform
• Ongoing development with changing requirements
• Consulting data consumers in the PoC stage

Operation and continuous development of an automated reporting System for financial reporting

• IT operations of the existing reporting System to support all finance processes
• Source System analysis and continuous development of the data model and ETL processes
• Data Integration from databases, REST APIs, HTML scrapings and files
• Performance optimization of existing ETL processes
• Creation of automated reports
• Operations of the associated database Servers

Development, deployment and Operation of a System for distributed data input, central data storage and flexible reporting to automate manual reporting processes 

• Requirements management
• Project management including invoicing
• Deployment of the company's proprietary OCT Standard solution
• Design and Implementation of T-SQL-procedures
• Implementation of new ETL pipelines to ingest accounting data
• Design of reporting templates