Operational Analyst at ClickOut Media – Remote

Big Data Analytics
January 8, 2025
Full Time
Apply Now

Job Description

About Us:
ClickOut Media is not just a company – it’s a thriving ecosystem of diverse talent from around the globe. As a proudly remote-first organisation, we’ve cultivated an environment where creativity flourishes, collaboration is core, and innovation knows no bounds. With over +850 team members and more than 200 assets, our startup culture fuels our growth, making us a leading force in multi-channel marketing. We specialise in delivering best-in-class SEO & Content solutions to esteemed clients worldwide.

Role
We are looking for an Operational Analyst that will be responsible for the accuracy
of our reporting as well as have in-depth knowledge of our stats database to serve the business with needed analytical data

Core Tasks

  • Be responsible for the health of our stats
  • Do analytical work on our Stats across all verticals
  • Graph, forecasts, analysis for all business verticals
  • Champion our Stats accuracy, attribution and health in DashFX

Essential Requirements

  • Must be able to Graph, Forecast and report in-depth across multiple
    verticals in a Tabular or Visual manner
  • Must have knowledge of Gambling Analytics
Strong SQL Skills
  • Understanding of Joins: Ability to use different types of joins (e.g., INNER
  • JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN) to combine data from
    multiple tables effectively.
  • Filtering and Conditions: Mastery of the WHERE clause, logical operators
    (AND, OR, NOT), and conditional expressions (e.g., CASE statements) for
    refining query results
  • Aggregate Functions: Proficiency with functions like COUNT(), SUM(), AVG(), MIN(), and MAX() to perform calculations on grouped data.
  • Grouping and Ordering: Knowledge of GROUP BY and ORDER BY clauses for organizing data and summarizing reports.
  • Subqueries and Common Table Expressions (CTEs): Ability to write nested queries or reusable subqueries using CTEs to simplify complex report generation.

Nice to have Requirements

  • Knowledge of Crypto and Presales
  • Knowledge of Affiliate and Affiliate networks
  • General technical knowledge over and above the mandatory,
  • including any automation

Ideal Person

  • A self-starting go-getting who lives and breathes stats and analytics
  • very pro-active and a positive person. Detail orientated and
  • understanding the weight of responsibility championing stats has
  • in a company our size
  • Does not mind being contacted out of hours or emergencies

Related Jobs