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