Renata Cabral

• Manage the team's PostgreSQL database
• Create and maintain data pipelines for tasks automation with Python
• Bring the latest technologies to the team by proving valuable and cost-effective to the business
• Provide training to analysts in order to level up skills across the team
• Manage projects that require software development from the Development team
• Manage requests from stakeholders and set up expectations

• Data Management:
  • maintain the team's PostgreSQL database alongside the IT team
  • manage and set up ETL processes
  • create new tables and views according to new projects and requests
  • automate tasks using Python
  • ensure the use of a version control system (BitBucket)
• Business Intelligence:
  • create and maintain dashboards using Google Data Studio and PowerBI for stakeholders
  • explore new solutions for data visualisation like Plotly, Dash, Apache Superset, Grafana
• Digital Marketing: 
  • manage digital marketing campaigns on Amazon
  • analyse variables that affect their performance and make changes accordingly
• User Needs:
  • meet stakeholders, understand their needs and gather user stories to convert into doable projects
• Training:
  • train the team to enhance and even up technical skills, like Python, Bash scripting and Git 

• Query data from MSSQL database to provide customers insights (sales, demographics, marketing campaigns);
• Set up and manage communications sent via email to customers using a multi-channel campaign management software: PeopleStage;
• Analyse marketing campaign results and report it in presentation and dashboards;
• Ensure campaigns are running correctly, and automated processes are working on the schedule
• Create sales activity dashboards on Dundas BI and Dundas Dashboard
• Manage and update client's business strategic plan to guide stakeholders through the usability of data

• Analyse customer trends by tracking several economic indexes, i.e. broadband usage, lecture index, GDP;
• Responsible for the internal database by importing, mining and cleaning the latest trade data;
• Build guidance reports for the executive team with strategic recommendations and insights obtained from all data sources available;
• Create reports providing sales insights to stakeholders  e.g. Price Index report to track retail prices across all markets and compare them against each other, similar to Big Mac Index

• Support the sales team in daily tasks, providing analysis and information about prices and sales figures;
• Request hierarchical approval of price exceptions from all levels;
• Update the main sales report according to sales forecast numbers set by account managers, such as prices and volumes;
• Boost team efficiency: create new procedures to control sales’ prices to bids, avoiding wrong prices and ensuring high profitability.

Modules included: Econometrics, Statistics, Economic World History, Economic Brazilian History, Mathematics, Accountancy, Economic Development, Macroeconomics, Microeconomics and International Economics.