SSIS Developer At Avanade, we see how the power of Dynamics 365 shapes the future of businesses every day. By combining our unmatched Microsoft knowledge with our creative approach to innovation and strong industry knowledge, we create a lot of opportunities for Microsoft, our clients, and for you. Avanade has countless paths for you to pursue. One of them is sure to lead to your unique version of success. Come join us We are looking for a seasoned Senior SSIS Developer with a strong background in data integration and ETL development, particularly using SQL Server Integration Services (SSIS). While the primary focus of this role is SSIS development, a working knowledge of Dynamics 365 CRM is highly desirable. The ideal candidate will bring deep expertise in SSIS and related technologies, with the ability to support CRM integrations, customizations, and enhancements as needed. You’ll solve problems using CRM solutions as you liaise between Avanade clients and project teams made up of Project Managers, Back-End and Front-End (UX) Architects, and other CE professionals. This role provides the opportunity to work for Microsoft’s #1 partner with an unrivalled focus on personal development and training in both technology and softer consulting skills. Together we do what matters. What you’ll do · SSIS Development (Primary): o Design, develop, and maintain SSIS packages for data extraction, transformation, and loading (ETL) processes. o Integrate data from various sources into Dynamics 365 and other internal systems. o Monitor, optimize, and troubleshoot SSIS jobs to ensure efficient and reliable data flow. · CRM Customization & Integration (Secondary): o Customize Dynamics 365 entities, attributes, views, forms, and workflows. o Use C# Web APIs to develop integrations between CRM and other systems. o Utilize tools like XRM Toolbox and REST APIs for CRM data manipulation. · Version Control & DevOps: o Use Bitbucket for version control and collaboration. o Participate in CI/CD pipelines using tools such as Jenkins for deploying data and CRM solutions. · Development & Testing: o Write clean, maintainable, and well-documented code in C# and JavaScript. o Conduct unit testing using frameworks that mock CRM Context and Http Context. Skills and experiences * 6+ years of experience with SSIS and ETL processes in enterprise environments. * Strong command of SQL Server, including T-SQL, stored procedures, and performance tuning. * Proficient in C# and object-oriented programming. * Familiarity with Dynamics 365 CRM customization and solution management. * Experience with Bitbucket, Web API, JavaScript, and RESTful services. * Understanding of DevOps practices, especially with Jenkins pipelines. * Solid problem-solving skills and ability to work in a collaborative team environment. Good to Have: * Microsoft Power Platform or Dynamics certifications. * Experience with SSIS and KingswaySoft tools. * ReactJS experience for front-end development. About you Characteristics that can spell success for this role · Analytical, curious, agile · Team player and good communicator · Problem-solver, patient, quality-driven · Self-motivating · Innovative mindset Enjoy your career Some of the best things about working at Avanade · Opportunity to work for Microsoft’s Global Alliance Partner of the Year (14 years in a row), with exceptional development and training (minimum 80 hours per year for training and paid certifications) · Real-time access to technical and skilled resources · Collaborate with some of the brightest "Microsoft minds" · Build your expertise, solve problems, learn, and develop Find out more about some of our benefits [1] here. A great place to work As you bring your skills and abilities to Avanade, you’ll get distinctive experiences, limitless learning, and ambitious growth in return. As we continue to build our diverse and inclusive culture, we become even more innovative and creative, helping us better serve our clients and our communities. You’ll join a community of smart, supportive collaborators to lift, mentor, and guide you, and to lean on your expertise. You get a company purpose-built for business-critical, leading-edge technology solutions, committed to improving the way humans work, interact, and live. It’s all here, so take a closer look! We work hard to provide an inclusive, diverse culture with a deep sense of belonging for all our employees. Visit our [2] Inclusion & Diversity page. Create a future for our people that focuses on • Expanding your thinking • Experimenting courageously • Learning and pivoting Inspire greatness in our people by • Empowering every voice • Encouraging boldness • Celebrating progress Accelerate the impact of our people by • Amazing the client • Prioritizing what matters • Acting as one Learn more To learn more about the types of projects our team works on, check out these case studies: • What matters to Rathbones is people-first workplace experiences and sustainability • VentilatorChallengeUK manufactures 20 years’ worth of ventilators in 12 weeks to help save lives Interested in knowing what’s going on inside Avanade? Check out our blogs: • Avanade Insights - exchange ideas that drive tomorrow’s innovation • Inside Avanade - explore what life is like working at Avanade References Visible links 1. https://www.avanade.com/en-gb/career/benefits 2. https://www.avanade.com/en-us/about-avanade/inclusion-and-diversity We work hard to provide an inclusive, diverse culture with a deep sense of belonging for all our employees. Avanade believes that all persons are entitled to equal employment opportunities, and we do not discriminate against our employees, applicants, or job seekers because of their race, color, gender, religion, national origin, disability, veteran status, age, marital status, sexual orientation, genetic information, gender identity, or any other protect group status as defined by law.