Merk Investments

Merk's Financial Data Journey with Airflow & Django
Dreaming Spanish
Expert Team

About Merk

Merk Investments provides investment advice on liquid global markets, including domestic and international equities, fixed income, commodities, and currencies. Merk also offers advisory services to high-net-worth individuals, trusts, and institutional clients.

The Challenge Icon

The Challenge

Merk Investments faced a complex data management dilemma, navigating through the intricacies of consolidating information from diverse sources such as banks, trader platforms, stock exchanges, and various data providers. The challenge lay in efficiently processing this disparate data to empower their analysts with timely, accurate insights for informed decision-making in the dynamic landscape of global financial markets. The need for a seamless and scalable solution was evident to enhance the overall efficiency of their investment operations.

The AppEvolve Solution icon

Proposed Solution / Architecture

To overcome Merk Investments' data processing challenges, we designed a solution combining Apache Airflow for orchestrating data pipelines and a Django web application for streamlined data processing and display. Apache Airflow serves as the backbone for orchestrating and automating data workflows. Utilizes directed acyclic graphs (DAGs) to define and manage the sequence of tasks for data extraction, transformation, and loading (ETL).

Mobile Application Development
Django Web Application:

The web application, built on the Django framework, acts as the user interface for analysts to access and analyze processed data.Provides a user-friendly dashboard for real-time tracking, visualization, and decision-making.

Offline Capabilities
Angular Front-End
  • Amazon S3 (Simple Storage Service)

  • Amazon RDS (Relational Database Service)

  • Amazon VPC (Virtual Private Cloud)

  • Amazon CloudWatch

  • Amazon RDS (Relational Database Service)

  • Amazon IAM (Identity and Access Management)

Join the ranks of successful stories featured in our agency’s portfolio.