Call: Consultant in statistics and data analytics

4 minutes

By Libelula hace 5 year

views

Type of contract:	Consulting
Work modality	Remote work
Location:	Lima, Peru
Estimated start date:	January 2021
Duration:	3 months
Supervisors	Tina Chávez (Deputy Manager of Communications) and Pablo Santillán (Knowledge Management Coordination)

1. Who we are

Libelula is a consulting firm with more than 13 years of experience in sustainability and climate change issues at national and international level. We are a B company that seeks to generate a positive impact on society, providing technical, political and communicational consulting to private companies and the public sector, generating communities of change, networking and connection platforms for scaled action, such as Generation +1, nexos+1, and 1000 million+ that bring together diverse actors and communities; and implementing communication strategies that contribute to the dissemination of sustainability actions and help to change society's awareness. Our vision is ambitious: we want a world with 0 poverty, 0 waste, 0 net CO₂ and 100% regenerated ecosystems.

2. Required profile

We are looking for a professional in statistics or data analysis and with proven training or experience in:

Reporting, database integration and data analytics from Facebook, LinkedIn, Instagram and Twitter.
Database management.
Multiyear (and prospective) reporting with Power Bi, R or Tableau
Experience in segmentation, clustering and data visualization is preferred.
Knowledge of relational and non-relational databases.
Soft skills: Analytical and critical thinking skills, Talent in communication and teamwork.

3. Purpose and description of the consultancy

Libélula is developing its institutional strategy for data management and annual impact reporting, for which it requires a consultant to support the process, under the coordination of the sub-manager of Communications Projects, and the Communications area team with the support of the Knowledge Management area.

Activities

The consultant will integrate and align the data entry forms used in the social networks of Libellula's platforms and projects.
In PowerBi dashboards and in coordination with the corresponding areas, the consultant will generate data models, reports and projections to understand the communicational impact of social networks, for the subsequent analysis and generation of year-end conclusions.
The consultant will provide recommendations for the management of structured and unstructured data from social networks, platforms and projects; including recommendations for the treatment of personal data.
The consultant collects information, analyzes the data and generates a consumer behavior profile of the content of our social networks, platform and projects.

4. Deliverables and form of payment

Deliverable	Description	Estimated date	% Payment
Unified database	The consultant will integrate the databases of the social networks, platforms and Libellula projects into a single database, with a format and software agreed with the contractor.	29-Jan-2020	40%
Data visualization	The consultant will incorporate the findings of the information from our database into Power Bi Dashboards, which can be updated automatically. ● Generation of data dashboards in Power Bi, with multi-year analytics of the social networks of Libellula's platforms.	19-Feb-2020	20%
Consumer profile	The consultant will generate a sociodemographic profile of the sustainable digital consumer and their behavior in relation to the contents of our social networks, platforms and projects. ● Generation of a demographic data report (profile of users or "personas") contrasted among the different sources. ● Generation of a profile of the sustainable digital consumer private sector.	Mar 19, 2020	20%
Technical proposal	The consultant will present his/her proposal to strengthen Libélula's data management strategy (structured and unstructured).	Mar 26, 2020	20%