Mid-Level Data Analyst

This is a fully remote position, open to applicants in Brazil.

📋 Description

• Independently perform data reconciliation and assist with the area’s accounting closing process.

• Design and manage data pipelines and automation processes, ensuring quality and monitoring through testing.

• Gather data, pinpoint sources, and guarantee the integrity of information.

• Execute intermediate to advanced analyses, integrating various sources to detect anomalies, resolve ambiguous business queries, and extract insights.

• Create and enhance interactive dashboards and reports, recommending metrics and visual representations.

• Identify financial discrepancies and erroneous flows in databases like the Ledger, investigate underlying causes, and initiate corrective measures.

• Provide support for internal and external audits by organizing datasets and supporting evidence.

• Work collaboratively with Accounting, Product, Regulatory, and other teams to comprehend analytical requirements and propose solutions.

⛳️ Requirements

• Proficient in advanced SQL: including complex queries, query optimization, window functions, and stored procedures.

• Experience in creating and maintaining dashboards and reports using BI tools (Looker, Power BI, or similar).

• Knowledge of data modeling for BI (Star Schema, Snowflake Schema).

• Proficient in at least one programming language, such as Python, with the ability to enhance scripts or pipelines.

• Familiar with data transformation processes (ETL/ELT) and ensuring the quality and observability of pipelines.

• Experience with terminal tools, such as gcloud.

• Bachelor’s degree required.

• Minimum of 3 years of experience in Data and Metrics.

• Advanced analytical abilities and capability to convert complex data into actionable insights.

• Excellent communication skills with the ability to present findings clearly to both technical and business audiences.

• Prior experience in fintech, banking, or financial markets is preferred.

• Familiarity with BigQuery, Databricks, or Google Apps Script is preferred.

• Knowledge of applied statistics is preferred.

• Experience with code version control using Git is preferred.

• Experience in accounting and regulatory topics is preferred.

🏝️ Benefits

• Fixed salary.

• Variable compensation package (profit-sharing, long-term incentive plan, or commission), based on role eligibility.

• Health and dental insurance with copayments.

• Verde Virtual Hospital: 24/7 telemedicine services.

• Prescription drug subsidy.

• Meal and/or food allowance – Pluxee.

• Childcare assistance for children up to 5 years and 11 months old.

• Support for children with disabilities.

• Life insurance coverage.

• Fuel or commuting allowance.

• Home-office allowance for hybrid or remote contracts.

• Welcome kit for new parents.

• SESC membership.

• Education benefit – Internal self-development platform (Studa and Stone Library).

• Acolhe360º – Free emotional support services.

• Quick massage and on-site medical clinic access.

• Wellhub services.

• TotalPass membership.

• Pet Club membership.

• Flash services.

• Férias&Co benefits.

• Transportation voucher.

• Allya membership.

• Educational partnerships.