Senior Data Engineer (MS Fabric Experience)

LGG Advisors; Lisboa; Hybrid; EUR 90,000 - 130,000; Full time

Benefits offered by this job

Hybrid remote up to 50%

Visa sponsorship

Relocation assistance

Career development

Training programs

Certifications sponsorship

Job summary

LGG Advisors is expanding its Digital & AI team with a Senior Data Engineer to lead data platform design, migration and modernization for financial services clients. The role emphasizes enterprise-scale data pipelines, governance, and secure analytics strategy.

You will collaborate with consultants and product owners in agile settings, mentor engineers, and drive best practices across the data lifecycle with Microsoft Fabric and related technologies.

Qualifications

• Design and implement modern cloud-native data platforms.
• 5+ years in Data Engineering, Data Platform Development, or Data Architecture.
• Experience with end-to-end data lifecycle and governance.

Responsibilities

• Design, develop and maintain enterprise-grade data platforms using Fabric and related tech.
• Implement Medallion Architecture for scalable analytics solutions.
• Build end-to-end data pipelines: ingestion, transformation, storage, quality, and monitoring.
• Develop solutions with Fabric Data Factory OneLake, Lakehouse, Data Warehouse, Notebooks, Semantic Models, and Power BI.
• Design ETL/ELT processes and data models for enterprise reporting and AI use cases.
• Implement data governance, security, and data quality frameworks.

Skills

SQL

Python

Data Modeling

Azure Cloud

Cloud Data Platforms

ETL/ELT

Mentoring

Education

Bachelor's degree in CS, Engineering, or related field

Tools

Microsoft Fabric

Databricks

Power BI

Azure Synapse Analytics

Delta Lake

Spark

Job description

LGG Advisors is an international consulting and technology firm, with offices in Porto, Lisbon, London, and Madrid, and provides a multitude of high added-value consultancy and technological services to financial sector firms globally. Our team provides an array of comprehensive services catering specifically to our clients' unique and evolving circumstances which require creative and careful consideration, decision-making, and guidance.

LGG is looking to expand its Digital & AI team with a Senior Data Engineer who will work with clients in the design, implementation, modernization, and optimization of enterprise-scale data platforms. This role is designed for a senior professional with 5+ years of experience who is ready to lead data engineering initiatives while contributing to complex client transformation programs.

Description

• Design, migrate and implement modern cloud-native data platforms using Microsoft Fabric and similar platforms, accelerating data-driven transformation.
• Work in complex, fast-paced environments with strong learning, mentoring and development opportunities.
• Contribute to client-facing data engineering solutions for the financial services industry.
• Drive best practices in data architecture, governance, quality, security and scalability.

Responsibilities

• Design, develop and maintain enterprise-grade data platforms utilizing Microsoft Fabric and related technologies.
• Design and implement Medallion Architecture (Bronze, Silver, and Gold) for support scalable and governed analytics solutions.
• Build, optimize and maintain end-to- end data pipelines covering all stages of the data lifecycle: Data ingestion; Data transformation; Data orchestration; Data storage; Data quality and monitoring; Data modeling; Analytics and reporting enablement.
• Develop solutions using Fabric Data Factory OneLake, Lakehouse, Data Warehouse, Notebooks, Semantic Models, and Power BI.
• Design scalable ETL/ELT processes and data models supporting enterprise reporting, analytics, and AI use cases.
• Implement best practices in data governance, security, quality, lineage, and monitoring.
• Collaborate with consultants, engineers, product owners, and client stakeholders in agile environments.
• Document technical designs and communicate architecture decisions effectively.

Qualifications

• Bachelor's degree in Computer Science, Engineering, Information Systems, Mathematics, Statistics, Data Engineering, or a related field.
• Professional proficiency in English.

Requirements

• 5+ years of experience in Data Engineering, Data Platform Development, or Data Architecture.
• Minimum 2 years’ proven hands-on experience with Microsoft Fabric across the end-to-end data lifecycle.
• Proven implementation of Medallion Architecture in production environments.
• Experience with Lakehouse, Warehouse, Data Factory, and Power BI Semantic Models
• Strong SQL and Python skills.
• Experience with Apache Spark, Delta Lake, and modern cloud data architectures.
• Strong understanding of data modeling and dimensional modeling concepts.
• Experience implementing data governance, security, and data quality frameworks.
• Familiarity with Azure cloud services and enterprise architecture principles.
• Experience working in agile delivery environments.
• Excellent analytical, problem-solving, and communication skills.

Differential:

• Microsoft Fabric Analytics Engineer Associate (DP-700) certification.
• Experience with Databricks, Snowflake, Azure Synapse Analytics, Azure Data Lake Storage, or Azure SQL.
• Experience supporting analytics, AI, or machine learning workloads.
• Experience within financial services, consulting, or other regulated industries.
• Familiarity with CI/CD, DataOps, and DevOps practices.
• Experience with Microsoft Purview.
• Experience mentoring junior engineers or leading technical workstreams.
• Knowledge of Infrastructure as Code tools such as Terraform, Bicep, or ARM Templates.

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 – up to 50% remote.
• 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.