Structure databases containing media execution information, monitoring and forecasting of market metrics, and investment analyses by category/market segment.
Data validation and Quality Assurance (QA).
Manage information submitted to audits contracted by clients and external consultants.
Participate in defining project scope with internal teams and other departments.
Contribute to measurement plans.
Develop reports in database format.
Taxonomy management (maintaining rules and delivering training).
Develop dashboards in Power BI (recommended).
Develop report automations (recommended).
Exploratory Web Analytics analysis (recommended).
Gather and document requirements for data lakes and dashboards (recommended).

Solid experience in BI/data/technology/web analytics at advertising agencies, publishers, or areas related to digital marketing or technology.
Conceptual knowledge of market tools (media platforms, web analytics, spreadsheets, and data visualization).
Ability to produce clear and consistent data visualizations.
Intermediate Google Sheets/Excel (knowledge of conditional, array, and nested formulas; importing data from external sources; familiarity with Power Query; experience automating files for internal stakeholders who are not Excel-proficient).
Experience with digital media, ad servers, and web analytics.
Taxonomy logic and parameterization of digital campaigns.
Concepts of digital marketing and media.
Deep knowledge of digital media metrics.
Knowledge of financial and media performance analysis.
Task management tools (Trello, Jira, Hive or equivalents).
Intermediate English.
Agile methodologies: desirable.

Accountability Analyst

Key skills