Analytics Engineer Specialist

Summary

Join QuintoAndar, Latin America's largest real estate ecosystem, as an Analytics Engineer. You will build and maintain data pipelines, create data models, and ensure data quality for strategic decision-making. This remote-first position offers the flexibility to work from anywhere in Brazil, with access to offices in São Paulo and Campinas. You will collaborate with various stakeholders to understand their needs and translate them into data solutions. The ideal candidate possesses extensive experience in data modeling, SQL, ETL/ELT pipelines, and Python, along with strong communication skills. QuintoAndar provides a competitive salary and benefits package, including health and dental plans, life insurance, and various other perks.

Requirements

• 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
• Is free of any prejudice

Responsibilities

• 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

Preferred Qualifications

• 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

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