Microsoft ETL Developer (with Dynamics 365)

*This position is fully remote only for employment in Bulgaria. However, people can also work in one of our offices in Sofia or Varna if they prefer to.

About DataArt

DataArt is a global software engineering firm and a trusted technology partner for market leaders and visionaries. Our world-class team designs and engineers data-driven, cloud-native solutions to deliver immediate and enduring business value.

We promote a culture of radical respect, prioritizing your personal well-being as much as your expertise. We stand firmly against prejudice and inequality, valuing each of our employees equally.

We respect the autonomy of others before all else, offering remote, onsite, and hybrid work options. Our Learning and development centers, R&D labs, and mentorship programs encourage professional growth.

Our long-term approach to collaboration with clients and colleagues alike focuses on building partnerships that extend beyond one-off projects. We provide the ability to switch between projects and technology stacks, creating opportunities for exploration through our learning and networking systems to advance your career.

Position Overview

Our client is a British bank, one of the largest finance companies in the world. The bank was founded three centuries ago, and today its assets are estimated at trillions of US dollars.

We’re looking for a Microsoft ETL Developer with hands-on experience in SSIS and Dynamics 365. You’ll design and implement ETL processes using the KingswaySoft Toolkit, ensuring smooth data migration and integration across business systems. Strong SQL skills and a solid understanding of data transformation and quality are key to this role.

Responsibilities

• Design, develop, and implement data integration processes using SSIS for integrating Dynamics 365 with other business applications
• Utilize KingswaySoft SSIS Integration Toolkit for Dynamics 365 to perform data migration, extraction, transformation, and loading (ETL) tasks
• Analyse business requirements to design robust and scalable data integration solutions between Dynamics 365 and various systems
• Develop, test, and deploy SSIS packages that handle complex data transformations and ensure smooth data flow into Dynamics 365
• Work with the Dynamics 365 platform to extract, load, and transform data from/to the system as required
• Ensure data quality, validation, and consistency during the data migration process
• Provide support for debugging, troubleshooting, and resolving integration issues
• Collaborate with other teams (business analysts, developers, and functional experts) to understand business needs and deliver data integration solutions
• Implement and maintain error logging, monitoring, and reporting to ensure smooth operation of integration processes
• Document integration processes and design specifications for future reference and support

Requirements

• Experience with SSIS: Strong hands-on experience with SQL Server Integration Services (SSIS), including designing and deploying SSIS packages
• Experience with Dynamics 365: Proven experience working with Microsoft Dynamics 365, especially in data migration, integration, and administration
• KingswaySoft Toolkit Expertise: Solid experience working with KingswaySoft SSIS Integration Toolkit for Dynamics 365 (CRM/ERP)
• SQL Skills: Proficient in writing complex SQL queries, stored procedures, and working with SQL Server databases
• Data Transformation: Ability to design and implement complex ETL processes for data transformation and migration
• Problem-Solving: Strong troubleshooting skills to identify and resolve data integration issues
• Communication: Ability to work with cross-functional teams and communicate effectively with business users, developers, and stakeholders

Nice To Have

• Experience with Data Migration Projects: Experience in large-scale data migration projects involving Dynamics 365
• Technical Documentation: Ability to document the integration process, data mappings, and workflows

What We Offer

• Unique corporate culture – no micromanagement, friendly atmosphere, freedom, and mutual respect
• Flexible schedule – ability to change projects, to work from home, and to try yourself in different roles
• Professional Development Map – a comprehensive map of your professional development within DataArt
• We hire people not for a project but for the company. If the project (or your work in it) is over, you go to another project or to a paid “Idle”.
• Social benefits – additional health insurance, life insurance, sports card, etc.
• Opportunity to work from another DataArt office in a different city or country (temporary or permanently)
• Free English courses
• Cozy office with a great atmosphere
• Snacks, drinks, and fruits are always available

_{reference number: DE00187}