Data Integration Engineer - D365 & Power Platform

Job Description

Title: Data Integration Engineer - D365 & Power PlatformContract type: Permanent, Full TimeLocation: Stratford, London and homeworkingPersona: Agile, Office based 20-40%Salary: £50,000 - £60,000 depending on experience and locationClosing date: 14th October2021Early applications are encouraged as we reserve the right to close the advertisement and interview earlier than statedDue to COVID19, colleagues in eligible roles are currently working from home in line with government guidelines.A great opportunity hasarisen for an experienced D365 & Power Platform Data Integration Engineer to join L&Q at a very exciting time where we will invest, grow and transform our business to provide a better service to customers old and new.As a D365 & Power Platform Data IntegrationEngineer, you will act as a data specialist within a D365/Power Platform team and be responsible for all core data migration and integration activities within the team. This will include building, deploying, and supporting solutions that consolidate data fromvarious data sources, and provide user access via the Microsoft Dynamics 365 and Power Platform.Additionally, you will also ensure that data quality, integrity and completeness is maintained across Microsoft Dynamics 365/Microsoft Dataverse, as well as helptroubleshoot and resolve any data issues or concerns that impact our business.You will report into an Engineering Principal but be aligned to an Agile engineering squad to build data integrations for key business requirements as defined by the organisation.The role will have a working relationship with our Solution Architect, D365 Engineers, as well as other architectural and engineering capabilities such as Software Engineers, Data Architects, Test Engineers, DevOps engineers, Solution Analysts and also thebusiness stakeholders that are essentially acting as your customer.The Data Integration Engineer will: Contribute to the squads performance and customer service delivery whilst operating in line with L&Q values, by hands on design, development, implementationand support of data migration and integration solutions Work with the Engineering Principals and Solution Architect to design and implement a streamlined automated ALM process across the various build environments within the D365 and Power Platform data SpaceWork with the squad and Service Delivery teams to support and resolve data concerns/issues across all new and existing L&Q D365 and Power Platform solutions including integration components. Produce technical and detailed design documentation in collaborationwith squad, Solution Architect and Engineering Principals Conduct technical presentations, workshops, and design sessions to strengthen our existing D365/Power Platform data capabilities Keep the Architects and Engineering Principals fully informed on alldata concerns and challenges; working together to implement continuous improvement practices. Work closely with Solution Architects, and Data Engineers to review and recommend improvements to existing D365/Power Platform data integrations. Share specialistknowledge in relevant technologies, applying this knowledge in the creation of effective solutions. Working alongside those within the product teams to help define, and set scope of sprints and projects Collaborate with Test Engineers to ensure adequate testingof user stories as they are being developed and ensure that completed user stories satisfy all the acceptance criteria Pro-actively demonstrate required behaviours in line with expectations of the role.Skills and Experience: Extensive hands on experience workingwith MS D365, CRM and Dataverse; including at least 2 years designing and implementing data migration and integration solutions between MS D365, Dataverse and various disparate cloud and on-premise data sources and systems Strong knowledge of T-SQL, SSIS,SSAS and SSRS (including FetchXML based reporting) Strong hands-on experience with ETL analysis, data transformations and tooling such as KingswaySoft and Scribe. Experienced in designing, coordinating, and implementing pilots, prototypes, or proof of conceptsWell versed with related D365 industry recognised tools and plugins like XRMToolBox, ERD Visio Builder and Data Transporter Tool Experience working with Azure data storage solutions such as Azure SQL, Blob Storage, and Cosmos DB. Experience of working in anagile environment with deep understanding of Agile and continuous delivery practices, including CI/CD using Azure Dev Ops, fast feedback, test automation, team autonomy, and monitoring. Deep and demonstrable understanding of various data migration and integrationstrategies. Ability to communicate and influence in a consultative manner whilst clearly articulating technology concepts is essential. Experience with databases and analytics, including relational databases (e.g. SQL Server) and Power BI (specifically DAXand M-Query). Deep understanding of MS D365 Data Export Services An appreciation and some experience of using Azure technologies such as Azure Logic Apps, Azure Service Bus and Azure Data Factory Good knowledge and experience of the following: Data modelling,Data Quality, Data Governance, Data security. MCPD certifications are highly desirableIf you have the skills and experience listed above and are interested in working for an organisation that can really make a difference to peoples lives, then apply today!Atthe foundation of everything that we do are our corporate values and associated behaviours. Our organisational behavioural framework outlines the core expectations of all employees, which should be demonstrated at all times when representing L&Q. More informationabout L&Qs values can be found on our website and a copy of our behavioural framework can be provided on requestCOVID 19: L&Q have a dedicated pandemic response team reacting to the current situation. The safety of our staff and our candidates is of the utmostimportance. Every effort will be taken to ensure that safe ways of working are adopted throughout the Recruitment and Selection process. We are introducing extra precautions in line with UK Government Guidelines. Our recruitment processes will follow socialdistancing and COVID-19 Safe requirements. This will include the use of various technologies to support the interview process. Should candidates have any questions regarding this, or if you require additional support please let us know at the interview planningstage.Our commitments:At L&Q, people are at the heart of our business and our success depends on employing the best people and getting the best from them. This is why we are committed to developing our people. Its only by investing in a well-trained and motivatedworkforce that we can continue to prosper and sustain business success.We are committed to supporting your work-life balance and recognise the changing demands and circumstances in life. Please let us know during the recruitment process if you