Find Jobs
Hire Freelancers

Extraction of Marketing metrics and data warehouse build

$25-50 AUD / hour

Closed
Posted about 5 years ago

$25-50 AUD / hour

Help set up the use of ETL's for marketing metrics, into a data warehouse and connect a visualisation tool such as Looker
Project ID: 19046799

About the project

21 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
21 freelancers are bidding on average $37 AUD/hour for this job
User Avatar
Hi, I have 9 years experience in development and deployment that includes SQL Server, SSRS, SSIS and .NET. Involved in SQL Server activities like Installing, Migrations, Table Partitioning, Configuring maintenance jobs, Optimizing etc. I have expertise in writing complex queries with proper joins and index selection. Involved in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. I have delivered highly successful projects in ASP.NET, C#/VB.NET Win-Forms, EF with complex logic in SQL Server Stored Procedures. Thanks
$44 AUD in 40 days
4.9 (47 reviews)
6.6
6.6
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$25 AUD in 40 days
5.0 (13 reviews)
5.5
5.5
User Avatar
Hello i hope you are doing great i will make your system where i will collect data from different sources and show at one place but I do need more details for your existing system or resources from where i have to collect the data Let's connect over chat window for more details Thanks
$27 AUD in 40 days
4.8 (2 reviews)
4.4
4.4
User Avatar
Hi, I'm a BI/DWH/ETL expert from Bulgaria (EU) with 9+ years of experience in that field. I'm proficient in wide variety of data tools: 1.ETL-SSIS, Pentaho Kettle, Talend, Oracle Data Integrator (ODI), Informatica. 2.Databases-MySQL, MSSQL, PostgreSQL, Oracle, Teradata, and a few others. 3.BI-Pentaho BI, SSAS, SSRS, PowerBI, Cognos Also, my daily job routine requires very good scripting skills: Bash, Powershell, Python, as well as deep knowledge of SQL and database performance tuning and optimization. Best Regards
$55 AUD in 40 days
4.7 (3 reviews)
4.4
4.4
User Avatar
Experience • My total experience is 6.8 years in Predictive modeling Statistical Analysis, Optimization and Machine learning techniques. I have implemented data science solutions for the Digital marketing & advertising, Telecom and Insurance Industries. • I am expert in using a Domain Specific Language like R & Python and statistical tools like SAS, SPSS & Eviews. • Masters in Statistics • Certificate of Actuaries (Passed 5 Papers CT Level): - CT-1 (Financial Mathematics), CT-2 (Finance and Financial Reporting), CT-3(Probability and Mathematical Statistics), CT-6(Statistical Methods), CT-9(Business Awareness) from “The Institute of actuaries of India, Mumbai”. • Bachelor of Mathematics and Statistics – • SAS Certified Base Programmer for SAS 9 • SAS Certified Statistical Business Analyst Using SAS 9: Regression and Modeling Responsibilities for Data Scientist • Interacting with stakeholders throughout the organization to understand the challenges and design business solutions for the same • End to end project execution starting from data exploration to insight generation and recommendations • Processing, cleansing, and verifying the integrity of data used for analysis • Device predictive and descriptive analysis techniques and machine learning algorithms in various projects • Coordinate with different functional teams to implement models and monitor outcomes. • Develop processes and tools to monitor and analyze model performance and data
$44 AUD in 40 days
5.0 (7 reviews)
3.6
3.6
User Avatar
Hi There, I read and understood your requirement that you want to design data warehouse in SQL Server.. I am very good at ETL, Data Warehousing and SQL Server and I can deliver the project to your satisfaction. Let us connect and discuss the project in detail.
$50 AUD in 20 days
5.0 (6 reviews)
3.5
3.5
User Avatar
Everlytics is an Enterprise AI company headquartered in Singapore with an offshore development team in Bangalore, India. We as a team have an exhaustive technical skill set and have delivered a number of projects successfully in the areas which includes Machine Learning, Big Data Analytics, NLP, Computer Vision, Deep Learning and Business Intelligence to name just a few. We have experience in the workflows of the ETL/ DWH/ Data Visualisation tools: Design DWH data model and implement it on required RDBMS. Suggestion: PostgreSQL, MySQL or MS SQL. Developing ETL packages to stream data from external data sources into the DWH Design and implement OLAP cubes if the data is huge (decided by granularity and number of dimensional drill downs required) Create reports and integrate them into Dashboards using BI tools such as Tableau, Power BI etc.. We have done some Analytics for Marketing domain Market Analytics: Organizing results campaign to campaign for time on page, pages per visit, bounce rate, social shares etc.. have created dashboards within Google Analytics that give this view Can download GA data into Tableau and create many more slices/dices the data and create complex yet meaningful (and quick to grasp) visualizations & dashboards Calculation of how much are we paying to acquire a new lead (the CPA metric) We look forward to hear from you. Good day!
$38 AUD in 40 days
5.0 (2 reviews)
3.1
3.1
User Avatar
Hi Lets discuss this marketing metrics extraction analysis in detail. I have been working on machine learning since 2012. There are several machine learning and deep learning models I have used particlurly for computer vision, sentiment analysis and customers data trends extraction. My experince with Python, Tensorflow,PyTorch, Weka allows me to apply models including linear regression, SVM, Descion Trees, Neural Networks, Attention Networks and GAN's.
$25 AUD in 40 days
5.0 (2 reviews)
1.0
1.0
User Avatar
I have extensive DW, ETL and data visualisation experience. I have used Informatica, SSIS, Tableau, Power BI etc. I also have data modelling and big data experience. Below is my career summary. Highly effective Technical Leader with over 25 years of experience, Andrew Kim is specialising in data integration, data conversion, data engineering, ETL, big data architect, data analytics, data visualization, data science, analytics platforms, and cloud architecture. He has an array of skills in building data platforms, analytic consulting, trend monitoring, data modelling, data governance and machine learning. Andrew Kim is recognised as a thought technical leader with expert ability to successfully implement end-to-end architecture, design and delivery for big data, data warehouse and business intelligence projects. For the last 10 years, he successfully delivered a number of large data analytics platforms and applications for a number of large Australian governments and corporations. Andrew Kim has a bachelor degree in Information Systems, a master degree in Computer Science and a number of industry qualifications. TECHNICAL SKILLS • Big Data (Hortonworks and Cloudera) – Spark(PySpark, Scala), Kafka, Hive,Impala, NiFi, HDFS, Sqoop, Ranger, Yarn, Solr, SAM, Schema Registry, SuperSet • Language: Python, Scala, R, JavaScript • Data Visualization – Tableau, PowerBI, OBIEE, DOMO • Plunk & ELK Stack – ElasticSearch, Logstash, Filebeat, Kibana • AWS – S3, RefShift, DynamoDB, Athena etc
$61 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Thanks for advertising this opportunity and allowing me to bid. This is Harish and I am based in Wakefield, UK. I am currently working as Data warehouse architect and Azure cloud consultant for National organisation in UK and I have around 15 years of working experience with DW, Analytics and Reporting projects on various difference roles. I can assure you that this project will be delivered on time and to your satisfaction and I will accept the payment only if you are happy with what I have delivered. My approach to deliver this project would be to execute them using Agile software development methodology by dividing your solution into various user stories and create appropriate milestones to meet your target date. Each milestones would contain phases to gather user requirement, design & produce prototype of the product, reassure user requirement, develop, test, deliver & provide warranty support. Later I would integrate all the agreed user stories to create the final product. The integrated product would undergo testing phase to assure quality. Noted that you have requested 40 hrs per week to develop this BI solution, I can assure that I will dedicate 25 hrs for this solution and in this time frame I can produce & deliver quality products based on my experience, if needed I can up-effort. To start, I would like to discuss brief requirement with you and understand the tools & technology available. Please let me know if you need any more detail(s). Thanks, HK
$27 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am accomplished Data Analytics professional with 7 years and 6 months of experience in Customer Analytics, Banking, Credit Risk, Remediation Strategy, Collection Strategy, Data Management and Fraud Prevention domains. My professional career has grown from a data analyst to a data scientist over the years which provided me opportunity to learn some interesting supervised & unsupervised machine learning algorithms including Linear & Logistic Regression, SVR, SVM, K-NN, Naive Bayes, Random Forest and other ensemble techniques. I spent 5 years and 10 months at Aon Hewitt as Analyst-Experienced where I worked as ETL Developer and automated report generation process using SAS/SQL. I used Control-M, SSIS package to automate the process of retrieving client’s data to landing it to the final database. During the process, I also developed sanity checks using SAS to ensure data integrity and quality. Coordinating with the customer to gather requirements and brainstorm ideas was part of my daily job.
$41 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Data Scientist/Analytics Consultant with over 13 years of industry experience. I have worked in various domains like Retail, Banking, Insurance and Healthcare (Real World evidence). I have been invoved into end-to-end analytics project execution which involves the following taks: a) Data Management (Processing, Cleaning, Transfomation) b) Data Reporting/Dashboarding (BI) c) Data Analysis/Modeling To accomplish the above mentioned tasks, I am extensively using the following tools: - SAS - SPSS - R - Python - Power BI - Tableau - SQL - MS Excel - MS Access
$41 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I've been part of few projects related to API. I'm able to build them, I'm able to build solution consuming API data. So that's basicly the thing you require. Few words about me: I have been working as developer, business-system analyst and project manager. Building custom made solutions is what I love and I'm good at. I hire other developers if needed, so I'm able to double or triple working capacity. My skills: Web Development - Front-end Angular 4/5/6, AngularJS - Back-end Python/Django/Flask, PHP/Laravel/CodeIgniter, Node.js, MySQL, PostgreSQL, MongoDB, Redis, - Cloud Services Serverless Architecture, AWS, Firebase, Azure, Google Cloud, DigitalOcean I am able to offer competitive prices and add value to the projects with my experience . I can dedicate more than 40hrs/week to your project and working hours are flexible. Please contact me to make your project successful. Best Regards.
$30 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear employer, I believe my professional abilities and knowledge encompass the skill set you require: * ETL and KPI tracking experience: previous data specialist in a global education company * Excellent SQL / Excel / Tableau / Looker skills * Strong marketing and analytical mindset, keen eyes on details Look forward to discussing the opportunity. Best regards, Yang LIU
$41 AUD in 30 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Melbourne, Australia
4.9
5
Payment method verified
Member since Mar 7, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.