Data Analyst (TE)

REMOTE

This Data analyst role is to help make media buying and operations life easier by looking at existing reports and digging into data from our database. Using data to create adhoc reports in both SQL and visualization tools.

Daily activities could include:

Advance SQL skills writing clean and composable code using CTE and window functions.

Format reporting in excel and merge data from multiple datasets with vlookup and other advanced excel functions.

Write ad hoc sql multiple table join queries to get data (mysql and big query but any sql rmdbs works)

Manually pull data from web portals

Check reports to look for outliers and inconsistencies

Ongoing activities:

Give suggestions on ways to increase revenue or decrease costs from data.

Writing documentation on queries written.

Requirements:

4+ years SQL (MySQL or similar)

4+ years of excel

2 years of google data studio, tableau, looker or similar

Experience with JSON and CSV

Python or other programming experience

Git experience

Nice to have:

DBT experience