Data Engineer

Knight Frank is the leading independent property consultancy in the UK offering agency and professional advice across Commercial, Residential and Rural sectors. Established in 1897, Knight Frank now comprises a global network of over 400 offices.

Due to the rapid growth of data and analytics capabilities within the organisation, an exciting new role has opened up for a Data Engineer to strengthen and advance the consolidation and automation of our multiple company data sets.

Supported by the wider Data and Digital teams you will carry out and bring together multiple data sets into a single data platform.  You will streamline and consolidate data sets as well as advice on best practice.

The role will require someone who has strong SQL Server and Azure data integration background as well as API experience to access multiple data sets from multiple sources.  You will have the tenacity to see through complex problems and automating laborious tasks, as well as the vision and spontaneity to contribute new ideas that gain traction within the team.  Coming up with new ideas is actively encouraged.

Responsibilities

• To work with the multiple teams to extend the team’s data integration, modelling and reporting capabilities
• You will be responsible for defining and delivering high quality data platform solutions
• Provide solution and integration development requirements, functional specs, design, custom development, integration, testing, and deployment
• Integration of data across disparate systems by transforming and loading data into the Azure data platform
• Product ownership - taking responsibility for the data solutions right through the lifecycle, from design and development through to service transition and support
• To actively build thorough understanding of the customer, customer journey and the market to ensure that the correct data is captured
• To be able to work with a degree of independence on projects
• To ensure the wider Data team have easy access to the data
• To work with multiple stakeholders and Knight Frank teams on wider projects
• To be able to analyse complex datasets and cleanse data
• To be able to advise other parties on best practice regarding data integration and modelling

Experience

• Demonstrated experience that requires the understanding of the underlying data structures and integration methods and uses them to quickly develop solutions within agreed timelines
• Developing ETL/ ELT pipelines within Azure environment, specifically with Azure Data Factory
• Solid experience with data modelling, data warehouse design and data lake concepts and practices
• Working with multiple stakeholders across multiple disciplines to understand their data requirements
• Automating processes
• Connecting to external APIs following standard infosec protocols
• Write clean, effective and reusable code with notes for others throughout
• Proactive to remain up to date with latest technologies and techniques
• Demonstrated experience working effectively as part of a team, showing strong collaboration and resourcefulness
• Experience developing and managing new and existing partnerships with 3rd party vendors

Systems

Strong experience with the following

• Azure Data Factory
• SQL Server (2017)
• Azure Data Lake Storage Gen2

Experience of the following desirable but not essential

• Power BI
• Azure Synapse Analytics
• SSIS
• Alteryx
• GA 360

Particular Aptitudes/Skills Required

• Highly organised, systematic and adaptable with an excellent attention to detail, with the ability to recognise the relative importance of software issues and to prioritise work effectively
• Ability to communicate clearly and deal with others at all levels in a polite, professional, friendly and helpful manner, both face to face, by email and on the telephone and maintain a good working relationships at all times
• Demonstrated an ability to work on multiple projects simultaneously
• Ability to work with all members of the team, in a professional and yet dynamic and creative environment, fostering an open, friendly and constructive working relationship with all members of the Knight Frank team
• Ability to work within a high pressure environment, balance priorities and remain calm under pressure
• The successful candidate will be flexible, self-motivated, organised and pro-active with excellent computing and administration skills and the ability to adapt to a wide range of tasks. They will also have a “hands on” attitude and possess the necessary skills, manner and experience to provide an effective support service to the department/office
• Desire to learn new technologies and continuously develop new skills and expertise
• Ability to work out of hours to deliver application upgrades in agreed maintenance windows.

We are proud supporters of Women in Data®.  Connect, engage and belong to the largest free female data community in the UK – visit: www.womenindata.co.uk to join our community.