Data Engineer – Microsoft SQL Server & Fabric
Data engineer at Intellias (Colombia, 100% remote) building and maintaining ETL/ELT pipelines, integrations, and data platforms using Microsoft SQL Server, T-SQL, SSIS, and Microsoft Fabric (Data Pipelines, Lakehouse, Data Warehouse, Dataflows Gen2). Focus is on data engineering and platform development, not dashboards.
- Compensation
- Not disclosed
- Location
- Colombia
- Work setup
- Remote
- Seniority
- Not specified
- Employment
- Contract
- Experience
- 7+ years
- Category
- Data engineering
- Posted
Skills
Must have
- 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
Full description
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.