Data Engineer in UNITED KINGDOM

Job Title: Data Engineer

Job Summary

We are seeking a talented and experienced Data Engineer to join our team. The ideal candidate will have a strong background in ETL processes, SQL, and experience with managing multiple data sources and loading them into one data warehouse. This role involves designing, developing, and maintaining data pipelines, ensuring data quality, and delivering actionable insights through business intelligence tools.

Key Responsibilities

• Integrate data from diverse internal and external sources, ensuring data quality and consistency (currently management system via CSV, Excel spreadsheets, legacy systems, Sage and CRM).
• Design, build, and maintain efficient and scalable ETL processes to extract, transform, and load data from various data sources.
• Write, optimize, and troubleshoot complex SQL queries for data extraction, transformation, and analysis.
• Develop and maintain Power BI dashboards and reports to provide actionable insights and support data-driven decision-making.
• Manage and maintain the data warehouse ensuring data is accessible and well-organized.
• Conduct data quality assessments and implement data cleansing and validation processes.
• Stay current with industry trends and emerging technologies in data engineering and business intelligence.

Qualifications

• Detailed experience in data engineering, with a focus on ETL processes, SQL, and BI tools.
• Proficiency in SQL and database management systems (e.g., MySQL, PostgreSQL, SQL Server).
• Experience with ETL tools and frameworks.
• Strong knowledge of Power BI for developing dashboards and reports.
• Familiarity with data warehousing solutions and data modelling.
• Excellent problem-solving skills and attention to detail.
• Strong communication and interpersonal skills.

Benefits

• Competitive salary
• Company pension
• 25 days leave
• Cardiff-based but fully remote is considered
• Carefirst (essentially first counselling)

Join our team and help us transform data into valuable insights that drive business success. If you are passionate about data engineering and business intelligence, we encourage you to apply.