Key responsibilities: • Data analysis, data quality analysis, data processing. • Data analysis - ad hoc requests. • Working on database development (SQL, Python). • (Data Analyst May-Jan, Data Scientist Jan-present.) Key achievements: • Processed and analysed over 1000 files (SPSS, SQL, Python). • Delivered ad hoc data analysis on time (SPSS). • Helped to translate SPSS script into Python, the new script is used during ETL. • Developed a Python script for data quality analysis.

GfK | Nov 2018 - Apr 2022

Client Delivery Analyst

Key responsibilities: • Data analysis - ad hoc requests, changes in regular data analysis - point of sale data (POS). • Data standardisation projects, analysis for structural changes in an internal database. • Data quality analysis of POS data. • Data visualisation. • Collaboration with global team, training and training materials for new joiners. Key achievements: • Delivered ~1000 ad-hoc data analysis reports on time (internal software - PPT, Excel). • Led a project caused by covid restrictions to investigate and change ~2000 data analysis reports (internal software, SQL). Erika Jarochova Page | 2 of 2 • Developed a macro for data quality analysis in VBA. • Created documentation - data security, data quality analysis, internal software.

PwC | Jan 2017 - Sep 2018

Assurance Specialist

Key responsibilities: • Working with data - data loading to internal software / data remediation / automation / quality control / data analysis / data visualisation / disclosure reports. • Disclosure of payments from two of our clients (pharmaceutical or medical devices companies) to healthcare professionals and healthcare organisations in most of the European countries by EFPIA, MedTech, or local law rules. • Collaboration with the global team, communication with clients. • Collaboration with an internal IT team – finding issues within internal software / creation of business requirements/ testing. • Creation of documentation with EFPIA, MedTech, and local regulatory requirements. Key achievements: • Delivered reports for all EFPIA countries for one client on time. • Led a team of six colleagues to complete a vendor management project. • Developed macros in VBA - data quality analysis, matching new data with current database. • Helped to set up an internal software for a new client, and assisted development of business requirements for testing.

Ceska Sporitelna | Aug 2015 - Apr 2016

Market Data Analyst (p/t)

Key responsibilities: • Quantitative surveys and qualitative research data analyst for internal clients. • Working with huge data sets, data cleaning and reconciliation. • Quantitative and qualitative data analysis in Excel and SPSS. • Data visualization, presenting results. Key achievements: • Led and executed an online internal survey about employee satisfaction – sample, coding of questionnaire, analysis of results, final presentation. • Worked with external agency to deliver end of year client satisfaction report. • Helped to execute and deliver results for ~50 internal surveys. • Developed Excel with formulas for data cleaning for text analysis.

My Education

Take a look at my formal education

Master's in SociologyCharles University | 2017

About Me

Highly capable and ambitious Data Analyst with 9 years’ experience across a range of business sectors. An enthusiastic, adaptable professional with a track record in data analysis, process improvement, automation, and problem solving.

Create Your Data Portfolio for Free