Data Engineer

Trading since 1989, e.surv Chartered Surveyors is the UK's number one residential surveyor and the largest provider of property risk expertise and residential surveying services. To put it into numbers, we complete more than one property inspection every 12 seconds and employ over 600 surveyors from Land’s End to John O’Groats and Northern Ireland. This gives us the flexibility to offer nationwide coverage combined with invaluable local knowledge.

We're part of the LSL Property Services Group PLC, which includes household names Your Move and Reeds Rains as well as the mortgage network PRIMIS. We work with lenders, intermediaries, social housing entities and estate agents in addition to private customers.

Reporting to the Head of Data, this is an exciting time to be joining the Data and Analytics team, where we truly believe in the value of being a Data driven organisation. We are searching for a good communicator and facilitator, capable of understanding and refining non-technical descriptions into actionable stories with very good stakeholder management skills.

Responsibilities will include building and maintaining data pipelines, models, automation routines and the management of data warehouses; whilst providing consultation and guidance on integrating new data sources into the warehouse and to facilitate data usage.

Main Accountabilities:

• Create and maintain ETL pipelines.
• Automate data management tasks.
• Create and provide observability.
• Document data pipeline and storage.
• Maintain data dictionaries and lineage diagrams.
• Consult on Data source integration and usage.

Knowledge and Expertise - (relating to specialist knowledge and expertise required to undertake the role).

Essential

• Data Architecture and management.
• SQL and TSQL understanding and programming.
• Knowledge and use of SQL Server integration services.
• Source code management.
• MSSQL server.
• Azure.

Desirable

• Power Bi.
• CICD/Data-Ops processes and environments.
• GIT
• Python

Experience, Qualifications and other requirements specific to the role

Essential

• Experience in creating and maintaining complex SQL code.
• Experience in all stages of SSIS ETL package lifecycle.
• Creating and maintaining data dictionaries.
• Master data management.
• At least two years’ experience working in a data management role.

Qualifications

• Microsoft SQL (nice to have).
• MS power BI.

Apply

If you feel you match our requirements and are looking for your next career challenge, or for a confidential discussion on the full details of this role please contact Mike Brett.

LSL Property Services are dedicated to protecting your data - our Recruitment Privacy Notice can be viewed HERE.

PRE EMPLOYMENT SCREENING - All of our employees have to pass a Criminal Records Disclosure and Credit Referencing Process in order to work with our lender clients, if you are unsure on this, ask the team and we'll be happy to explain the process.