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. This role demands a proactive approach to understanding and automating complex data integrations, ensuring data integrity and alignment with Dexters’ business needs.
Salary: £50,000-£55,000 DOE
Hours: Monday-Friday 8.30am-5.30pm
Location:London hubs, Feltham, Liverpool Street with flexibility regarding working from home.
Responsibilities:
● Design and develop a modern data warehouse(Azure or Snowflake), 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:
● Bachelors degree in Computer Science, Information Systems, Data Science or a related field. A Masters degree would be advantageous.
● Proven experience (3-5 years) as a data engineer.
● 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, C# or Scala for data processing, scripting and automation.
● Any experience with DBT, Airbyte or similar transformation and replication products is hugely advantageous.
● Experience with data migration and mapping complex relational data between business systems.
● Strong analytical skills with the ability to translate business requirements into data engineering solutions.
● 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.