As a Data Engineer at Dexters, you will play a vital role in developing and managing Dexters’ data integration projects, applying your expertise to seamlessly transition data from legacy systems into modern infrastructure, reporting and analytics.
Salary: £60,000-£65,000 DOE
Hours: Monday-Friday 8.30am-5.30pm
Location: London hubs with flexibility regarding working from home.
Reporting to: BI & Data Analytics Manager
Responsibilities:
● Design and develop a modern data warehouse, capable of ingesting data from multi sources and that can store and organize large volumes of data. They must use their expertise in data warehousing technologies to ensure that the data warehouse is efficient, scalable, and secure.
● Actively promote and deliver best practices in data architecture governance, security and privacy in line with regulations and industry standards.
● Develop and implement an automated, repeatable data migration process suitable for use over multiple project phases.
● Actively review data quality assessments, addressing any inconsistencies and apply data cleansing and validation techniques.
● Build data pipelines that clean, transform, and aggregate data from disparate sources.
● Collaborate with the software development and product teams to gain an understanding of and contribute to the evolution of Dexters’ business systems.
● Stay up-to-date with emerging trends and technologies in data engineering and property industry practices.
Requirements:
● Proven experience (3-5 years) as a data engineer.
● Right to work in the UK.
● Strong proficiency in SQL and database technologies (e.g. MS SQL, Snowflake)
● Hands-on experience with ETL/ELT tools(Azure Data factory, DBT,AWS Glue, etc)
● Strong Proficiency In Power BI and Advanced Analytics
● Proficiency in programming languages such as Python for data processing, scripting and automation.
● Any experience with DBT, Airbyte or similar transformation and replication products is hugely advantageous.
● Excellent problem-solving abilities, attention to detail and ability to work independently or in a team.
● Effective communication and interpersonal skills to foster relationships with stakeholders at all levels.
● Bachelor's degree in Computer Science, Information Systems, Data Science or a related field. A Master's degree would be advantageous.