Build Data Warehouse For Ecommerce Agency

Cancelled Posted 2 years ago Paid on delivery
Cancelled

We need to build a data warehouse and ETL pipeline for our own ecommerce agency. We have already scoped the project and we have experience with BI projects of this kind. We're looking for a data engineer to help us design the db and set up the ETL.

The data sources to be imported are Postgres, Google Sheets, CapsuleCRM, Float and Clockify for time tracking data. We want to create internal reporting such as revenue and profit broken down by various dimensions such as month, team, client etc.

We have a good idea of the architecture. We'd like to use dbt for transformations, BigQuery for the dbw and Zapier or custom extractors for some of the sources

For the front end, Data Studio at this stage should be sufficient, but we're open to using a more advanced reporting tool such as PowerBI or Tableau.

We have done quite a bit of scoping already and have more details that we can share in an introductory call.

ETL PostgreSQL SQL Data Warehousing

Project ID: #30692115

About the project

16 proposals Remote project Active 2 years ago

16 freelancers are bidding on average €37/hour for this job

Truonggiang86

Hello there, I’ve been now working as a data engineer. My job everyday is to design the model, data mart, ingestion from multiple data source and transform to the data warehouse and build the report for the user. Actua More

€40 EUR / hour
(21 Reviews)
5.0
ayesha0124

Hello there, I am sure i can help u as i have experience with doing similar jobs. I can do this job because have great experience with SQL, PostgreSQL, ETL and Data Warehousing. You can have a look at my profile here: More

€36 EUR / hour
(2 Reviews)
3.4
aap31374

I have more than 15 years of experience in SQL Server database design, modeling, development, and Administration. I have worked for database designing and modelling of complex business an efficient way. I have very go More

€37 EUR / hour
(5 Reviews)
3.4
asin1987

Dear Employer, I understand you need: - to extract data from Sources like Postgre, Google sheets etc. - Use ETL to extract data. This can be done through Zapier or other customizations. - Create Visualizations on Powe More

€36 EUR / hour
(1 Review)
3.0
WebcoderSaurabh

Hi , I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.I have more than 4+years marvellous experienced in Web Technologies. I am fully dedicated and enthus More

€36 EUR / hour
(0 Reviews)
0.0
nishthamarwaha

Hi, I can Build Data Warehouse For Ecommerce Agency. I have more than 7 years of experience as a ecommerce specialist. I developed many ecommerce websites. And over the years many of my ecommerce stores are generating More

€36 EUR / hour
(0 Reviews)
0.0
ibrainers

Hi I am Jaypal Brahmbhatt from IBRAINERS LTD. IBRAINERS LTD is London, Uk based company. We have 5+ years experience. We created many MNC company data warehouse tools. We can do your work and deploy you extra. Please More

€36 EUR / hour
(0 Reviews)
0.0
ramtech005

Hi there! This is Ramesh Hope you are doing well. I’ve read your brief and I can do this as you want.. I have 10 years of experience in this field.. so contact me if you really want to make this best and effective as More

€50 EUR / hour
(0 Reviews)
0.0
Blueice349

Hello, Sir. I read your description carefully. I have 5+ years of experience with Software Development including Desktop App and Web Development. I used React, Vue, Experss JS and PHP etc. I am perfectly suitable for t More

€36 EUR / hour
(0 Reviews)
0.0
alexisharo88

Hola, Tengo más de 8 años de experiencia trabajando con bases de datos, ETL´s y herramientas de visualización de datos como Power BI Y Tableau, te comparto el enlace a mi perfil: https://www.freelancer.mx/u/alexishar More

€36 EUR / hour
(0 Reviews)
0.0
AITSoft

Hi, I have read the details I believe I can do this job because I am experienced with SQL, ETL, Data Warehousing and PostgreSQL. While I believe I have some queries which need to be clarified. For that I would request More

€36 EUR / hour
(0 Reviews)
0.0
coolfire2019

Having overall experience of 10+ years in SQL and BI, currently working on Talend ETL tool and Postgres SQL DB.

€36 EUR / hour
(0 Reviews)
0.0