JR Data Analyst (Business Planning)

<div class="content-intro"><p><em>*** This is where your organization can create a consistent intro to all of your jobs, creating consistency in voice and messaging across all job posts</em></p> <p><em>*** C'est ici que votre organisation peut créer une introduction cohérente à tous vos emplois, en créant une cohérence dans la voix et la messagerie dans tous les postes.<br></em></p></div><p><span><img src="https://s3.amazonaws.com/gupy5/production/companies/336/images/jobs/1276871/20220503050500124_picture.png" alt="" width="990" style="max-width: 100%;"></span></p> <p><span>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.&nbsp;We work interdepartmental, working together with sales teams, channels, categories, and having a great interface with the FP&amp;A and Operations areas.&nbsp;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.</span></p> <p>&nbsp;</p> <p><span>As we are in an age of data,&nbsp;</span><strong><span>the main challenge of the opportunity&nbsp;</span></strong><span>is to translate data into relevant information, supporting better decision-making by sales teams, channels and categories.&nbsp;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.</span></p> <p>&nbsp;</p> <h2><span>MAIN RESPONSIBILITIES</span></h2> <p>&nbsp;</p> <p><strong><span>The main challenges, day to day responsibilities of this position are:</span></strong></p> <ul> <li><span>Identify and specify problems in MM's business areas that can be answered with data.</span></li> <li><span>Create data visualizations and make data available to the business areas used for decision making.</span></li> <li><span>Develop, maintain and optimize dashboards, data analysis and script automations of low to medium complexity.</span></li> <li><span>Build datasets - cubes and datamarts.</span></li> <li><span>Support the creation and maintenance of data pipelines that will be used to answer business questions, serve as Dashboard datasets.</span></li> <li><span>Integrate and process data from different sources to generate insights for the business;</span></li> <li><span>To be the bridge between the business area and the technology area.</span></li> <li><span>Understand and monitor processes carried out by the business area to assist in the creation, maintenance and delivery of solutions with the technical teams.</span></li> </ul> <p>&nbsp;</p> <h2><span>REQUIREMENTS AND SKILLS</span></h2> <p>&nbsp;</p> <p><strong><span>Behavioral skills:</span></strong></p> <ul> <li><span>Problem Solving &gt; Logical ability to solve problems with effective solutions, able to investigate potential sources for answers.</span></li> </ul> <p>&nbsp;</p> <ul> <li><span>Analytical Capacity &gt; Ability to analyze situations and information, discriminating and interpreting factors impartially, performing critical and conclusive assessment, pointing out directions to support decision making.</span></li> </ul> <p>&nbsp;</p> <ul> <li><span>Assertiveness &gt; Act with determination and security, providing services and information with precision and certainty.</span></li> </ul> <p>&nbsp;</p> <ul> <li><span>Numerical reasoning &gt; Ease, speed and accuracy to work with numbers, calculations and formulas.</span></li> </ul> <p>&nbsp;</p> <ul> <li><span>Focused Attention &gt; Ability to maintain attention to details in activities, applying thought in an intense and exclusive way, even in adverse situations, avoiding rework.</span></li> </ul> <p><strong>&nbsp;</strong></p> <p>&nbsp;<strong><span>Technical skills:</span></strong></p> <ul> <li><span>Practical experience in SQL of at least 2 years (DDL,DML,DCL), example: MySQL, Presto, PostgreSQL.</span></li> <li><span>Hands-on experience using BI tools (Looker, Tableau, PowerBI, etc.).&nbsp;Giving priority to the Looker tool.</span></li> <li><span>Basic knowledge of data storage patterns and modeling: relational and non-relational.&nbsp;</span></li> <li><span>Knowledge and experience in ETL/ELT processes.</span></li> <li><span>Basic knowledge of cloud platforms (preferably AWS platform)</span></li> <li><span>Knowledge of Python programming language for Data Analysis.</span></li> <li><span>Basic knowledge of statistics.&nbsp;</span></li> <li><span>Advanced Excel</span></li> </ul> <p>&nbsp;</p> <p><strong><span>Training:</span></strong></p> <ul> <li><span>Completed higher education in Systems Analysis, Computer Science, Information Systems or related areas.</span></li> <li><span>Postgraduate degree will be an advantage</span></li> </ul> <p>&nbsp;</p> <p><strong><span>Desirable</span></strong></p> <ul> <li><span>E-commerce/Marketplace experience</span></li> </ul> <p>&nbsp;</p> <h2><span>ADDITIONAL INFORMATION</span></h2> <p>&nbsp;</p> <p><strong><span>Benefits:</span></strong></p> <ul> <li><span>Meal and Food Stamps by Flash Benefits</span></li> <li><span>Gympass;</span></li> <li><span>Unimed Nacional health plan (no co-payment);</span></li> <li><span>Dental plan Amil Dental (no co-payment);</span></li> <li><strong><span>Prudential&nbsp;</span></strong><span>Life Insurance&nbsp;</span><span>.</span></li> </ul> <p>&nbsp;</p> <p><strong><span>Facilities that only MadeiraMadeira offers you:</span></strong></p> <p>&nbsp;</p> <ul> <li><span>Monthly subsidy for electricity and internet allowance (for those who are at home office during the pandemic)</span></li> <li><span>Program of advantages with discounts in establishments;</span></li> <li><span>Agreement with universities and schools of different courses;</span></li> <li><span>No dress code (except safety PPE);</span></li> <li><span>Semi-flexible hours;</span></li> <li><span>Personal Orientation Program;</span></li> </ul> <p>&nbsp;</p> <p><strong><span>Principles that we hope to see in the day to day of #MadeiraLover</span></strong></p> <p>&nbsp;</p> <p><span>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.&nbsp;We are #protagonists of our achievements and #leaders of our destiny.&nbsp;</span></p> <p>&nbsp;</p> <p>&nbsp;</p> <ul> <li><span>We&nbsp;</span><strong><span>are customer obsessed</span></strong></li> <li><strong><span>Team First&nbsp;</span></strong><span>, always!</span></li> <li><strong><span>We build, develop and maintain a high performance team</span></strong></li> <li><span>We have&nbsp;</span><strong><span>clear goals</span></strong></li> <li><span>We are a&nbsp;</span><strong><span>resilient team</span></strong></li> <li><span>We work with&nbsp;</span><strong><span>agility in execution</span></strong></li> <li><span>We Have&nbsp;</span><strong><span>Curiosity, Nonconformity and Attitude</span></strong></li> <li><strong><span>We Innovate and Simplify</span></strong></li> <li><span>We do&nbsp;</span><strong><span>more with less</span></strong></li> <li><span>Permanent&nbsp;</span><strong><span>Communication&nbsp;</span></strong><span>takes us further</span></li> <li><span>We deliver amazingly consistent&nbsp;<strong>results</strong></span></li> <li><strong><span>We gain credibility and conquer our space</span></strong></li> </ul> <p>&nbsp;</p> <p><span>🌈&nbsp;</span><strong><span>Diversity, Inclusion and Belonging&nbsp;</span></strong><span>🌈</span></p> <p>&nbsp;</p> <p><span>We are more than 2000 people who add up the differences to multiply: multiplying a +diverse, +welcoming, +creative and +fair environment.</span></p> <p>&nbsp;</p> <p><span>We value the different possibilities of being and thinking.&nbsp;That's why we created&nbsp;</span><strong><span>Sommar&nbsp;</span></strong><span>, our diversity, inclusion and belonging program.</span></p> <p>&nbsp;</p> <p><u><span>This is our delivery to a better society, company and people.</span></u></p> <p>&nbsp;</p> <p><span>We are more than a company: we are agents of transformation, innovation and change.&nbsp;</span><strong><span>#Let's Summar?</span></strong></p> <p>&nbsp;</p> <p><strong><span>All our opportunities are open to people with disabilities (PWD)&nbsp;</span></strong><span>♿</span></p> <p>&nbsp;</p> <h2><span>REVOLUTIONING THE WAY PEOPLE SET UP THEIR HOME IS OUR PURPOSE, AND YOURS?</span></h2> <div class="description__about"> <p><span>For over a decade, MadeiraMadeira has been a leader in offering technological solutions so that as&nbsp;</span><strong><span>many people as possible can feel at home.&nbsp;</span></strong><span>🏠🚀</span></p> <p>&nbsp;</p> <p><span>Our purpose is one:&nbsp;</span><strong><span>to reinvent the way people assemble their homes&nbsp;</span></strong><span>.&nbsp;We work every day to ensure that every little piece of the home of more than 3 million customers tells a story.</span></p> <p>&nbsp;</p> <p><span>To ensure this, we are passionate about challenges and consistent results.&nbsp;We dream, believe and do: we are the largest home products platform in Latin America with more than 2 million products offered on our website and, in addition to e-commerce, we are also a marketplace and we operate with Guide Shops throughout Brazil.</span></p> <p>&nbsp;</p> <p><span>We are MadeiraMadeira.&nbsp;A company for everyone, everyone and everyone.&nbsp;After all, it's all about feeling at home here!&nbsp;</span><span>🏠</span></p> </div><div class="content-conclusion"><p><em>*** Similar to the introduction that can precede all job descriptions, an outro can also be formatted for consistency on all posts</em></p> <p><em>*** Semblable à l'introduction qui peut précéder toutes les descriptions de poste, une outro peut également être formatée pour la cohérence sur tous les messages<br></em></p></div>