Data Engineer

Lean Solutions Group; Bogotá; Remote; COP 70,000,000 - 110,000,000; Full time

Job summary

Lean Solutions Group is seeking a Data Engineer to join the Performance Management & Business Intelligence team. You will build and optimize data pipelines, model data for analytics, and support governance and CI/CD.

This role emphasizes strong SQL/Python skills and experience with Fabric or similar lakehouse platforms, plus Power BI expertise. The position is remote, full-time, aligned with US business hours, and requires clear English communication.

Qualifications

• 3+ years hands-on data engineering experience.
• Strong SQL and Python (PySpark) skills.
• Experience with lakehouse platforms such as Fabric, Databricks, Synapse or ADF.
• Proficiency in Power BI and semantic models.
• Excellent written and verbal English communication.

Responsibilities

• Build and maintain data pipelines and lakehouse architecture.
• Integrate data from CRMs, APIs, SaaS apps, SharePoint, Excel and internal systems.
• Develop Bronze, Silver, and Gold data layers.
• Design data models and datasets for analytics and Power BI.
• Implement data quality checks, monitoring, validation, and alerting.
• Support data governance, lineage, security, and access management.
• Automate data processes and support CI/CD and release management.
• Collaborate with BI, PM, Workforce Management, IT, Finance and client teams.

Skills

SQL

Python

PySpark

Data modeling

Data pipelines

APIs

Automation

Power BI

Data quality

Governance

Monitoring

Version control

English communication

Tools

Microsoft Fabric

Databricks

Synapse

Azure Data Factory

Job description

Lean Solutions Group is a workforce optimization company supporting U.S. logistics, freight brokerage, factoring, and related industries through nearshore and offshore teams, technology, and data-driven solutions.

We are looking for a Data Engineer to join our Performance Management & Business Intelligence team and contribute to the development and operation of the data foundation that supports reporting, analytics, and business decision-making.

Key Responsibilities

• Build and maintain data pipelines and lakehouse architecture using Microsoft Fabric.
• Integrate data from CRMs, APIs, SaaS applications, SharePoint, Excel, and internal systems.
• Develop and maintain Bronze, Silver, and Gold data layers.
• Design data models and datasets for analytics and Power BI.
• Implement data quality checks, monitoring, validation, and alerting.
• Support data governance, lineage, security, and access management.
• Automate data processes and support CI/CD and release management.
• Collaborate with BI, Performance Management, Workforce Management, IT, Finance, and client teams.

Requirements

• 3+ years of hands-on Data Engineering experience.
• Strong SQL and Python skills, including PySpark.
• Experience with Microsoft Fabric or a comparable lakehouse platform such as Databricks, Synapse, or Azure Data Factory.
• Experience with data modeling, data pipelines, APIs, and automation.
• Working knowledge of Power BI and semantic models.
• Experience with data quality, governance, monitoring, and version control.
• Strong written and verbal English communication skills.

Experience working with BPO, logistics, contact center, workforce management, or shared services data is preferred.

Modality: Remote

Schedule: Full-time, aligned with U.S. business hours