Title: Data Integration Engineer - D365 & Power Platform
Contract type: Permanent, Full Time
Location: Stratford, London and homeworking
Persona: Agile, Office based 20-40%
Salary: £50,000 - £60,000 depending on experience and location
Closing date: 14th October 2021

Early applications are encouraged as we reserve the right to close the advertisement and interview earlier than stated     
  

Due to COVID19, colleagues in eligible roles are currently working from home in line with government guidelines.

A great opportunity has arisen 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 Integration Engineer, 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 from various 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 help troubleshoot 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 the business stakeholders that are essentially acting as your customer.

The Data Integration Engineer will:

·       Contribute to the squad’s performance and customer service delivery whilst operating in line with L&Q values, by hands on design, development, implementation and 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 Space

·       Work 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 collaboration with 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 all data 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 specialist knowledge 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 testing of 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 working with 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 concepts

·       Well 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 an agile 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 integration strategies.
 

·       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 DAX and 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 desirable

If you have the skills and experience listed above and are interested in working for an organisation that can really make a difference to people’s lives, then apply today!

At the 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 information about L&Q’s values can be found on our website and a copy of our behavioural framework can be provided on request

COVID 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 utmost importance. 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 social distancing 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 planning stage.

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. It's only by investing in a well-trained and motivated workforce 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’re interested in part time working or job sharing.  In addition, should your circumstances change once you have joined L&Q, you can also request flexible working arrangements, e.g. a change to working hours - if it’s feasible then we’ll make it happen.

We are recognised externally for our commitment to inclusion.  We are a Stonewall Diversity Champion, a Disability Confident (Committed) employer and have signed the Time to Change Employer Pledge to demonstrate our commitment to end mental health discrimination in the workplace.

We expect all of our employees to support our environmental policy and social responsibility work. We are an employer committed to environmental and social responsibility.

L&Q is a regulated charitable housing association and one of the UK’s most successful independent social businesses. The L&Q Group houses around 250,000 people in more than 97,000 homes, primarily across London and the South East.

As a charitable organisation, our role goes beyond providing homes and housing services. We are a long-term partner in the neighbourhoods where we work. We hope to build aspiration, opportunity and confidence in our communities through our £250 million L&Q Foundation and our skills academy. 

In response to the housing and affordability crisis, we will build 100,000 new homes over ten years. Of these, 60,000 homes will be built or funded by L&Q, whilst a further 40,000 will come through partnerships. Crucially, at least 50% of these new homes will be genuinely affordable, with a target of 60% in London.

Our vision is that everyone has a quality home they can afford, and we combine our social purpose with commercial drive to create homes and neighbourhoods everyone can be proud of.