Grupo QuintoAndar | Analytics Engineer Specialist

About QuintoAndar:
QuintoAndar was born to do something very rewarding: open doors. We opened doors for technology to be part of living. And, through it, we simplify and reduce the bureaucracy of the experience of those looking for a new home. Thus, we became the most valuable proptech in Latin America, leading the real estate market in around six countries and more than 75 cities around the globe.

The first steps in the international market have been taken since we acquired Grupo Navent, which is ranked number 1 in Mexico (Inmuebles24), Argentina (Zonaprop), Peru (Adondevivir & Urbania) and Ecuador (Plusvalia) - among others. And most recently, we launched Benvi, our international brand in Mexico, which comes with our residential rental product and service.

We offer an end-to-end ecosystem to make life easier for those looking to rent or buy a home, sell a property and unlock a transaction. Think of zero paper or bureaucracy: everything happens on a single platform, with transparency and speed alongside incredible human support.

We are currently valued at over $5.1 billion (August 2021) and continue to grow 4x year over year, breaking records.

To make all this happen, we have more than 4,000 talented people, working with cutting-edge technology and best design practices to ensure a seamless experience throughout the sales and rental process, combined with smart financial products. Here you will work with the best professionals in the market, in an environment that breathes innovation, collaboration and high performance.

To learn more about our history, visit https://quintoandar.group/en/.

About Grupo QuintoAndar:

We are Grupo QuintoAndar, the largest real estate ecosystem in Latin America. Guided by a shared purpose of helping people love where they live, we have a diverse portfolio of brands and solutions that cover all stages of the journey of living. We develop technologies and innovations that transform and leverage the whole living experience.

About working at QuintoAndar:

• Possibility of learning;
• Opportunity to work in a team that seeks to use the best practices and tools in the market;
• Work in an informal environment with a horizontal structure;
• Being part of a team working on a high-impact project that affects the lives of thousands of people.

Location & Remote Work

Our technology team works on the "remote-first" model, which means we are working from home with the possibility of living anywhere in Brazil. We also have the option of using QuintoAndar's offices in São Paulo and Campinas or using partner coworking spaces, both up to twice a week.

Language

This job description is written in English because for that position you will need it for communications with coworkers and suppliers who are from worldwide, for tools and internal materials as well. // A descrição desta vaga está escrita em Inglês porque para esta posição é necessário para a comunicação com colegas e fornecedores, que são de diferentes países, além do uso de ferramentas e materiais internos.

Stages of the Selection Process

Our selection process currently lasts an average of 30-40 days, from application to completion of the assessment. Going through:

• Application
• Tech Screening
• Technicals Interviews with Data Team
• Phone interview with Recruiter
• Offer

About the Area:

An Analytics Engineer is someone who understands business needs while applying best software engineering practices to implement data pipelines and create data abstractions that help the company make better decisions faster.

The workflow of analytics engineering aims to clean, transform, and model raw data into consumable information for strategic decision-making. During the process of obtaining raw data to making clean and transformed data available, the analytics engineer tests the data to ensure quality, documents business rules, and creates models to ensure they are consumed reliably and performantly.

Responsibilities of an Analytics Engineer at QuintoAndar:

• Communicate with different stakeholders to understand their primary needs;
• Create and edit data pipelines, considering business logic that best applies to the area in question, choosing levels of aggregation, grouping and transforming fields, checking data quality, and cleaning the data;
• Investigate inconsistencies and be able to trace the source of differences (data troubleshooting);
• Maintain and promote code and pipeline standards through code review, including testing and documentation;
• Create robust data models that run reliably in a production environment;
• Ensure self-service analytics for business areas.

Requirements

What we are looking for:

• Has experience in building multidimensional data models (Star and/or Snowflake schema);
• Has strong SQL skills, feels comfortable with complex SQL and is used to enhance SQL query performance;
• Has proven experience in building/managing ELT/ETL pipelines;
• Has experience with Python;
• Knows columnar storage solutions (such as Amazon Redshift and Apache Parquet);
• Has 7 or more years of experience building pipelines;
• Has proven experience in translating business area needs in data product solution;
• Is proficient in English and/or Spanish - our code, documentation, tools, and materials are often structured in English.
• Sometimes, we communicate with colleagues and vendors from other countries;
  Is free of any prejudice.

You'll stand out if you:

• Good communication skills and experience working with multiple teams;
• Experience with Airflow, Spark, and Databricks;
• Strong knowledge in optimizing SQL query performance;
• Experience as a tech/project lead or similar;
• Experience in building semantic layers.

Important:

• Our selection process starts with the application! If you are truly interested in joining our team, make sure to put in extra effort at this stage. We review all candidates individually and provide feedback even to those who do not proceed in the process;
• All communication is done via email, so be attentive to our messages and whitelist the @quintoandar.com.br domain to prevent our emails from going to spam.

Benefits

• Competitive salary package;
• Bonus
• Meal allowance ("Flash benefícios");
• Health plan;
• Dental plan (optional);
• Life insurance;
• Daycare subsidy;
• Subsidy to sports practicing (Gympass).
• Extended maternity and paternity leave;
• Reserved room for breast-feeding*;
• Discount on our parking lot;*
• Language learning support;
• Free transfer from Vila Madalena and Fradique Coutinho stations to the office*.
  

Diversity & Inclusion at QuintoAndar

At QuintoAndar, we believe diversity of perspectives and experiences guarantee a differentiated work environment, based on respect and valuing differences. Feel free to declare the information on the registration form. If you are not comfortable answering them, just choose the option "I prefer not to respond". This information helps us create an increasingly inclusive environment and it is used only for this purpose, it is confidential, and it will not impact your performance throughout the hiring process

Data Protection Policy
The information you provide in the recruitment process form is confidential and stored in a secure environment. We have implemented technical and administrative measures to protect your data. To learn more about how we handle personal data, please visit our Privacy Policy.
To exercise your rights regarding your personal data, such as access to data, confirmation of processing, correction of data, anonymization, blocking or deletion, and other rights with the QuintoAndar Group, please contact us through our Customer Service Channel.