Data-Driven Business Analyst | SQL, Reporting & Hybrid Porto

Hexa Consulting; Porto; Hybrid; EUR 36,000 - 52,000; Full time

Benefits offered by this job

Private health insurance

Mental health support

Continuous training

Hybrid working model

Childcare vouchers

Job summary

Hexa Consulting in Porto is seeking a hands-on Business Analyst to support data-driven operations in the financial services sector. Based in Porto with a hybrid working model, you will translate information needs into reliable data solutions and help improve reporting efficiency.

You will engage with business users, document data requirements, develop and optimize SQL queries, automate recurring extractions, and collaborate across teams in an Agile setup to resolve data quality issues.

Qualifications

• 3 to 6 years of relevant experience in business analysis, preferably involving data-related activities.
• Ability to translate business requirements into structured specifications and practical solutions.
• Strong analytical thinking and a methodical approach to problem-solving.
• Clear communication skills and the ability to collaborate effectively across teams.
• Results-oriented mindset, with a focus on quality, accountability and continuous improvement.
• Professional working proficiency in English (B2 level or equivalent).

Responsibilities

• Engage with business users to understand, analyze and document data requirements.
• Translate business needs into clear functional specifications and actionable technical requirements.
• Develop, maintain and optimize SQL queries for data extraction and reporting.
• Automate recurring data extraction activities to improve operational efficiency.
• Investigate data inconsistencies, identify potential causes and coordinate resolution activities with relevant teams.
• Collaborate with business and technical stakeholders in an Agile environment.

Skills

Business analysis

Analytical thinking

Communication skills

Agile collaboration

Tools

SQL

Microsoft Excel

Data extraction automation

Job description

Hexa Consulting in Porto is seeking a hands-on Business Analyst to support data-driven operations in the financial services sector. Based in Porto with a hybrid working model, you will translate information needs into reliable data solutions and help improve reporting efficiency.

You will engage with business users, document data requirements, develop and optimize SQL queries, automate recurring extractions, and collaborate across teams in an Agile setup to resolve data quality issues.