Bringing campaign data together
The client needed data from several systems to analyse traffic, campaign performance and profitability. I built a platform that brings those sources together and makes the data available through a reporting interface.
My work covered the source integrations, data processing and the application used to explore the results.
Importing, processing and displaying the data
I connected the sources using Airbyte and custom REST integrations. Temporal and Go workers handled processing, with PostgreSQL storing the prepared data. I built the reporting interface in React and TypeScript.
The client could then compare traffic and performance data from different sources and use it to analyse profitability.
Running the application on AWS
I also set up the infrastructure using EC2, RDS and Lambda. Docker, Terraform, AWS CDK and Ansible handled deployment and configuration, while GitLab CI/CD delivered application changes.