The Vacancy
The Azure and Dynamics Data Engineer will be responsible for designing, implementing, and maintaining data solutions on the Azure platform, with a focus on integrating and managing data from Microsoft Dynamics 365.
The Key Responsibilities For The Role
Maintain data standards and quality, including adherence to the Data Protection Act.
Document data standards, procedures and definitions for the data dictionary (metadata).
Develop and maintain high quality data integration solutions
Manage the security and disaster recovery aspects of databases and platforms.
Monitor database access, security and manage access permissions and privileges.
Monitor performance and manage parameters to provide fast responses to the business.
Develop, manage and test back-up and recovery plans.
Carry out capacity planning and ensure that storage and archiving procedures are functioning correctly.
Liaise with product and solution management, platforms and operational staff to ensure database integrity and security are maintained.
Work with the business to investigate and transform business data, adopting technologies and frameworks for the visualisation of data both for clients and internal business analysis.
Incorporate new types of data including geodata and database solutions and investigate/solutions for the transfer of this data utilising cloud technology.
Support the ongoing data collection/analysis for our Dynamics 365 applications and Power BI continuous improvement programmes.
Essential
Experience, Skills \& Qualifications required:
A solid understanding of database design, development, administration and optimisation using Microsoft Azure SQL.
Experience in using databases on Azure Cloud platform and ensuring security and enterprise regulations and being followed.
Data warehouse and data modelling experience (star schemas).
Experience of data maintenance and cleansing using Azure SQL.
Expertise in data modelling principles/methods including conceptual, logical \& physical Data Models.
Experience in data visualisation tools (preferably Power BI, SSRS and Excel).
Experience automating tasks using PowerShell, C#, Power Automate, Azure Data Factory or similar tools.
An aptitude for IT and an up-to-date knowledge of common applications and systems.
Excellent oral and written communication skills.
Must be able to prioritise and manage multiple tasks.
Desirable
Data migration experience with the Dynamics 365 platforms.
A good understand of modern business architecture including data lakes, big data projects, helping to drive innovation and growth.
Experience of Agile development methodology.
Experience with SQL Server Integration Services.
SharePoint online management and development.
Our preference is to recruit directly wherever possible. Should this role be approved for support from external recruitment partners, we will contact our PSL agencies accordingly.
Please note that we do not accept unsolicited CVs from agencies. Effective introduction of a candidate will only be accepted if it has been requested to submit CVâs in relation to a specific vacancy. Any speculative submissions will not incur a fee. For any queries, kindly reach out to the appropriate Talent Acquisition team member.
The Company
Hollis is a leading independent real estate consultancy. We work with owners, occupiers, developers and funders, across both private and public sectors, to help them get more out of their real estate, at every stage of the property life cycle.
Weâre a multi-skilled team of surveyors, engineers, ESG consultants, project managers and technical specialists operating across the UK, Ireland, Germany, Spain and The Netherlands. We have a unique way of working and believe that people do things better by doing them together. We aim to do the right thing, be clear, transparent and find some fun along the way.
Why join us?
We are hardworking, progressive, successful and fun. Weâre independently-owned and independently-minded, not afraid to give honest advice or to be ourselves. We aim to achieve the right balance for you, delivering excellent client service whilst supporting you in fulfilling your potential and achieving your goals.
We offer a highly attractive salary and a generous benefits package including:
Life assurance and private medical insurance
Season ticket loan
5% Employer pension contribution
25 days of holiday and an extra day off on your birthday
Cycle to work scheme, retail vouchers, gym discounts and more
EV car scheme
Longevity awards
Hollis operates a hybrid-working policy giving employees the opportunity to work between their home and our offices, where their job allows it. In addition, employees are encouraged to request flexible working hours when needed and we work hard to accommodate where we can.
We are a sociable bunch and host pay day drinks, quarterly lunches, quiz nights and cultural and sporting activities to socialise and have fun with your colleagues. We also give back and take part in numerous charity events all over the country throughout the year.
We're Inclusive
Together we welcome, we embrace, and we celebrate our differences. Our aim is to provide a diverse and inclusive workplace which supports and cares for all our employees, including those from underrepresented or non-dominant groups. Weâre focused on a culture of inclusion; where all barriers including prejudice are removed from our working environment; and where all our people are empowered to be the best they can be.
Donât meet every single requirement? If you would like the opportunity to join Hollis but your past experience is not an exact match, we encourage you to apply anyway as you could be the right candidate for this role or another role within the company.
If you require alternative formats of our documents or need to apply offline, please get in touch with the talent acquisition team: talentacquisition@hollisglobal.com or call us on 020 7622 9555.
Hollis is a leading independent real estate consultancy. We work with owners, occupiers, developers and funders, across both private and public sectors, to help them get more out of their real estate.
Weâre a multi-skilled team of surveyors, engineers, ESG consultants, project managers and technical specialists operating across the UK, Ireland and mainland Europe. We have a unique way of working and believe that people do things better by doing them together. We aim to do the right thing, be clear, transparent and find some fun along the way.
Being friendly and down-to-earth has always been crucial for us. Weâve consistently been rated by The Sunday Times, Property Week and Estates Gazette as a âbest place to workâ, and our employee-owned structure proves that we really do put our people first.
Day to day youâll get to experience and test yourself on a great variety of challenges, with support, encouragement and learning all the way. Weâll help you shape and pursue your own career, making sure you have the training and opportunities you need to achieve your best. And youâll find we take care of you in a whole range of ways that make Hollis a healthy and happy place to work. We have fun too, with away days and a lively social calendar.