KN

Open to opportunities

Kseniia Novikova

@kseniianovikova

Marketing analytics specialist driving data-led marketing decisions with SQL, Python and dashboarding expertise.

What I'm looking for

I am looking for a data-driven role where I can use SQL, Python and dashboarding to inform marketing decisions, collaborate cross-functionally, and drive measurable growth.

I am a marketing analytics specialist with 4+ years of experience translating high-volume digital data into actionable insights for marketing stakeholders. I specialize in SQL- and Python-driven analysis, dashboard development, and performance reporting across paid, CRM and organic channels.

At S7 Airlines I analysed marketing performance across CRM, paid media, affiliate networks and organic channels, conducted funnel and cohort analysis, and monitored acquisition across web and mobile platforms, handling millions of interactions and hundreds of thousands of transactions.

I build Tableau dashboards and analytical data views to support recurring KPI reporting and campaign monitoring, and I analyse marketing experiments and A/B tests to identify message variants that drive stronger engagement and ROMI.

Earlier in my career I worked in auditing roles where I evaluated processes, led fieldwork teams and analysed financial statements, bringing strong attention to data quality, controls and clear stakeholder communication to my analytics practice.

Experience

Work history, roles, and key accomplishments

SA

Current

Marketing Analyst

Current

S7 Airlines

Jan 2022 - Present (4 years 2 months)

Performed SQL- and Python-driven analysis of CRM, paid media, affiliate and organic channels to track KPIs and ROMI, built Tableau dashboards, and delivered funnel and cohort insights that informed marketing decisions and campaign optimisation.

SQL Python Tableau Marketing Analytics Cohort Analysis A B Testing CRM Analytics Performance Channels KPIs

ME

Internal Auditor

MegaFon

Sep 2015 - Sep 2017 (2 years)

Evaluated internal business processes across B2C and B2B sales and technical operations to ensure compliance with policies and regulations, identifying inefficiencies and recommending controls to improve operational compliance.

Internal Audit & Compliance Process Improvement Risk Assessment Report Writing

MS

Auditor

Moore ST

Jun 2008 - Sep 2013 (5 years 3 months)

Led audit fieldwork and analysed financial statements for clients in aviation, telecom, IT, forestry and manufacturing using Excel-based tools, coordinating teams and supporting IFRS-compliant audit reporting.

Financial Analysis Fieldwork IFRS Excel Team Leadership Client Communication Audit Reporting

Education

Degrees, certifications, and relevant coursework

TW

The Institute of Chartered Accountants in England and Wales

Associate Chartered Accountant, Accounting

Completed the Associate Chartered Accountant qualification awarded by ICAEW in 2016.

NU

Novosibirsk State University

Specialist, Management

Completed a Specialist degree in Management at Novosibirsk State University, focusing on management principles and organisational practice.

Tech stack

Software and tools used professionally

Gmail

iOS

SQL

Remote

Find your dream job

Sign up now and join over 100,000 remote workers who receive personalized job alerts, curated job matches, and more for free!