Olia Burnaeva

- conceptualized and developed the PCF Rate, the first company-wide metric for quantifying perceived counterfeit prevalence on the marketplace, by building a Spark-based LLM scoring pipeline that analyzed highly visible listings using counterfeit classification prompts developed in collaboration with counterfeits experts - evaluated counterfeit risks across marketplace categories to identify vulnerable segments, detect emerging counterfeit trends, prioritize enforcement efforts, and measure the effectivenes

- designed and implemented analytical data marts and pipelines using PostgreSQL, dbt, Airflow, and Python, creating reusable data models that supported reliable reporting and self-service analytics - optimized analytical queries and data models to improve dashboards performance - identified and investigated data quality incidents end-to-end, performed root-cause analysis, and partnered with backend developers to improve the reliability and consistency of transactional data - developed self-service dashboard

- conceptualized and developed a new project focused on collecting and analyzing search queries from URL clickstream and accessibility technology, creating a new revenue stream and attracting high-profile clients - investigated new single-source media data (TV, Radio, Mobile), highlighted its strengths and limitations, and presented recommendations that helped shape the company's long-term product strategy - conducted quantitative research on media and digital consumer behavior using descriptive analysis in

- ensured data quality and conducted integrity checks across newly developed data warehouse layers during the migration of legacy processes to a Hadoop-based Big Data platform - designed real-time monitoring dashboards with Grafana to monitor data processing and pipeline health - orchestrated workflows in Airflow, diagnosed task failures, and developed custom Python tasks for integrating with internal service APIs - gathered business requirements, translated them into technical specifications, maintained do

- conducted quantitative research into television audience behavior, investigating trend breaks, emerging trends, audience migration, and loyal audience segments - advised clients on audience measurement methodologies, project design, metric interpretation, and data-driven decision making - used industry-standard statistical software, including Instar Analytics and proprietary analytical tools, to conduct media research and client analysis - translated analytical findings into clear reports, executive-ready

- performed account reconciliation across multiple ledgers, identifying and resolving discrepancies to ensure accurate financial reporting - executed accounting entries in accordance with internal financial controls and reporting standards - conducted business correspondence in english with international contractors, coordinating documentation and resolving billing and payment queries