Senior Data Engineer

LGG Advisors, with offices in Porto, Lisbon, London, and Madrid, provides high added-value consultancy and technological services to financial sector firms globally. Our Digital & AI team helps clients modernize their data estates, optimize data platforms, and deliver scalable analytics solutions that support business growth and transformation.

We are looking for a Senior Data Engineer to join our growing Digital & AI practice in Portugal (Porto or Lisbon). The successful candidate will play a critical role in the support, maintenance, optimization, monitoring, and enhancement of enterprise data platforms of our clients built primarily on the Microsoft Azure data ecosystem.

Description

• Support enterprise-scale data integration and analytics platforms deployed across Azure environments.
  
• Act as a key contributor in ensuring data platform stability, reliability, performance, and operational excellence.
  
• Troubleshoot and resolve production incidents impacting business-critical reporting and analytics solutions.
  
• Participate in modernization initiatives involving Azure Data Factory, Azure SQL Database, Microsoft Fabric (preferred) and related technologies.
  
• Contribute to continuous improvement initiatives, automation efforts, and support process optimization.
  
• Work alongside business stakeholders, data engineers, architects, consultants, and client teams in fast-paced international environments.
  
• Support data-driven transformation initiatives within financial services and other regulated industries.
  
• Contribute to client-facing data engineering solutions for the financial services industry.
  
• Drive best practices in data architecture, governance, quality, security and scalability.
  

Responsibilities

• Monitor and manage the Data Support inbox, acknowledging and prioritising requests promptly.
  
• Log every issue as a ticket in Azure DevOps, keeping status, priority and resolution notes up to date.
  
• Investigate and resolve production issues in Azure SQL Database, including failed jobs, performance problems, data quality issues and access requests.
  
• Diagnose and fix Azure Data Factory (ADF) pipeline and/or ETL/ELT failures, reruns and dependency issues, and put fixes in place to stop them recurring.
  
• Perform root cause analysis on recurring or high-impact incidents and recommend improvements.
  
• Support downstream reporting in Microsoft Fabric and Power BI, tracing issues back to source data or pipelines.
  
• Keep stakeholders informed during incidents, explaining the cause, impact and next steps in plain language.
  
• Work with the wider Data and Technology teams on changes, releases and escalations.
  
• Work independently with strong accountability for deliverables.
  
• Stay up to date with Microsoft Fabric and similar platforms’ capabilities, Azure technologies and modern data engineering practices.
  

Qualifications

• Undergraduate degree in Computer Science, Engineering, Information Systems, Data Engineering, Mathematics, Statistics, or a related discipline.
  
• Strong analytical, troubleshooting, and communication skills.
  
• Ability to manage multiple priorities in a client-facing consulting environment.
  
• Fluency in English at a proficient level (education or work experience in an English-speaking environment is a plus)
  

Requirements

• Minimum 5 years of experience in Data Engineering, Data Integration, Data Platform Support, or Data Operations.
  
• Proven experience supporting production data platforms in Azure.
  
• Strong SQL and T-SQL skills, with hands-on experience in Azure SQL Database (troubleshooting, query tuning, stored procedures, security and permissions).
  
• Practical experience building, monitoring and troubleshooting Azure Data Factory pipelines.
  
• Working knowledge of Microsoft Fabric and Power BI.
  
• Experience working with tickets and backlogs in Azure DevOps, or a similar tool.
  
• Familiarity with Git, Azure DevOps, and CI/CD deployment practices.
  
• Excellent communication skills, with the ability to explain technical issues simply to non-technical colleagues.
  
• Confident managing stakeholders, setting expectations and prioritising competing requests.
  
• A methodical, ownership-driven approach to problem solving.
  

Preferred

• Microsoft Certified: Azure Data Fundamentals (DP-900).
  
• Experience with Power BI datasets, semantic models, and reporting integrations.
  
• Familiarity with Infrastructure-as-Code tools such as Terraform, Bicep, or ARM Templates.
  
• Exposure to financial services, consulting, banking, insurance, or regulated industries.
  
  

What We Offer

• Fast-growing company with a presence in Porto, Lisbon, London, and Madrid.
  
• Visa sponsorship and relocation support for candidates based outside Portugal or Spain.
  
• Opportunity to work on complex and stimulating projects for sophisticated clients across the US and Europe.
  
• Competitive salary and performance-based benefits.
  
• Hybrid work model, with up to 50% remote work.
  
• Career Development Plan tailored to your growth.
  
• Internal and external Training Programs.
  
• Sponsorship opportunities for certifications and advanced education.
  
  

At LGG Advisors, we are committed to building a diverse and inclusive workplace. All qualified applicants will be considered for employment regardless of race, gender identity, sexual orientation, religion, nationality, age or disability.