I specialize in helping businesses build efficient and scalable data solutions. One crucial decision in data stack architecture is choosing between an on-premise or cloud-based databases. With my experience I have a deep knowledge of both technologies and advise you what database you works best for you. Also integration tools like DBT (Data Build Tool), Airflow, and Azure Data Factory are necessary to help automate workflows, data transformation, and data integration processes. I guide you through the world of data engineering – and we will find the best way for your data stack.
Have a look at 2 out of the box Data Stacks.
- Data Stack for midsize and large enterprises includes: Connect several different sources like Salesforce, RDS (MySQL Databases), DB2 and more with AWS Managed Airflow. Utilize S3 as flexible data storage. Data ingestion into Snowflake. Implementing a data model on the database with at least a Development and a Production Environment. Orchestrate data pipelines with DBT Cloud and Apache Airflow to keep consistency (ask for pricing).
- Data Stack for small enterprises or single business units of midsize and large enterprises (i.e. Marketing) includes: Connection of several marketing sources like Facebook, GoogleAnalytics, GoogleSheets and CRMs with tools like Airbyte or Fivetran to a Google BigQuery Database. Data cleansing and adding medium size of business logic. Visualization of the results in Google Looker (ask for pricing).
Infrastructure Architecture Design
Analysis of your business requirements, data sources, and data volume to design a data stack architecture that meets your specific needs. For example: Redshift, BigQuery and Snowflake are cloud databases that provide scalability and performance for storing and analyzing large volumes of data. On the other hand on-premise solutions around MS SQL Server are well established, stable and reliable.
Data Pipeline Development
Build end-to-end data pipelines that automate the flow of data from source systems to your data stack. This includes data ingestion, transformation, integration, and loading processes, ensuring a seamless and reliable data flow.
System Monitoring and Maintenance
Provision ongoing monitoring and maintenance services to ensure the smooth operation and performance of your data stack. This includes performance optimization, troubleshooting, and proactive system monitoring.
Cloud Migration and Integration
Assistance in migrating your existing data stack to other on-premise platforms or cloud platforms like AWS, Azure, or Google Cloud. For example I can help your company setting up a Datalake to be ready for Databricks and other Warehouse systems like AWS Athena or Snowflake.
Business Intelligence and Analytics
Integration and migration of business intelligence tools like Tableau, Power BI, or Looker. Many companies are migrating from one tool to another and need support with this, for example to have the dashboards from Qlik to Power BI. I will develop the differences in front- and backend so your migration project will be a success.
Contact me
I’m committed to delivering high-quality Data Stack Development services that empower businesses to harness the full potential of their data assets. Contact me today to discuss your specific requirements, and let us help you build a robust and scalable data stack that drives valuable insights and business growth.
What clients say
Nicolay knows the ins and outs of the modern data engineering stack. His expertise would help any organisation looking to build scalable and reliable data pipelines.
— Ishaan Varshney,
Head of Engineering @ SellerX
Nicolay is eager to learn and develop on a professional level. It was great working with him.
— Benjamin Kettner,
CTO @ ML!PA Consulting GmbH
I was working with Nico back at University as his supervisor and ever since followed his path into IT and Data Engineering… an ambitious learner and self-driven man, very reliable and good to hang out with! Recommended!
— Angelika Schmid,
Lead for Data & AI @ Accenture
Herr Königsmark hat unser Unternehmen bei der Erstellung eines kundenspezifischen Datenreports unterstützt. Dabei war er stets leistungsbereit und engagiert, hat gut Vorschläge eingebracht und hervorragende Ergebnisse geliefert. Die Kommunikation verlief immer rasch und freundlich mit allen Projektteilnehmern. Nach erfolgreichem Projektabschluss danken wir für die gute Zusammenarbeit und wünschen Ihm weiterhin alles Gute.
— Holger Teichmann, Wiesheu GmbH