Data Engineer
Role details
Job location
Tech stack
Job description
As an Analytics Engineer, you will work across projects and functions, helping to solve advanced questions and steer the business to data-based decision making through technical insights.
This role will be fast-paced and needs a self-starter who can manage their own workload and shift priorities day to day. With the pace of change in AI, we're not just managing data-we're unlocking what's next. This role isn't just about stability; it's about possibility., ?Responsible for efficiently and securely ingesting data into Amazon Redshift, ensuring the data is correctly formatted, transformed, and loaded into the data warehouse. This includes developing and maintaining data pipelines and ETL processes to facilitate the timely and accurate transfer of data into Redshift.
?Create, design, and develop data models and views in AWS Redshift that can be analysed effectively in Redshift and Power BI.
?Set - up, configure, administer, and troubleshoot in AWS Redshift.
?Conduct UAT of new data pipelines, validating and analysing results to ensure data integrity and usability.
?Monitor daily loads and support the Dev Ops/Data Analysts on any issues, failures and resolving with system owners.
?Support business users in their understanding of data available, produce ERDs, data dictionaries, document known issues and contribute to resolving them.
?Explore and integrate AI tools and automation across the business.
?Experiment, prototype, and help define how AI and intelligent automation can give us a serious edge and add value across all aspects of our business.
?Develop a set of principles for the business on data governance, warehouse optimisation and GDPR
?Stay on top of trends and best practices in data software, be willing to learn and implement the latest technology in the industry.
Requirements
?In-depth knowledge of SQL.
?Proficiency in data warehousing (AWS Redshift or similar) and data modelling, involving the design and enhancement of data structures to ensure optimal performance and scalability You will be tenacious and committed to producing results with the ability to persevere with a challenge to see through the end.