Matheus Siqueira

Professional summary

Technical skills

Data analysis

• SQL
• Queries, joins, aggregations, and data validation
• Python
• Pandas
• Exploratory data analysis (EDA)
• Inconsistency and anomaly detection
• Advanced Excel (pivot tables, Power Pivot)

Business Intelligence

• Power BI
• Power BI Service
• Power BI Mobile
• DAX
• Power Query
• M language
• Data modeling
• Executive dashboards
• KPIs and performance indicators
• Data storytelling

Data engineering and data quality

• ETL/ELT
• Multi-source data integration
• Data quality
• Data standardization, validation, and cleaning
• Data governance
• Report automation
• Traceability

Business domain

• Fiscal management and tax revenue
• Personnel expenses and Fiscal Responsibility Law (LRF)
• Budget and financial impact analysis
• People Analytics and workforce planning
• Commercial intelligence
• Trade Marketing
• Datasul (TOTVS) ERP
• CRM

Development

• TypeScript
• JavaScript
• React
• Next.js
• Node.js
• REST APIs
• Git and GitHub
• Scrum and Kanban

Infrastructure

• Technical support
• LAN networks
• Structured cabling
• Troubleshooting
• IT inventory
• Technical documentation

Professional experience

1. Administrative Support | Data Analysis, BI, and People Analytics

   Mar 2026 — Oct 2026

   RM Terceirização - Personnel and Human Resources Consulting — assigned to the Municipal Department of Education of Jaboatão dos Guararapes

   • Structured and maintained the centralized database of contracted professionals in the municipal school network, integrating hiring, staffing, and school-unit distribution data into a single source of truth.
   • Implemented data standardization, validation, and inconsistency handling routines (data quality), increasing the reliability of the information behind hiring and reassignment decisions.
   • Built and maintained Power BI dashboards, with Power Query (ETL) and DAX measures, to monitor KPIs for vacancies, staffing, staff shortages, and hiring needs by unit.
   • Monitored the hiring cap and the evolution of personnel expenses, producing control indicators aligned with the Fiscal Responsibility Law (LRF).
   • Produced management reports and workforce planning analyses, supporting demand prioritization and data-driven decision-making.
   • Tracked requests in internal systems, ensuring traceability, continuously updated databases, and deadline compliance.

   Tools and techniques: Power BI · Power Query (ETL) · DAX · KPIs · Data quality · Workforce planning · LRF

2. Data Analysis | Business Intelligence Intern

   Jan 2025 — Feb 2026

   Jaboatão dos Guararapes City Hall - Municipal Treasury Department — Jaboatão dos Guararapes

   • Led the migration of management reports from Excel to Power BI, replacing manual refreshes and email distribution with dashboards published on Power BI Service, with centralized, real-time access on web and Power BI Mobile.
   • Eliminated operational rework and reduced the risk of manual errors by centralizing fiscal indicators in a single, up-to-date source for managers.
   • Structured and maintained tax revenue databases, integrating multiple sources and applying data modeling for consistent and scalable analysis.
   • Built DAX measures and dashboards to monitor tax revenue KPIs, track targets, analyze seasonality, and compare periods.
   • Built ETL pipelines with Power Query and Python (Pandas) automations for data extraction, cleaning, consolidation, and refresh.
   • Ran SQL queries and exploratory data analysis (EDA) to identify trends, inconsistencies, and anomalies in revenue collection.
   • Communicated results to managers and multidisciplinary teams through stakeholder reporting, supporting data-driven fiscal management.

   Tools and techniques: Power BI · Power BI Service · Power BI Mobile · DAX · Power Query · SQL · Python · Pandas · ETL · Data modeling · EDA · Excel

3. Job and Salary Analyst | Workforce Budget and Fiscal Compliance

   Nov 2017 — Jun 2019

   Jaboatão dos Guararapes City Hall — Jaboatão dos Guararapes

   • Reported personnel expenses to the State Court of Accounts, ensuring the consistency, traceability, and legal compliance of the information.
   • Prepared budget and financial impact studies and scenario simulations for public examinations, fixed-term selection processes, and salary-floor adjustments, advising the Executive Secretary and the legal department.
   • Monitored the personnel expense limits of the Fiscal Responsibility Law (LRF), anticipating the risk of exceeding them and proposing alternative hiring and adjustment scenarios.
   • Provided financial analyses and simulations that grounded management's proposals in salary negotiations with unions.
   • Analyzed workforce data and position, career, and compensation structures to identify distortions and support workforce planning.

   Tools and techniques: Budget impact analysis · Scenario simulation · Personnel expenses · LRF · Court of Accounts reporting

4. Commercial and Trade Marketing Assistant | Commercial Intelligence and Budget Management

   Jan 2014 — Mar 2017

   Palácio das Baterias - Official Moura Distributor — Recife, PE

   • Updated sales and revenue KPIs daily, giving leadership continuous visibility into monthly targets in an operation with more than 300,000 batteries sold (automotive, motorcycle, heavy-duty, marine, and UPS).
   • Produced segmented management reports for three sales teams, tailoring the level of detail to sales reps, supervisors, and management.
   • Extracted and prepared sales, order, customer portfolio, and promotional stock data from the Datasul (TOTVS) ERP and CRM, with advanced Excel analysis and data integrity checks.
   • Fully managed an annual marketing budget above R$ 300,000: planning, allocation, execution control, and spend monitoring.
   • Structured, with sales reps and supervisors, negotiations that standardized more than 50 auto repair shops to the Moura visual standard in exchange for higher monthly purchase volume.
   • Coordinated the distribution of merchandising materials across the Recife Metropolitan Region, internal marketing, and corporate events.

   Tools and techniques: Datasul (TOTVS) ERP · CRM · Advanced Excel · Sales KPIs · Management reporting · Budget management

Additional experience

1. Developer | University Extension Project

   Feb 2026 — Present

   Horizon - UNIFG University Extension Project — Jaboatão dos Guararapes

   • Collaborate on MVPs and technology solutions in a team environment similar to a startup.
   • Use Git and GitHub for version control and collaboration across the project team.
   • Take part in activities and ceremonies organized with Scrum and Kanban.
   • Work in a multidisciplinary environment focused on product, software development, and applied learning.

   Tools and techniques: Git · GitHub · Scrum · Kanban · MVP development

2. IT Infrastructure Support Intern

   Feb 2026 — Mar 2026

   Jaboatão dos Guararapes City Hall — Jaboatão dos Guararapes

   • Handled and resolved hardware, software, and connectivity tickets, logging and following up on each request.
   • Performed preventive and corrective maintenance on computers and equipment.
   • Supported LAN networks, structured cabling, and fault diagnosis (troubleshooting).
   • Contributed to IT asset inventory, technical documentation, and simple automations for ticket control.

   Tools and techniques: LAN networks · Structured cabling · Troubleshooting · IT inventory · Technical documentation

Education

Courses and certifications

• Power BI Desktop: Building my first dashboard — Alura
• Power BI: Building calculations with DAX — Alura
• Power BI Desktop: ETL with Power Query — Alura
• Databases and SQL — Alura
• BI with Excel: Building dashboards with Power Pivot — Alura

Languages

• Portuguese (native)
• English (C1)
• Spanish (professional working)

Projects

• Public Revenue Intelligence Platform

  Web analytics product for public revenue: fiscal indicators, target attainment, trends, and decision support.

  Technologies: Next.js, React, TypeScript, Recharts, Zod, and KPI modeling

  Simulated data for technical demonstration.

  View case study → Public Revenue Intelligence Platform

• SQL + Python Data Engineering Lab

  Demonstration pipeline with SQL queries, Python and Pandas transformations, quality auditing, and CSV export.

  Technologies: SQL, Python, Pandas, TypeScript, and Next.js

  Simulated data for technical demonstration.

  View case study → SQL + Python Data Engineering Lab

• Python Automation: Operational Intelligence

  Demo Python automations for data cleaning, consolidation and reporting, shown in a Next.js app.

  Link to the experience: Report automation, dataset integration, data processing with Python and Pandas, and reduction of manual tasks.

  Technologies: Next.js, Python, TypeScript, Vercel Functions

  View case study → Python Automation: Operational Intelligence

• Support SLA Intelligence Hub

  Next.js BI dashboard measuring SLA, backlog, MTTR and at-risk tickets over 780 synthetic tickets.

  Link to the experience: IT infrastructure support experience: ticket organization, SLA tracking, inventory, and traceability.

  Technologies: Next.js, TypeScript, Tailwind CSS, Recharts

  View case study → Support SLA Intelligence Hub

• Ad Performance Intelligence

  Next.js BI dashboard comparing Google Ads and Meta Ads on simulated data: KPIs, funnel and ROAS.

  Link to the experience: Experience at Palácio das Baterias, an official Moura distributor: daily sales KPIs, management reports, Trade Marketing, and marketing budget management.

  Technologies: Next.js, React, TypeScript, Recharts

  View case study → Ad Performance Intelligence