Senior Data Analyst & BI Engineer

Hexa Group; Lisboa; Hybrid; EUR 45,000 - 75,000; Full time

Benefits offered by this job

Private health insurance

Psychological support program

Continuous learning and certifications

Professional development in data eng/B

Work-life balance initiatives

Autonomy and transparency

Job summary

Hexa Group is seeking an experienced Data Analyst / Data Engineer to join a data-focused technology environment in the banking sector in Lisbon. You will bridge business analysis with data modeling, BI reporting, and reliable data integrations to enable scalable solutions.

You will collaborate with stakeholders to translate requirements into data models and ETL processes, design star and snowflake schemas, and optimize data pipelines, while maintaining documentation and data governance

Qualifications

• Bachelor's or Master's degree in Computer Science, Data Science, Statistics, Finance or related field.
• Proven experience combining business requirements with hands-on data engineering.
• Strong analytical and problem-solving skills.
• Ability to communicate technical concepts to diverse stakeholders.

Responsibilities

• Collaborate with stakeholders to analyze data requirements and translate them into specifications.
• Design and maintain relational and dimensional data models for analytics and reporting.
• Develop and optimize data warehouse structures using star and snowflake schemas.
• Create BI reports and dashboards to support decision-making.
• Develop, test and maintain ETL/ELT processes for data integration.
• Implement data integration solutions using Stambia or similar ETL tools.
• Optimize SQL queries and pipeline performance.
• Establish automated data validation and data quality controls.
• Maintain data dictionaries and data lineage documentation.
• Coordinate with data engineering teams to align implementations with business needs.
• Investigate data inconsistencies and drive improvements.

Skills

Data analysis

Data engineering

SQL

Data warehousing

Dimensional modeling

ETL/ELT

Stambia

Power BI

Python

Cloud platforms

Education

Bachelor's or Master's degree in CS/DS/Stats/Finance

Tools

Stambia

Talend

Informatica

SSIS

Azure Data Factory

dbt

Job description

Hexa Group is seeking an experienced Data Analyst / Data Engineer to join a data-focused technology environment in the banking sector in Lisbon. You will bridge business analysis with data modeling, BI reporting, and reliable data integrations to enable scalable solutions.

You will collaborate with stakeholders to translate requirements into data models and ETL processes, design star and snowflake schemas, and optimize data pipelines, while maintaining documentation and data governance