Senior Data Engineer – Microsoft SQL Server & Fabric (English-Proficient Position)

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!

If you're enthusiastic about contributing your skills and experience to our organization, we invite you to submit your CV for this position.

What we offer you in Colombia

• Indefinite contract with Intellias Colombia SAS, payment in COP
• Health, life, funerary and pet insurance for the employee
• Extra vacation days
• Workation up to 90 day outside Colombia
• 100% work from home + internet subsidy
• 100% English environment

Requirements

• 7+ years of experience in Data Engineering, ETL, Data Warehousing, or BI development.
• Practical experience with Microsoft Fabric (Mandatory)
• Strong hands-on experience with Microsoft SQL Server and T-SQL.
• Experience developing and supporting SSIS packages and ETL processes.
• 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.
• Git, Azure DevOps, or CI/CD experience.

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.