Hybrid Mid-level Data Analyst

at Minsait

• Job title: Mid-level Data Analyst
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: Airflow, Apache, AWS, PySpark, Spark, SQL
• Location requirements: Hybrid, Sao Paulo, Brazil

About the role

• Data Analyst focusing on SQL, developing and maintaining data pipelines using PySpark. Collaborating on data modeling and supporting data warehouses in a dynamic environment.

Responsibilities

• We are looking for a qualified Mid-level Data Analyst with a strong foundation in SQL-based development.
• This role will focus on building and maintaining data pipelines using PySpark, with SQL as the primary coding language.
• The candidate should also have a solid understanding of data modeling frameworks (such as Kimball dimensional modeling) and experience supporting data warehouses and data marts.
• Develop and maintain batch data pipelines using PySpark (SQL-focused).
• Write and optimize complex SQL queries to support business logic and reporting needs.
• Independently understand requirements and translate them into code.
• Transform and integrate data from multiple sources into Iceberg tables and Snowflake.
• Contribute to the development of data marts and curated datasets for business consumption.
• Collaborate with business analysts to understand data needs.
• Monitor and manage data jobs running on AWS EMR orchestrated by Airflow, leveraging S3, Glue, and other AWS services.
• Ensure data quality, consistency, and performance across the pipeline.

Requirements

• Fluent in English
• Minimum of 3 years of hands-on experience in data engineering writing complex SQL queries
• Proven experience in SQL, including joins, aggregations, window functions, and performance tuning
• Hands-on experience with PySpark, particularly Spark SQL
• Familiarity with AWS data services (e.g., EMR, S3, Glue)
• Understanding of data modeling frameworks, including the Kimball methodology
• Experience working with Snowflake or similar cloud data warehouses
• Knowledge of Apache Iceberg or similar table formats (e.g., Delta Lake, Hudi)

Benefits

• Company-subsidized health plan for the employee.
• Option to add dependents to the health plan with payroll discount.
• Dental assistance (optional).
• Option to add dependents to dental assistance with payroll discount.
• Meal or food allowance.
• Transportation voucher (optional).
• Impact & Care - Personal Guidance Program offering confidential emotional support and counseling (psychological, legal, financial, social, and pet-related) at no cost to the employee and legal dependents.
• Gympass - Wellhub (Access to 700+ gyms across Brazil with plans starting at R$29.90, deducted from payroll).
• Option to add dependents to Gympass - Wellhub (up to 3 dependents — paid via credit card).
• Access to Udemy through our intranet.
• Partnerships with major consumer brands.
• SESC membership plan for employee and dependents.
• Discount agreements with educational institutions (undergraduate and postgraduate) and language/certification schools.
• Group life insurance.