Data Engineer

Description

Summary: Join an international data team to industrialize data feeds, design ETL processes, and continuously improve data platforms for Global Markets front-office environments. Highlights: 1. Contribute to the industrialization of data feeds and ETL process design 2. Collaborate in a dynamic, high-potential nearshore business environment 3. Work with complex datasets and optimize robust data architectures Every moment counts. Especially those you live to the fullest. Welcome to Consort Group. For over 30 years, Consort Group has been helping companies leverage their data and infrastructure. It is backed by two leaders, Consortis and Consortia, and places people and social responsibility at the heart of its values. **This is your future team** Established in 2021, Consort Portugal supports the strategic offshoring choices of our clients, particularly in Europe, and brings our expertise in infrastructure services to the Portuguese market. With a team of around 45 employees, our Service Center based in Porto is developing a dynamic nearshore business, offering the French and European markets an environment of excellence and high potential. **Data Engineer** **This is your mission** Are you passionate about **data engineering, ETL processes and data warehousing**? Then this position is for you. As a **Data Engineer**, you will join an international data team responsible for delivering high\-quality data to Global Markets front\-office environments. You will contribute to the industrialization of data feeds, the design of robust ETL processes, and the continuous improvement of data platforms. Build side: * Perform and document detailed data analysis to support business requirements * Design, define and validate data models for multiple financial use cases * Develop and maintain ETL/ELT processes using SSIS and Python * Contribute to data warehouse and datamart design * Industrialize and automate data feeds to ensure reliability and scalability * Optimize SQL queries and improve performance (efficient memory and processing practices) * Ensure best practices in version control using Git (preferably Bitbucket) Run side: * Provide support and troubleshooting for data pipelines and production incidents * Monitor and maintain data processing workflows to ensure stability and performance * Identify and implement process optimization and improvement measures * Collaborate with other IT stakeholders to enhance data architecture and standards * Ensure data consistency, quality and governance across systems * Contribute to documentation and knowledge sharing within the team **This is your background** You have at least **3\+ years of experience** in data engineering or similar roles within demanding data\-driven environments. You enjoy working with complex datasets, optimizing performance and designing robust data architectures. You are detail\-oriented but capable of maintaining a strong synthesis vision. You are looking for a collaborative environment where your expertise directly impacts business performance. **This is your expertise:** * Advanced SQL knowledge (mandatory) * Strong experience in Oracle environments (mandatory) * Professional experience with SSIS (minimum 2 years) * Professional experience with Python * Data warehousing concepts (ETL/ELT, datamarts, modeling) * Performance tuning and query optimization * Version control using Git (Bitbucket preferred) This is how you work as part of a team: * Strong analytical mindset with attention to both detail and big picture * Good communication skills in English (expert level required) * Strong team spirit and collaborative approach * Adaptability in dynamic and evolving environments * Client\-focused mindset with a proactive attitude * Ability to manage priorities and deliver high\-quality results **This is our commitment** At Consort Group, you are an expert who we support so that every assignment becomes a step that counts. * Attentive and human onboarding * A truly hands\-on management style * Continuous training opportunities * Concrete commitments: inclusion, equality, solidarity * A comprehensive HR package: health insurance, TR card, CSE, pension plan * A culture of feedback and meaningful projects **The recruitment process:** * An initial phone call with our recruitment team * An HR interview and a job interview with a business engineer * A test or technical interview with one of our experts * A final meeting with your future manager or project manager * And if we're a good fit, we'll get started together **Good to know** Location: Lisbon Contract: Permanent contract Remote work: **Hybrid (twice from the client's office)** Job category: Data Engineering / Data Warehousing What you will do here, you won't do anywhere else. This moment is yours.