Toronto Employment Platform

Marketing Data Analyst / SQL Analyst

About the Data Analyst / SQL Analyst position

We are looking for a skilled Data Analyst / SQL Analyst who will help us analyze large amounts of raw information to find patterns and use them to optimize our performance. You will work with PostgreSQL databases, writing queries and generating analysis to manage and optimize our marketing platform.

We expect you to be highly analytical with a knack for analysis, math and statistics, and a passion for data analysis and business. Critical thinking and problem-solving skills are also required.

While knowledge of AdWords is not required, it will be an asset. We will also provide AdWords training immediately upon start.

The Details:
Write various queries using SQL to analyze and interpret data from AdWords and our marketing platform

Manage, write and use stored procedures (PL/pgSQL) to create, optimize, and edit marketing data structures (in AdWords)

Research and detect valuable data sources and automate collection processes

Perform preprocessing of structured and unstructured data

Review large amounts of information to discover trends and patterns

Create and optimize statistical models / machine learning models which automate our marketing products

Organize and present information using data visualization techniques

Directly implement models and algorithms into our existing proprietary advertising management system for our client’s brands

Experience requirements are:
2+ years’ experience of working as a Data Scientist or Data Analyst

Excellent knowledge of SQL (we use PostgreSQL) and Git

Knowledge of Git and experience in working with IDEs such as PyCharm / Datagrip

Good experience using business intelligence tools (such as Tableau)

Excellent knowledge of SQL (we use PostgreSQL) and Python

Strong math and analytical skills, with business acumen

Strong communication and presentation skills

Good problem-solving abilities

An interest in machine learning is an asset

Only candidates can apply for this job.
Share this job

About Us

Talent Portal is a Toronto-based Job Board and Employment Platform. We are dedicated at helping talents reach their dream career.Candidates can search for jobs and set job alerts to receive new job notifications via email; Employers can post jobs online, and receive applications via email. It is free for both employees and employers.

Company Search

Social Networks