Hybrid Mid-level Commercial Support Analyst

Posted 12 hours ago

Apply now

About the role

  • Data Analyst role focusing on business insights and data governance across finance and commercial sectors at Porto Seguros.

Responsibilities

  • Map business area processes (commercial, finance) and translate complex pain points into clear data requirements and management dashboards.
  • Develop and maintain interactive, scalable dashboards, ensuring governance and reliability of information.
  • Design and build performance indicators (KPIs) and OKRs from scratch, connecting data sources to the business reality.
  • Perform exploratory analyses to investigate financial/commercial anomalies (e.g., margin drops, churn).
  • Ensure the integration and quality of data from the database to the final visualization.
  • Present results and insights to non-technical stakeholders, guiding teams toward action plans (Data Storytelling).

Requirements

  • Power BI: Strong experience creating dashboards, data modeling (Star Schema/Snowflake) and mastery of DAX for advanced calculations.
  • SQL: Proficient in writing complex queries for data extraction, manipulation and consolidation.
  • Python: Practical experience for exploratory analysis and automation (libraries such as Pandas and NumPy).
  • Excel: Advanced level (Power Query, PivotTables) for quick interfacing with teams that require spreadsheets.
  • Business acumen: Previous experience working directly with financial indicators (income statement/P&L, margins) or commercial metrics (sales funnel, conversion).
  • Hands-on experience with cloud data warehouses, especially Google BigQuery.
  • Knowledge of ETL/ELT routines.

Benefits

  • Flexible Meal and Food Allowance;
  • Health insurance;
  • Dental plan;
  • Wellhub and TotalPass;
  • Exclusive Bio Ritmo gym for employees: Headquarters;
  • Profit Sharing (PLR);
  • Share Program "Porto em Ação" — complementary to PLR through 2025;
  • Beach volleyball and multi-sport courts: Headquarters;
  • Transportation voucher;
  • Van shuttle services: provided at the main Porto access stations (Luz, Barra Funda, Santa Cecília and Júlio Prestes);
  • Extended parental leave: up to 40 days for all family configurations;
  • Extended maternity leave: 6 months;
  • Medical outpatient clinic with specialists: Headquarters and Barra Funda;
  • Daycare or nanny assistance;
  • Life insurance;
  • Private pension plan - PortoPrev;
  • Discounts on products and services;
  • Tuition assistance: reimbursement for undergraduate, postgraduate or MBA studies;
  • Monthly races: subsidy for major São Paulo street races;
  • Language reimbursement (English or Spanish);
  • Porto Theater: exclusive screenings for employees;
  • Library;
  • Rest area: Headquarters;
  • Game room: Headquarters;
  • Massage and podiatry services: Headquarters;
  • Workplace: Headquarters;
  • Schedule: Monday to Friday (4 days on-site and 1 remote);
  • Hours: 09:00 to 18:00;
  • Compensation: Fixed salary;

Job title

Mid-level Commercial Support Analyst

Job type

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job