Job Summary: This role involves financial reporting, dashboard creation, cost control, budget monitoring, data analysis, and compliance within an association setting. Key Highlights: 1. Preparation of financial reports and interactive dashboards 2. Strict cost control and budget monitoring 3. Data analysis using SQL, advanced Excel, and Power Query **JOB RESPONSIBILITIES** * Prepare and analyze **periodic financial reports**, focusing on **performance indicators**, results by department, and the Association’s overall financial picture, using data analysis and visualization tools. * Create **interactive dashboards** and management reports using solutions such as **Power BI, Tableau, or Qlik**, promoting **data storytelling** to support decision-making. * Rigorously control and monitor **operational costs**, ensuring adherence to the **approved budget**. * Conduct budget monitoring (**budgeted vs. actual**), identify variances, and propose **continuous adjustments and improvements** in financial management. * Monitor **cost centers** for each department, suggesting optimizations and greater efficiency in resource allocation. * Fully oversee **accounts payable and accounts receivable** processes, including verification of **invoices, service orders, and other commitments** impacting the Association’s balances. * Ensure compliance with **internal policies, bylaws, and applicable legislation**. * Perform data queries, extractions, and manipulations using **SQL**, as well as monitor and support **ETL (Extract, Transform, Load)** processes. * Integrate data from **ERP systems** (e.g., **SAP, Totvs, or similar**). * Use **advanced Excel**, **Power Query**, and automation tools (including **Python**, where applicable) for financial and operational data analysis, processing, and consolidation. * Support the **accounting and tax audit** process, responding to requests and ensuring information reliability. * Collaborate with the **Procurement Department** to track **asset activation** and manage the **fixed asset register**. * Understand and monitor **inventory operations**, including goods receipts and dispatches. * Support the **weekly cash bag reconciliation**, processes related to **third-party damage reimbursement**, and other related administrative and financial routines. * Strictly comply with, and ensure others’ compliance with, the **Association’s Bylaws**, **internal policies**, **institutional guidelines**, and **applicable legislation**. **MANDATORY REQUIREMENTS** * Completed or currently pursuing a bachelor’s degree in **Business Administration**, **Business Administration with Systems Analysis specialization**, **Management Systems**, **Accounting**, **Financial Management**, or related fields. * Knowledge of **ERP systems**. * Basic knowledge of **financial subsystems**, such as **accounting, taxation, and cost accounting**, plus proficiency in the **Microsoft Office suite**. * Experience in creating **interactive dashboards** and **data visualization (Data Visualization)**, with emphasis on **data storytelling**, using tools such as **Power BI, Tableau, or Qlik**. * **Database and ETL**: data querying and manipulation using **SQL (Structured Query Language)** and familiarity with **ETL (Extract, Transform, Load)** for integration of sources such as **ERPs (SAP, Totvs, or similar)**. * **Automation and Data Analysis**: use of **advanced Excel**, **Power Query**, and preferably **Python or other languages/tools**, for data analysis and automation. **Location:** Preferably reside in Campinas City. Employment Type: Full-time, CLT (Consolidation of Labor Laws) permanent position Compensation: R$2.500,00 – R$2.900,00 per month Benefits: * Medical insurance * Dental insurance * Life insurance * Meal allowance * Transportation allowance Workplace: On-site