Cloud-based Data Infrastructure and ETL

Client Challenges

  • Lack of Data Engineering and BI Expertise with the core team of the Client
  • Tight timelines (the new Data Infrastructure and ETL to populate the BI-ready data had to be the part of the upcoming new ERP platform release)

Services

  • Created BI Infrastructure and BI reporting for an Israeli international music label Enterprise Resource Planning (ERP) Provider.
  • Helped the customer integrate BI systems into their core ERP cloud platform.
  • Ensured import of the data from various cloud API data sources (Apple Music, Spotify, Online radio broadcasting platforms, YouTube).
  • Trained the Customer team to integrate the solution into their product platform. •AWS Stack used (Athena, Glue, S3, Lambdas).

Client: International music label ERP Provider.

Segment: Big Data, Data Warehouse, ETL

Users base: Thousands of end-users (musicians, artist, music band managers) across the globe

Technology stack: AWS, Python, SQL

Team structure: 1 Data Architect, 1 Sr. Data Engineer, 1 Jr. Data Engineer