JR Data Analyst (Business Planning)

The Commercial Planning area of ​​MadeiraMadeira is an area that constantly uses and collects data, in order to make analyses, reports, projections and support decisions. We work interdepartmental, working together with sales teams, channels, categories, and having a great interface with the FP&A and Operations areas. Due to this cross-functional performance, it is an area that is constantly concerned with process modeling, which requires good communication and excellent interpersonal relationships.

 

As we are in an age of data, the main challenge of the opportunity is to translate data into relevant information, supporting better decision-making by sales teams, channels and categories. This position will create, develop and update various reports and dashboards, as well as external data integrations, used to identify market opportunities and increase competitive advantage.

 

MAIN RESPONSIBILITIES

 

The main challenges, day to day responsibilities of this position are:

• Identify and specify problems in MM's business areas that can be answered with data.
• Create data visualizations and make data available to the business areas used for decision making.
• Develop, maintain and optimize dashboards, data analysis and script automations of low to medium complexity.
• Build datasets - cubes and datamarts.
• Support the creation and maintenance of data pipelines that will be used to answer business questions, serve as Dashboard datasets.
• Integrate and process data from different sources to generate insights for the business;
• To be the bridge between the business area and the technology area.
• Understand and monitor processes carried out by the business area to assist in the creation, maintenance and delivery of solutions with the technical teams.

 

REQUIREMENTS AND SKILLS

 

Behavioral skills:

• Problem Solving > Logical ability to solve problems with effective solutions, able to investigate potential sources for answers.

 

• Analytical Capacity > Ability to analyze situations and information, discriminating and interpreting factors impartially, performing critical and conclusive assessment, pointing out directions to support decision making.

 

• Assertiveness > Act with determination and security, providing services and information with precision and certainty.

 

• Numerical reasoning > Ease, speed and accuracy to work with numbers, calculations and formulas.

 

• Focused Attention > Ability to maintain attention to details in activities, applying thought in an intense and exclusive way, even in adverse situations, avoiding rework.

 

 Technical skills:

• Practical experience in SQL of at least 2 years (DDL,DML,DCL), example: MySQL, Presto, PostgreSQL.
• Hands-on experience using BI tools (Looker, Tableau, PowerBI, etc.). Giving priority to the Looker tool.
• Basic knowledge of data storage patterns and modeling: relational and non-relational. 
• Knowledge and experience in ETL/ELT processes.
• Basic knowledge of cloud platforms (preferably AWS platform)
• Knowledge of Python programming language for Data Analysis.
• Basic knowledge of statistics. 
• Advanced Excel

 

Training:

• Completed higher education in Systems Analysis, Computer Science, Information Systems or related areas.
• Postgraduate degree will be an advantage

 

Desirable

• E-commerce/Marketplace experience

 

ADDITIONAL INFORMATION

 

Benefits:

• Meal and Food Stamps by Flash Benefits
• Gympass;
• Unimed Nacional health plan (no co-payment);
• Dental plan Amil Dental (no co-payment);
• Prudential Life Insurance .

 

Facilities that only MadeiraMadeira offers you:

 

• Monthly subsidy for electricity and internet allowance (for those who are at home office during the pandemic)
• Program of advantages with discounts in establishments;
• Agreement with universities and schools of different courses;
• No dress code (except safety PPE);
• Semi-flexible hours;
• Personal Orientation Program;

 

Principles that we hope to see in the day to day of #MadeiraLover

 

Here at MadeiraMadeira and in all the companies in the group, we have principles that we must follow with discipline and consistency, ensuring that our purpose is fulfilled. We are #protagonists of our achievements and #leaders of our destiny. 

 

 

• We are customer obsessed
• Team First , always!
• We build, develop and maintain a high performance team
• We have clear goals
• We are a resilient team
• We work with agility in execution
• We Have Curiosity, Nonconformity and Attitude
• We Innovate and Simplify
• We do more with less
• Permanent Communication takes us further
• We deliver amazingly consistent results
• We gain credibility and conquer our space

 

🌈 Diversity, Inclusion and Belonging 🌈

 

We are more than 2000 people who add up the differences to multiply: multiplying a +diverse, +welcoming, +creative and +fair environment.

 

We value the different possibilities of being and thinking. That's why we created Sommar , our diversity, inclusion and belonging program.

 

This is our delivery to a better society, company and people.

 

We are more than a company: we are agents of transformation, innovation and change. #Let's Summar?

 

All our opportunities are open to people with disabilities (PWD) ♿

 

REVOLUTIONING THE WAY PEOPLE SET UP THEIR HOME IS OUR PURPOSE, AND YOURS?