Minsait

Mid-level Data Analyst

Minsait

full-time

Posted on:

Location Type: Hybrid

Location: São Paulo • Brazil

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AirflowApacheAWSPySparkSparkSQL

About the role

  • 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.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLPySparkdata modelingcomplex SQL queriesperformance tuningdata engineeringdata transformationdata integrationdata qualitydata pipelines
Soft Skills
collaborationindependencecommunicationproblem-solvinganalytical thinking