About this role
Data Engineer:
The Everything Managed Group is a dynamic, innovative and technology driven business committed to leveraging data-driven insights to optimise operations and drive strategic decision-making. We are now seeking a talented Data Engineer to play a significant part in the design, delivery and ongoing evolution of the EMG data platform.
Summary:
As a Data Engineer, you will play a critical role in transforming data into actionable insights and supporting our data infrastructure. You will collaborate with cross-functional teams to gather requirements, design data pipelines and transformations, and develop analytical solutions to address business challenges.
Responsibilities:
• Collaborate with cross-functional teams, including system administrators, developers / engineers, external partners, and business stakeholders, to understand requirements and deliver solutions.
• Design, build and maintain scalable data pipelines to ingest, process and transform structured and unstructured data from diverse sources.
• Optimise solutions for performance, reliability, and scalability, ensuring efficient data processing and storage.
• Perform exploratory profiling and validation on new data sources to assess quality, structure and fitness for purpose prior to pipeline development.
• Implement and manage orchestration workflows to automate data pipeline scheduling monitoring and error handling.
• Design and implement data quality and consistency schemes to ensure the integrity and consistency of data, management information and reporting.
• Design and implement well-structured optimised data models that enable accurate, performant reporting and analysis by downstream stakeholders both within the team and across the wider organisation.
• Ensure the data platform is fully documented, maintaining up-to-date information requirements, data models, data dictionaries, and ETL mappings.
• Provide ad-hoc deep dive analysis, reporting requests and management information to business users.
• Communicate technical concepts and findings to non-technical audiences in a clear and understandable manner.
• Provide training and support to others, sharing best practices and fostering culture of continuous learning.
• Plan and prioritise work to ensure on time delivery of tasks.
Skills and Experience:
• Degree in Mathematics, Statistics, Computer Science, Engineering or a related field or equivalent practical experience in a data engineering role. .
• Ideally experienced as a Data Engineer with hands-on experience designing and delivering data pipelines using industry-standard tools and cloud technologies.
• Knowledge of data engineering concepts, data pipeline development, ETL processes, data lake and data warehousing technologies.
• Proficiency in working with at least one major cloud data platform or lakehouse technology.
• Data modelling skills (including 3NF and dimensional modelling).
• Good knowledge of relational database technologies and concepts.
• Excellent analytical and problem-solving skills with a keen attention to detail.
• Good verbal and written communication skills with the ability to collaborate across teams and present findings to stakeholders.
• Experience with data transformation and/or distributed processing concepts, technologies and best practices is a benefit.
• Proficiency in Python for data engineering tasks (e.g. pipeline scripting, data transformation, automation)
• Experience using version control (Git) and familiarity with CI/CD practices for data engineering workflows.
• Ability to work both independently and collaboratively in a dynamic environment.
• Strong customer focus and stakeholder skills.
• Ability to prioritise tasks and work effectively in a fast-paced environment.