Data Analyst / Data 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

We are looking for an experienced Data Analyst / Data Engineer to join a data-focused technology environment within the banking sector. This opportunity combines business analysis, data modeling, business intelligence and data engineering, contributing to the development of reliable and scalable data solutions. You will work with business and technical stakeholders to transform information requirements into structured data models, reporting capabilities and optimized data integration processes.

WHAT YOU WILL DO

• Collaborate with business stakeholders to analyze data requirements and translate them into functional and technical specifications.
• Design and maintain relational and dimensional data models to support analytical and reporting requirements.
• Develop and optimize data warehouse structures using star and snowflake schemas.
• Design and maintain business intelligence reports and dashboards that support operational and strategic decision-making.
• Develop, test and maintain ETL/ELT processes for data extraction, transformation and integration.
• Implement data integration solutions using Stambia or equivalent ETL technologies.
• Optimize SQL queries, data transformations and pipeline performance.
• Establish automated data validation controls to improve data quality, consistency and integrity.
• Maintain technical documentation, data dictionaries and data lineage information.
• Collaborate with data engineering teams to ensure the alignment of technical implementations with business requirements.
• Investigate data inconsistencies and contribute to continuous improvement of data processing and reporting solutions.

WHAT WE ARE LOOKING FOR

• 6 to 9 years of professional experience in data analysis, data engineering, business intelligence or related areas.
• Bachelor's or Master's degree in Computer Science, Data Science, Statistics, Finance or a related field.
• Proven experience combining business requirements analysis with hands‑on data engineering activities.
• Strong analytical capabilities and a structured approach to problem-solving.
• Ability to communicate technical concepts effectively to business and technical stakeholders.
• Experience delivering data solutions with autonomy, accountability and attention to quality.
• Professional working proficiency in French (minimum B2).
• Fluent English, written and spoken, for international collaboration and technical documentation.
• Collaborative mindset, adaptability and a proactive approach to continuous improvement.

TECHNICAL SKILLS

• Advanced SQL, including complex queries, joins, stored procedures and query optimization.
• Relational database management and data warehouse architecture.
• Dimensional data modeling, including Kimball methodology, star schemas and snowflake schemas.
• ETL/ELT development, data transformation and integration processes.
• Experience with Stambia or comparable ETL technologies such as Talend, Informatica, SSIS, Azure Data Factory or dbt.
• Data quality validation, automated controls and troubleshooting.
• Data governance principles, including data lineage, metadata management and data dictionaries.
• Business intelligence reporting and dashboard design.
• Data pipeline performance optimization and technical documentation.

NICE TO HAVE

• Practical experience with Stambia and its integration capabilities.
• Power BI experience, including DAX and Power Query/M.
• Previous experience in banking, financial services or insurance environments.
• Familiarity with financial data, risk management or regulatory requirements.
• Experience with cloud platforms such as Microsoft Azure, AWS or Google Cloud Platform.
• Knowledge of Python or Unix/Linux scripting.
• Experience adapting existing data integration processes to new tools or architectures.

WHAT WE OFFER

• Private health insurance from your first day, without waiting periods, with optional family extension.
• Free and confidential psychological support through our mental health partnership, including access to professional guidance and well-being resources.
• Continuous learning opportunities, professional training and support for certifications.
• Opportunities to strengthen technical capabilities and develop expertise in data engineering and business intelligence.
• Access to professional development in quality management, information security and cybersecurity best practices.
• Flexibility whenever compatible with project requirements and operational responsibilities.
• Childcare vouchers and support measures designed to promote work-life balance.
• Team initiatives, shared experiences and a collaborative professional community.
• An environment that values professional growth, autonomy, transparency and mutual support.

EQUAL OPPORTUNITY

At Hexa, we are committed to creating an inclusive and respectful workplace where everyone has equal opportunities to contribute and develop. In alignment with th