Data engineer in financial services

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

Benefits offered by this job

Visa sponsorship

Relocation assistance

Hybrid work up to 50% remote

Career development plan

Training programs

Certification sponsorship

Job summary

LGG Advisors is seeking a senior Data Engineer to design, develop and maintain enterprise data platforms using Microsoft Fabric and related technologies. You will build end-to-end data pipelines and implement Medallion Architecture (Bronze, Silver, Gold) to support scalable analytics and AI use cases.

You'll collaborate with consultants, engineers and product owners in agile environments, ensuring governance, security and quality.

Qualifications

• Bachelor's degree in Computer Science, Engineering, Information Systems, Mathematics, Statistics, Data Engineering, or related field.
• Professional proficiency in English.
• 5+ years of experience in Data Engineering, Data Platform Development, or Data Architecture.
• Minimum 2 years’ hands-on experience with Microsoft Fabric across end-to-end data lifecycle.
• Proven implementation of Medallion Architecture in production environments.
• Experience with Lakehouse, Data Warehouse, Data Factory and Power BI Semantic Models.
• Strong SQL and Python skills.
• Experience developing scalable ETL/ELT pipelines.
• Experience with Apache Spark, Delta Lake, and modern cloud data architectures.
• Familiarity with Azure cloud services and enterprise architecture principles.
• Experience working in agile delivery environments.

Responsibilities

• Design, develop and maintain enterprise-grade data platforms utilizing Microsoft Fabric and related technologies.
• Design and implement Medallion Architecture (Bronze, Silver, Gold) for scalable analytics solutions.
• Build, optimize and maintain end-to-end data pipelines across ingestion, transformation, orchestration, storage, quality and monitoring.
• Develop solutions using Fabric Data Factory OneLake, Lakehouse, Data Warehouse, Notebooks, Semantic Models, and Power BI.
• Design scalable ETL/ELT processes and data models for 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.

Skills

Data Engineering

Data Platform

SQL

Python

Azure

Power BI

Education

Bachelor's degree in a related field

Tools

Microsoft Fabric

Azure Data Factory

Power BI

Delta Lake

Databricks

Azure Synapse

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.

Задачи:

• 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.

Требования:

• Bachelor's degree in Computer Science, Engineering, Information Systems, Mathematics, Statistics, Data Engineering, or a related field.
• Professional proficiency in English.
• 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 developing scalable ETL/ELT pipelines.
• 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.
• Будет плюсом: 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

Условия:

• Fast‑growing company with a presence in Porto, Lisbon, 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.