A complete application in a minute
Tailored resume and cover letter, ready to send.
Euronext is seeking a Business Intelligence / Data Analytics Engineer Trainee in Porto. You will design, build, and maintain scalable analytics solutions, transforming raw data into actionable insights and supporting decision making.
You will collaborate with data engineers, analysts, and business stakeholders to deliver dashboards and robust BI models. The role involves data collection, cleaning, transforming, and validating data, EDA, ML model development, and preparing datasets for analysis.
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
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. 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. Unity
We respect and value the people we work with We are unified through a common purpose We embrace diversity and strive for inclusion Integrity
We value transparency, communicate honestly and share information openly We act with integrity in everything we do We don't hide our mistakes, and we learn from them Agility
We act with a sense of urgency and decisiveness We are adaptable, responsive and embrace change We take smart risks Energy
We are positively driven to make a difference and challenge the status quo We focus on and encourage personal leadership We motivate each other with our ambition Accountability
We deliver maximum value to our customers and stakeholders We take ownership and are accountable for the outcome We reward and celebrate performance We are proud to be an equal opportunity employer. We do not discriminate against individuals on the basis of race, gender, age, citizenship, religion, sexual orientation, gender identity or expression, disability, or any other legally protected factor. We value the unique talents of all our people, who come from diverse backgrounds with different personal experiences and points of view and we are committed to providing an environment of mutual respect. Additional Information
This job description is only describing the main activities within a certain role and is not exhaustive. It does not prevent to add more tasks, projects. Euronext is the leading European capital market infrastructure, covering the entire capital markets value chain, from listing, trading, clearing, settlement and custody to solutions for issuers and investors. Euronext operates MTS, one of Europe's leading electronic fixed income trading markets, and Nord Pool, the European power market.
Euronext also provides clearing and settlement services through Euronext Clearing and its Euronext Securities central securities depositories (CSDs) in Denmark, Italy, Norway and Portugal. Euronext's regulated exchanges in Belgium, France, Greece, Ireland, Italy, the Netherlands, Norway and Portugal host a broad range of listed issuers, a strong blue‐chip franchise and the largest global center for debt and fund listings. With a diverse domestic and international client base, Euronext is a major venue for European lit equity trading. Its products include equities, FX, ETFs, bonds, derivatives, commodities and indices.
Business Intelligence /Data Analytics Engineer Trainee • Porto, Portuguese Republic, PT