Data Engineer – Microsoft SQL Server & Fabric

At Intellias, we're always on the lookout for exceptional talent to join our team in Colombia. Over 20 years of market experience, Intellias brings together technologists, creators and innovators in Europe, North and Latin America, and the Middle East. Join our international team and take the mission to solve the advanced tech challenges of tomorrow!

The role is primarily focused on data engineering, ETL/ELT, integration, and data platform development, rather than dashboard development.

What we offer you in Colombia

Indefinite contract with Intellias Colombia SAS, payment in COP

Health, life, funerary and pet insurance for the employee

Workation up to 90 days outside Colombia

Training and certifications

100% work from home + internet subsidy

Requirements:

• 7+ years of experience in Data Engineering, ETL, Data Warehousing, or BI development.
• Strong hands-on experience with Microsoft SQL Server and T-SQL.
• Experience developing and supporting SSIS packages and ETL processes.
• Practical experience with Microsoft Fabric.
• Experience with Fabric components such as Data Pipelines, Lakehouse, Data Warehouse, or Dataflows Gen2.
• Strong understanding of ETL/ELT patterns, data integration, and data transformation.
• Experience with relational database design and data warehousing concepts.
• Ability to develop and optimize stored procedures, views, functions, and complex SQL queries.
• Experience troubleshooting data pipelines, scheduled jobs, and integration failures.
• Understanding of data validation, error handling, monitoring, and data quality.
• Experience integrating data from multiple enterprise systems and data sources.

Nice to Have:

• Experience with Azure Data Factory or Azure Synapse Analytics.
• Understanding of OneLake and Medallion Architecture.
• Experience with Power BI datasets or semantic models.
• Experience integrating ERP systems such as SAP.
• REST API and file-based integrations.

Responsibilities:

• Develop and maintain data integration solutions using SQL Server, T-SQL, and SSIS.
• Build and support ETL/ELT pipelines in Microsoft Fabric.
• Integrate data from ERP systems, applications, APIs, databases, and files.
• Develop and optimize SQL queries, stored procedures, and database objects.
• Support migration and modernization of legacy data workloads toward Microsoft Fabric.
• Implement data validation, monitoring, logging, and error-handling mechanisms.
• Troubleshoot and optimize data pipelines and scheduled ETL processes.
• Support data warehouse and Lakehouse structures for downstream analytics.
• Collaborate with BI, application, and business teams on data requirements.
• Maintain technical documentation and engineering standards.

At Intellias, where technology takes center stage, people always come before processes. We're dedicated to cultivating a tech-savvy environment that empowers individuals to unlock their true potential and achieve extraordinary results. Our customized benefits not only prioritize your well-being but also charge your professional growth, making this opportunity an ideal match for tech enthusiasts like you.