Enosis Outsourcing logo
EndorsedendorsedOngoing

Data Warehouse DevOps & Analytics for Digital Advertising Company

Services Covered:

Big Data Analytics and Business Intelligence • Cloud Consulting and Services
Project hero — replace with case study imagery
Industry
Industry

Advertising & Marketing

Duration
Durationinfo-circle

25 months

Budget
Budget

1M - 10M

Start Date
Start Date

1 June 2022

Team Size
Team Size

11-15

Engagement Model
Engagement Model

Offshore

Project Capability Score (PCS)

gauge meter
83/100
Strong

Project Capability Score (PCS) estimates how capable Canopus Infosystems is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Quantcast Inc

mapSan Francisco, United States of America

Project Summary

Canopus InfoSystems supported a digital advertising company with data warehouse DevOps, operations automation, maintenance development, and data engineering. Over the engagement the team expanded from initial operational maintenance into analytics, BI, and new product development, resolving production issues and delivering visualizations and custom reports. The vendor's work produced operational savings and improved analytics capability.

Key Challenges

  • Data warehouse DevOps and analytics

Project Deliverables

  • Data warehouse operations automation
  • Maintenance development
  • ETL pipelines (Pentaho / Python Jupyter Notebooks)
  • ELT Snowflake SQL wrappers
  • Infrastructure and tooling: Jenkins, Docker, AWS S3, PostgreSQL

Project Solution

Canopus provided data warehouse operations automation and maintenance development, including data engineering activities. They built and maintained ETL pipelines using Pentaho and Python (Jupyter notebooks) and ELT using Snowflake SQL wrappers. The engagement used Jenkins, Docker, and AWS (S3) and PostgreSQL for infrastructure and tooling and was staffed with a 12-15 person team.

Project Outcome

  • Started with 5 people and scaled to 12 people
  • Team ownership and quick resolution of production issues
  • Supported new product development beyond operational work
  • Provided data analysis, visualizations, and custom reports for customers
  • Saved approximately $500K per year

Platforms

  • CloudCloud

Tech Stack

  • PythonPython
  • PostgreSQLPostgreSQL
  • Amazon Web Services (AWS)Amazon Web Services (AWS)

Client Endorsement

Overall Review Rating

4.88star

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Canopus InfoSystems has been instrumental in helping the client with new product development activities beyond operational work. The team quickly resolves issues and delivers excellent results. They are customer-focused, flexible, and have a good documentation process.”

Naveen Evuri

Senior Data Warehouse Manager

Note: This endorsement is based on publicly available client feedback from external review sources.