Social Media Analyst  

Main responsibilities:

• Plan the analysis process: plan reports and establish the data and cross-data needed to be included.
• Identifying objects, actions, and events - Identifying information by categorizing, estimating, recognizing differences or similarities, and detecting changes in circumstances or events.
• Produce reports based on number’s facts generating insights and actions plans.
• Analyzing data or information - Identifying the underlying principles, reasons, or facts of information by breaking down information or data into separate parts.
• Updating and using relevant knowledge - Keeping up-to-date technically and applying new knowledge to your job.
• Interacting with computers - Using computers and computer systems (including hardware and software) to run programs, set up functions, enter data, or process information.
• Resolving conflicts and negotiating with others - Handling complaints, settling disputes, and resolving grievances and conflicts, or otherwise negotiating with others.
• Establishing and maintaining interpersonal relationships - developing constructive and cooperative working relationships with others, and maintaining them over time.

DATA MANAGEMENT

• Writing Boolean queries on social listening tools (e.g. Sysomos, Brandwatch, etc.)
• Extracting data from social listening tools and social media analytics tools (e.g. quintly, SocialBakers, Brandwatch, etc.)
• Refining and tabulating data on Excel via PivotTables and other relevant functions
• Standardizing conventions (e.g. file naming, format, etc.)

DATA TABULATION

• Visualizing tabulated data via charts and graphs

ANALYSIS AND CORRELATION

• Understanding campaign objectives and determining the right metrics and KPIs to evaluate
• Recognizing trends/patterns and 'outliers' on visualized data
• Establishing relationships among different data points

COORDINATION WITH INTERNAL TEAMS

• Supply necessary information for the campaign, planning, research, and other internal teams as needed
• Create ad hoc studies that can help improve the output of Cheil (such as but not limited to, campaign performance, retail studies, etc)

• Bachelor’s Degree in Computer Sciences/Systems/Statistic/Economy.
• 5 year of experience in data analysis.
• Analytical Skills: Data analysts work with large amounts of data: facts, figures, and number crunching. You will need to see through the data and analyze it to find conclusions.
• General computer skills: familiarity working with network directory structures and ability to learn new software applications easily
• Communication Skills: Ability to translate the data into an understandable document. Need to write and speak clearly, easily communicating complex ideas.
• Critical Thinking: Data analysts must look at the numbers, trends, and data and come to new conclusions based on the findings.
• Attention to Detail: Data is precise. Data analysts have to make sure they are vigilant in their analysis to come to correct conclusions.
• Math Skills: Data analysts need math skills to estimate numerical data.
• Training Skills: Ability to train fieldwork about data to be collected.
• Organization & control – ability to track multiples sources of information and consolidate data.
• Fieldwork abilities: Ability to be consistent and thorough when checking and preparing data, as well as in daily tasks
• Advance knowledge of Microsoft Office skills, particularly Microsoft Excel and PowerPoint.
• Must be proficient with using macro and developer in MS Excel
• Able to perform routine tasks for an extended period of time.
• Troubleshooting skills.
• Strong analytical and interpretive skills.
• Detail oriented.
• Ability to grasp new concepts quickly and easily.
• Excellent organization skills are required.
• Consciousness for prompt completion of work tasks.
• Professional appearance.
• Demonstrated ability to adapt to changing demands and situations.
• Demonstrated consistent work history and commitment level.