Senior Data Engineer

JR United Kingdom; Watford; On-site; GBP 40,000 - 70,000; Full time

Job summary

An established industry player is seeking a skilled Data Engineer to join their dynamic team. In this role, you'll collaborate closely with the CTO and Data and Reporting Manager to shape the future of data reporting strategies. Your expertise in SQL, Amazon Redshift, and visualization tools will be crucial as you develop and enhance MI and BI reports. This innovative firm values teamwork and mentorship, providing an environment where you can support junior members while driving impactful data solutions. If you're passionate about data and eager to work with cutting-edge technologies, this is the perfect opportunity for you.

Qualifications

• 4+ years of experience as a Data Engineer or similar role.
• Extensive experience with SQL and Amazon Redshift.
• Experience developing ETL & ELT processes from multiple data sources.

Responsibilities

• Work closely with the CTO & Data and Reporting Manager on strategies.
• Hands-on development of MI & BI reports for various business units.
• Support and mentor junior team members.

Skills

SQL

Amazon Redshift

MySQL

ETL processes

Python scripting

Agile methodologies

Mentoring

Data analysis

Team collaboration

Problem-solving

Tools

Amazon QuickSight

AWS Glue

JIRA

Confluence

Job description

Social network you want to login/join with:

• Work closely with the CTO & the Data and Reporting Manager to define and implement the short & the long-term strategies around Data & MI reports.
• Communicate effectively with internal customers and third parties.
• Analyse both large and complex reporting requirements.
• Collaborate effectively with Product Owners, Developers, Designers, DevOps Engineers, and the wider business.
• Hands-on development of MI & BI reports for the various business units.
• Work with four other Data Engineers / Reporting Developers, and the Data and Reporting Manager.
• Support, mentor and help the more junior members of the team.
• Test and cross validate reports for accuracy and integrity.
• Perform regular, technical reviews of your team’s work.
• Analyse and recommend enhancements to the MI reports, processes, and standards.
• Assist with resolution of support issues.

Requirements

• 4+ years of experience as a Data Engineer or on a similar role.
• Extensive experience with SQL, Amazon Redshift & ideally MySQL.
• Extensive experience with visualisation tools, ideally with Amazon QuickSight.
• Experience with AWS Glue and the ability to write Python scripts, e.g. for ETL.
• Experience developing ETL & ELT processes from multiple data sources & types.
• Experience working in a collaborative Agile environment.
• Mentoring skills for the less experienced members of the team.
• Practical experience with JIRA & Confluence.
• Self-motivated, proactive, independent thinker, with a “can do” mentality.
• Team player.
• Inquisitive with a desire to learn and use new technologies.
• Knowledge of SAP Business Objects would be helpful but not necessary – currently in use but in the process of migrating to Redshift & QuickSight.