LGG Advisors

Senior Data Engineer

LGG Advisors Lisbon, Portugal

Financial Services · 51-200 employees

Nov 10
data-engineer Senior (5-10 yrs) Full-time Visa sponsorship Portugal
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The Senior Data Engineer will support, maintain, and optimize enterprise-scale data integration and analytics platforms within the Microsoft Azure ecosystem. They will also troubleshoot production incidents and collaborate with stakeholders to drive data-driven transformation initiatives.

What they look for

Azure Data Factory Azure SQL Database Microsoft Fabric Power BI SQL T-SQL Data engineering Data integration Azure DevOps CI/CD Git ETL/ELT Data quality Troubleshooting Stakeholder management Root cause analysis

Requirements

Candidates must have at least 5 years of experience in data engineering or operations with proven expertise in Azure data platforms. Strong proficiency in SQL, T-SQL, and Azure Data Factory is required, along with excellent communication skills for a client-facing consulting environment.

Benefits

Visa sponsorship Relocation support Performance-based benefits Career development plan Training programs Certification sponsorship

Full description

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.

Similar roles