Job ID
R27935
Country
Portugal
Job City
Porto
Job Family
Intern and Apprentice
Job Type
Employee
Job Sub Type
Apprentice (Fixed Term)

Join us as a Business Intelligence /Data Analytics Engineer Trainee!

As a Business Intelligence /Data analytics Engineer Trainee you will design, build, and maintain scalable analytics solutions that transform raw data into actionable insights. You will work closely with business stakeholders, data engineers, and analysts to deliver reliable data models, dashboards, and reporting solutions that support strategic and operational decision-making.

Key Accountabilities

You will primarily be responsible for:

  • Assist in collecting, cleaning, transforming, and validating data from multiple sources.
  • Perform exploratory data analysis (EDA) to identify trends, anomalies, and business insights.
  • Develop and evaluate machine learning models for supervised and unsupervised learning tasks.
  • Prepare datasets for statistical analysis and predictive modelling.
  • Stay current with emerging technologies, tools, and best practices in data engineering, analytics, and data science.
  • Designing and maintaining semantic data models (star/snowflake schemas) optimized for analytics and reporting.
  • Building and optimizing ETL/ELT pipelines from multiple data sources, ensuring data quality and consistency.
  • Ensure data quality, consistency and performance across business intelligence solutions.
  • Developing and maintaining dashboards and reports using BI tools such as Power BI, Python and R.
  • Translating business requirements into robust BI solutions and flexible Power BI semantic models.
  • Optimizing SQL queries, data models and report performance for large-scale datasets, monitoring BI workloads in cloud and on-premises environments.
  • Collaborating with business users to understand KPIs, metrics and reporting needs, and partnering with Data Engineers, Data Scientists and Product teams.
  • Providing guidance and best practices to analysts and report developers.
  • Defining and enforcing data standards, naming conventions and documentation, supporting data lineage and metadata management.
  • Ensuring compliance with security and privacy requirements.

Knowledge, Skills and Experience Required

  • Bachelor’s or Master’s degree in Computer Engineering or related fields.
  • Eligible for an IEFP Level VI Internship.
  • Good programming skills; knowledge of python, C#.
  • Machine learning model development and evaluation.
  • Data wrangling using libraries such as Pandas/Modin, Polars, NumPy.
  • Knowledge of multiple databases such as SQLServer, PostgreSQL, DuckDB.
  • API-based data ingestion.
  • Strong SQL skills and experience with data warehouses (e.g. Snowflake, Azure Synapse, Big Query, Redshift, SQL Server).
  • Hands-on with Power BI (semantic models, DAX, DirectQuery) and ETL/ELT tools (SSIS, ADF, Airflow, dbt, SSIS or similar).
  • Knowledge of Microsoft Fabric and Azure Foundry (Nice to have).
  • Knowledge of data modelling techniques (Kimball, dimensional modelling).
  • Analytical mindset with the ability to translate business needs into data models and KPIs.
  • Excellent communication skills with both technical and non-technical stakeholders.
  • Organized, able to manage multiple priorities and share knowledge effectively.
  • Fluent in English, with good verbal, written and interpersonal communication skills.
  • Nice to have: experience with cloud platforms (Azure, AWS), Python, DevOps/CI-CD for BI, data governance frameworks.

Apply by submitting your CV in English.

Join Euronext – Shape capital markets for future generations.
Euronext is the leading European capital market covering the entire capital markets value chain, from listing, trading, clearing, settlement and custody to solutions for issuers and investors. We operate seven national stock exchanges, handling 25% of European lit equity trading. Our products include equities, FX, ETFs, bonds, derivatives, commodities and indices. Euronext also provides clearing and settlement services through Euronext Clearing and our network of Euronext Securities CSDs. In addition, Euronext runs MTS, one of Europe’s leading electronic fixed income trading markets, and Nord Pool, the European power market. The company has a diverse domestic and international client base.