Business Analyst

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

Join Hexa as a Business Analyst supporting data-driven operations in the financial services sector. Based in Porto, with a hybrid working model, you will help business users translate information needs into reliable data solutions, improve reporting efficiency and contribute to the resolution of data quality issues.

WHAT YOU WILL DO

• 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.

WHAT WE ARE LOOKING FOR

• 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).

TECHNICAL SKILLS

• SQL for data querying, extraction and optimization.
• Microsoft Excel for data analysis and validation.
• Business requirements gathering and functional specification documentation.
• Data quality analysis and issue investigation.
• Data extraction automation and process optimization.

WHAT WE OFFER

• Private health insurance from your first day, with no waiting period and optional family coverage.
• Free, confidential psychological support through our mental health partnership, including professional sessions and resources.
• Continuous learning opportunities, with support for professional training and certifications.
• Opportunities to develop knowledge of quality management and information security best practices.
• Flexibility through a hybrid working model, aligned with project requirements.
• Childcare vouchers and initiatives supporting work-life balance.
• A collaborative professional environment with regular team interactions and accessible leadership.

EQUAL OPPORTUNITY

Hexa is committed to building an inclusive workplace where individual differences are respected and opportunities are based on skills, experience and potential. Aligned with the principles of the Portuguese Diversity Charter, we promote fairness, equal opportunity and respect throughout the recruitment process and professional journey.

HEXA LIFE

At Hexa, we are all Builders. Each person brings unique expertise and perspectives that contribute to stronger solutions, meaningful projects and lasting professional relationships. Our culture is grounded in honesty, mutual support and agility. We encourage transparent communication, shared knowledge, individual responsibility and continuous learning. Wherever you work, you are part of a connected community that builds progress together.