Data Engineer – Microsoft SQL Server & Fabric

Location: Intellias Meet your recruiter Diana Meneses diana.meneses@intellias.com https://www.linkedin.com... Vacancy details Data Engineering Data Engineer Senior Colombia, United States Remote APPLY NOW REFER A FRIEND We are looking for a Middle Data Engineer to develop and modernize enterprise data integration solutions within a Microsoft-based data ecosystem. The role combines strong hands-on experience with Microsoft SQL Server and SSIS with growing adoption of Microsoft Fabric for modern ETL/ELT, data warehousing, and analytics workloads. What project we have for you The project supports enterprise data integration and analytics for a large global manufacturing organization. The data landscape integrates information from ERP, business applications, APIs, databases, and flat files. The team maintains existing SQL Server / SSIS solutions while progressively adopting Microsoft Fabric and modern cloud-based data architecture. The role is primarily focused on data engineering, ETL/ELT, integration, and data platform development , rather than dashboard development. What you will do 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. What you need for this 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. Git, Azure DevOps, or CI/CD experience. What it’s like to work at Intellias At Intellias, where technology takes center stage, people always come before processes. By creating a comfortable atmosphere in our team, we empower individuals to unlock their true potential and achieve extraordinary results. That’s why we offer a range of benefits that support your well-being and charge your professional growth. We are committed to fostering equity, diversity, and inclusion as an equal opportunity employer. All applicants will be considered for employment without discrimination based on race, color, religion, age, gender, nationality, disability, sexual orientation, gender identity or expression, veteran status, or any other characteristic protected by applicable law. We welcome and celebrate the uniqueness of every individual. Join Intellias for a career where your perspectives and contributions are vital to our shared success.