Data Engineer: End-to-End Pipelines & Data Quality

PartnerOne; Colombia; Presencial; COP 60.000.000 - 100.000.000; Jornada completa

Descripción de la vacante

PartnerOne is seeking a Data Engineer to design, build, and maintain robust data pipelines powering analytics, compliance, and reporting across the Mortgage Cadence Platform. The role emphasizes execution with growing end-to-end ownership of data workflows as familiarity with the platform grows.

Key requirements include Advanced SQL, experience with Microsoft Fabric Dataflow Gen2 and related ETL tools, and strong data modeling skills.

Formación

• Advanced SQL with optimization, window functions, performance tuning.
• Experience with Microsoft Fabric Dataflow Gen2, Notebooks, Lakehouse or equivalent ETL tools.
• Strong relational database design and dimensional modeling knowledge.
• Power Query / M data shaping and transformation.
• Python or similar scripting for data manipulation and automation.
• Git/version control basics for collaboration.
• Data quality frameworks including unit tests, assertions and validation rules.
• Ability to interpret business requirements and design efficient data solutions.
• Mortgage/lending domain familiarity preferred; willingness to learn domain.

Responsabilidades

• Design and build ETL pipelines using Microsoft Fabric (Dataflow Gen2, Notebooks, or equivalent tools).
• Write optimized SQL queries and transformations for data ingestion from source systems.
• Apply data quality checks and validation at each pipeline stage.
• Implement incremental loads and manage refresh schedules for performance.
• Escalate architectural questions to Lead for complex transformations.

Conocimientos

Advanced SQL

Relational database design

Dimensional modeling

Data quality

Business requirements interpretation

Data governance mindset

Data pipelines

Herramientas

Microsoft Fabric Dataflow Gen2

Notebooks

Lakehouse

Python

dbt

Talend

Informatica

Power Query / M

Git

Descripción del empleo

PartnerOne is seeking a Data Engineer to design, build, and maintain robust data pipelines powering analytics, compliance, and reporting across the Mortgage Cadence Platform. The role emphasizes execution with growing end-to-end ownership of data workflows as familiarity with the platform grows.

Key requirements include Advanced SQL, experience with Microsoft Fabric Dataflow Gen2 and related ETL tools, and strong data modeling skills.