Skip To Main Content
backBack to Search

Senior Data Engineer - SSIS, KingswaySoft

Hybrid in Mexico
Data Software Engineering, Consultancy
Looking for something else?

Find a vacancy that works for you. Send us your CV to receive a personalized offer.

Find me a job

We are seeking a Senior Data Engineer specializing in SSIS and KingswaySoft to design, develop and implement integration solutions between enterprise platforms such as Dynamics 365, Salesforce, SharePoint and other SaaS/On-Premise applications. This role focuses on building robust ETL processes, optimizing data flows and ensuring seamless integration across systems.

Responsibilities
  • Design and develop SSIS packages with KingswaySoft components
  • Perform data migrations between enterprise platforms
  • Integration of Dynamics 365 with external systems such as Salesforce and ERP
  • Optimize ETL flows for large volumes of data
  • Documentation of integration architectures and processes
  • Troubleshoot and support integrations in production
  • Collaborate with functional teams for data mapping
  • Participate in gathering technical requirements
  • Implementation of best practices in SSIS development
  • Manage the deployment of packages in production environments
Requirements
  • 3+ years of experience in data integration and ETL development
  • Expertise in Microsoft SSIS including ETL package design, Control Flow and Data Flow
  • Proficiency in error handling, logging, deployment and administration
  • Skills in KingswaySoft SSIS Integration Toolkit, connectors and Dynamics 365 Productivity Pack
  • Knowledge of Microsoft Dynamics 365 entities, data schema and Dataverse
  • Familiarity with CRM, Sales and Customer Service modules
  • Competency in SQL Server with advanced T-SQL, stored procedures and query optimization
  • Understanding of SQL Server Agent
  • Capability to diagnose complex errors in data flows and design logical integration architectures
  • Flexibility to adapt to new versions and connectors while handling multiple integrations in parallel
  • English proficiency at B2 level or higher
Nice to have
  • Knowledge of Azure Data Factory, Azure SQL and Azure Blob Storage
  • Familiarity with Power Platform (Power Automate), Salesforce data structures and SharePoint Online
  • Skills in REST APIs, JSON and C#/.NET for SSIS scripting
  • Proficiency in Visual Studio/SSDT, Git and DevOps/CI/CD for SSIS
  • Understanding of Postman for API testing