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
We offer
-
International projects with top brands
-
Work with global teams of highly skilled, diverse peers
-
Healthcare benefits
-
Employee financial programs
-
Paid time off and sick leave
-
Upskilling, reskilling and certification courses
-
Unlimited access to the LinkedIn Learning library and 22,000+ courses
-
Global career opportunities
-
Volunteer and community involvement opportunities
-
EPAM Employee Groups
-
Award-winning culture recognized by Glassdoor, Newsweek and LinkedIn
EPAM is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, sexual orientation, gender identity or expression, disability, protected veteran status, or any other characteristic protected by applicable law.
