Hybrid Data Analyst – Mid-level

at Minsait

• Job title: Data Analyst – Mid-level
• 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 developing and maintaining data pipelines using SQL and PySpark at Minsait. Collaborating with teams to enhance data quality and reporting capabilities.

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 various 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
• 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)
• Experience building and managing data marts (preferred)
• Exposure to Airflow or other orchestration tools (preferred)

Benefits

• Company-subsidized health insurance for the employee.
• Option to include dependents in the health plan with payroll-deducted premium.
• Optional dental care plan.
• Option to include dependents in the dental plan with payroll-deducted premium.
• Meal allowance or grocery voucher.
• Optional transportation voucher.
• Impact & Care - Personal Support Program offering confidential emotional support and counseling in psychological, legal, financial, social and pet-related matters at no cost for the employee and legal dependents.
• Gympass - Wellhub (Access to over 700 gyms across Brazil with plans starting at R$ 29,90 deducted from payroll).
• Option to include dependents in Gympass - Wellhub (up to 3 dependents - paid via credit card).
• Access to Udemy through our intranet.
• Partnerships with major consumer brands for discounts.
• Agreement with SESC for the employee and dependents.
• Discount agreements with educational institutions (undergraduate and postgraduate) and language/certification schools.
• Group life insurance.