Data analyst role will assist in monitoring existing reports, query our data warehouse (bigquery) for ad hoc requests, and writing code to get data out of api endpoints.

Daily activities could include:

Write clean and composable SQL code using CTE and window functions.
Create python code to pull data from api rest apis.
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 bigquery but any sql rmdbs works)
Check reports to look for outliers and inconsistencies
Monitor and update looker dashboards.

Ongoing activities:

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

Writing documentation on queries written.

Soft Skills:

Understand the day-to-day issues that our business faces, which can be better understood with data
Compile and analyze data related to business' issues
Develop clear visualizations to convey complicated data in a straightforward fashion

Technical Skills:

2+ years SQL (MySQL or similar)
4+ years of excel
2 years of visualization tooling (Looker preferred)
Experience with JSON and CSV
Python or other programming experience
Git experience

Nice to Have:

Prefect
Looker experience
DBT experience

Tort Experts jobs

Data Analyst