Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.
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
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
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
-
Senior Data Engineer II
Oscar Health New York, New York, United States · $181K–$237K/yr
-
Data Engineer
AcuityMD $113K–$159K/yr
-
Staff Data Engineer, Analytics
Afresh San Francisco, California, United States · $168K–$250K/yr
-
Data Engineer - Agentic AI
Defense Unicorns Springfield, Virginia, United States · $149K–$201K/yr
-
Senior Data Engineer
Southend Pharmacy Houston, Texas, United States · €45K–€65K/yr
-
Senior Data Engineer (Talent Pool)
ioet San José de Alluriquín, Santo Domingo de los Tsáchilas, Ecuador