Junior Financial Assistant - Power BI

Description

Job Summary: The professional will be responsible for preparing financial reports, controlling costs, monitoring budgets, and optimizing financial processes using data analysis and BI tools to support decision-making. Key Highlights: 1. Financial analysis and data visualization with a focus on BI 2. Cost management and budget monitoring 3. Use of SQL, advanced Excel, and automation for data analysis **JOB RESPONSIBILITIES** * Prepare and analyze **periodic financial reports**, focusing on **performance indicators**, results by department, and an overall view of the Association, using data analysis and visualization tools. * Create **interactive dashboards** and managerial 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**. * Monitor budget execution (**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** affecting 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 information from **ERP systems** (e.g., **SAP, Totvs, or similar**). * Utilize **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 monitor **asset activation** and manage the **fixed asset register**. * Understand and monitor **inventory operations**, including goods receipts and shipments. * Support the **weekly cash bag reconciliation**, processes related to **third-party damage reimbursement**, and other related administrative and financial routines. * Strictly comply with and enforce the Association's **Bylaws**, **internal policies**, **institutional guidelines**, and **applicable legislation**. **MANDATORY REQUIREMENTS** * Completed or ongoing undergraduate 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 creating **interactive dashboards** and performing **data visualization (Data Visualization)**, with emphasis on **data storytelling**, using tools such as **Power BI, Tableau, or Qlik**. * **Databases and ETL**: data querying and manipulation using **SQL (Structured Query Language)** and knowledge of **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 the city of Campinas. Employment Type: Full-time, CLT (Consolidation of Labor Laws) Compensation: R$2.500,00 \- R$2.900,00 per month Benefits: * Medical insurance * Dental insurance * Life insurance * Meal allowance * Transportation allowance Work Location: On-site