Data Analyst

Location: Hybrid — Warsaw, Poland

Employment Type: Full-time

About the Company

Media Miami is an independent performance marketing agency focused on building and scaling digital products.

Our core expertise lies in developing and growing media ecosystems for global audiences, with a strong focus on the U.S. market. We operate across key verticals, including finance, health, self-development, and astrology — delivering relevant insights, practical value, and highly engaging experiences.

Role Overview

We are looking for a Junior Data Analyst to support our growing analytics operations. This is a hands-on supporting role — you will work under close mentorship of our Senior Data Analyst and focus on data quality, dashboard maintenance, and repetitive operational tasks that keep our analytics stack running smoothly.

You will not be designing systems from scratch — instead, you will execute well-defined tasks that free up senior time for architecture and strategy. This is a great entry point for someone who wants to grow into a mid/senior data role while learning ClickHouse, n8n, and Looker Studio in production.

Key Responsibilities

Data quality & dictionaries

• Maintain and enrich lookup dictionaries (offer aliases, partner breakdowns, blog metadata, sub-code mappings) in ClickHouse
• Regularly review distinct values in raw source tables to identify new offers, partners, and creatives that need mapping
• Perform data deduplication on dictionary tables and clean up anomalies
• Cross-check trackers vs affiliate network postbacks to identify missing configurations

Dashboards in Looker Studio

• Build new dashboards on top of existing ClickHouse views based on stakeholder requests
• Update and maintain existing dashboards: fix broken charts, add new fields, adjust filters
• Configure Row-Level Security (RLS) via Filter-by-Email for new users
• Onboard new users (broadcasters, marketologists) — provision access, verify their view is correct

Operational data tasks

• Execute SQL migrations following documented patterns (temp-table workflows, EXCHANGE TABLES) under supervision
• Update Metadata for changes in broadcaster/marketolog assignments and pause statuses
• Investigate data discrepancies flagged by team members (why a blog shows no revenue, why a chart looks off)

Documentation & communication

• Keep internal analytics documentation up to date as the schema evolves
• Respond to ad-hoc data questions from broadcasters and marketologists in Slack

• Log completed tasks and share progress in weekly syncs

   

Requirements

Must Have

• 1+ year of hands-on experience with SQL (any dialect — PostgreSQL, MySQL, BigQuery, ClickHouse)
• Understanding of basic SQL concepts: JOINs, aggregations, window functions, CTEs
• Experience with at least one BI tool (Looker Studio, Tableau, Power BI, Metabase, Superset)
• Strong attention to detail — you notice when numbers look off
• Ability to follow documented step-by-step procedures precisely
• Comfortable communicating in English (written) and Russian (spoken) — team is Russian-speaking, tools and documentation are in English
• Willingness to ask questions rather than guess when unsure
  
   

Nice To Have

• Experience with ClickHouse specifically (or exposure to columnar databases)
• Familiarity with Looker Studio calculated fields, filters, and data blending
• Basic understanding of n8n or similar low-code automation tools
• Experience in affiliate marketing, ad tech, or e-commerce analytics
• Understanding of tracking platforms (Everflow, RedTrack, Keitaro, Voluum)
• Basic Python or JavaScript for scripting simple data tasks

• Understanding of ETL concepts and data pipelines

   

Who We're Looking For

We are looking for someone who:

• Is proactive and takes ownership
• Thinks commercially and solves problems independently
• Builds strong relationships with internal and external stakeholders
• Thrives in a fast-paced environment
• Pays close attention to detail
• Is eager to grow alongside the company

What We Offer

Professional Growth
 

• Direct mentorship from Senior Data Analyst — pair on complex tasks, code reviews on your work
• Exposure to a modern, production-grade analytics stack: ClickHouse Cloud, n8n,Airflow,  Looker Studio, MCP integrations
• Real ownership of maintenance and dashboard-building tasks from day one
• Clear path to Mid Analyst role as scope grows

Benefits

• Competitive salary
• Paid vacation days
• Paid sick leave days
• Work-life balance
• Team events and activities
   

Working Environment

• Remote / Hybrid / Modern office in Poland
• Complimentary snacks, drinks, and office perks
• Friendly and supportive team

• Comfortable workspace

   

We look forward to meeting you!