At a Glance
- Tasks: Design and build data pipelines, manage databases, and collaborate with teams.
- Company: ZILO is revolutionising global transfer agency with innovative technology solutions.
- Benefits: Enjoy 38 days leave, private healthcare, flexible working, and global mobility options.
- Why this job: Make a real impact in financial services while working in a collaborative and innovative environment.
- Qualifications: Bachelor's degree and 3 years experience in data engineering, strong SQL and AWS skills required.
- Other info: Join a team dedicated to continuous improvement and market leadership.
The predicted salary is between 48000 - 84000 £ per year.
ZILO is focused on transforming global transfer agency by providing a single global solution that replaces legacy technology and systems. Our mission is to create sustainable value for firms and the customers they serve, all while putting people first. With a design-driven approach and a commitment to innovation, our team of experts has unified the full breadth of global transfer agency into a single, streamlined solution. At ZILO, we value collaboration, innovation, and continuous improvement. Our team of experienced professionals is dedicated to achieving our goal of being the market-leading solution in global transfer agency. If you are a motivated individual with a passion for technology and a desire to make a real impact in the financial services industry, we would love to hear from you.
About this role
We are seeking a skilled Data Engineer – Data Lakehouse to join our team. The ideal candidate should be experienced in designing and building data pipelines, performing ETL operations, and managing databases. The candidate will also need to have knowledge and experience in using AWS services for data processing, storage, and analysis.
Responsibilities
- Design, build and maintain efficient and scalable data pipelines to support data processing and analysis.
- Develop and implement ETL processes to ensure data quality and integrity.
- Manage and optimize databases, including designing schema and indexing strategies, data partitioning and data archival.
- Work closely with data scientists and business analysts to understand data requirements and translate them into technical solutions.
- Collaborate with DevOps and IT teams to deploy, monitor and troubleshoot data systems.
- Develop and maintain documentation on data infrastructure and processes.
- Stay current with the latest data engineering technologies, tools and practices.
Qualifications
- Bachelor's degree in computer science, engineering or related field.
- Minimum of 3 years of experience in data engineering roles.
- Strong proficiency in SQL, ETL processes and database management systems (e.g., MySQL, PostgreSQL, MongoDB).
- Hands-on experience with AWS services for data processing, storage and analysis (e.g., S3, Redshift, EMR, Glue).
- Familiarity with programming languages such as Python or Java.
- Understanding of data warehousing concepts and data modeling techniques.
- Experience working with big data technologies (e.g., Hadoop, Spark) is an advantage.
- Excellent problem-solving and analytical skills.
- Strong communication and collaboration skills.
Benefits
- Enhanced leave - 38 days inclusive of 8 UK Public Holidays
- Private Health Care including family cover
- Life Assurance – 5x salary
- Flexible working - work from home and/or in our London Office
- Employee Assistance Program
- Company Pension (Salary Sacrifice options available)
- Access to training and development
- Buy and Sell holiday scheme
- The opportunity for “work from anywhere/global mobility”
Data Lakehouse Developer employer: ZILO
Contact Detail:
ZILO Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Lakehouse Developer
✨Tip Number 1
Familiarise yourself with the specific AWS services mentioned in the job description, such as S3, Redshift, and Glue. Having hands-on experience or even personal projects showcasing these tools can set you apart during discussions.
✨Tip Number 2
Network with current or former employees of ZILO on platforms like LinkedIn. Engaging in conversations about their experiences can provide valuable insights into the company culture and expectations, which you can leverage in your interviews.
✨Tip Number 3
Prepare to discuss your previous projects involving data pipelines and ETL processes in detail. Be ready to explain the challenges you faced and how you overcame them, as this demonstrates your problem-solving skills and technical expertise.
✨Tip Number 4
Stay updated on the latest trends in data engineering and big data technologies. Mentioning recent advancements or tools you've explored can show your commitment to continuous improvement, aligning with ZILO's values.
We think you need these skills to ace Data Lakehouse Developer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in data engineering, particularly focusing on your skills in designing data pipelines, ETL processes, and database management. Use specific examples that demonstrate your proficiency with AWS services.
Craft a Compelling Cover Letter: Write a cover letter that reflects your passion for technology and the financial services industry. Mention how your background aligns with ZILO's mission of innovation and collaboration, and express your enthusiasm for contributing to their team.
Showcase Technical Skills: In your application, clearly outline your technical skills, especially your experience with SQL, AWS services, and any programming languages like Python or Java. Providing concrete examples of past projects can strengthen your application.
Highlight Soft Skills: ZILO values collaboration and communication. Make sure to include examples of how you've worked effectively in teams, solved problems, and communicated complex ideas to non-technical stakeholders in your application.
How to prepare for a job interview at ZILO
✨Showcase Your Technical Skills
Be prepared to discuss your experience with SQL, ETL processes, and database management systems. Highlight specific projects where you designed and built data pipelines or managed databases, as this will demonstrate your hands-on expertise.
✨Familiarise Yourself with AWS Services
Since the role requires knowledge of AWS services like S3, Redshift, and Glue, make sure you can talk about your experience using these tools. Consider preparing examples of how you've used AWS for data processing and analysis in previous roles.
✨Understand Data Engineering Concepts
Brush up on data warehousing concepts and data modelling techniques. Be ready to explain how you approach designing schemas and indexing strategies, as well as your understanding of data quality and integrity in ETL processes.
✨Emphasise Collaboration and Communication
ZILO values collaboration, so be prepared to discuss how you've worked with data scientists, business analysts, and IT teams in the past. Share examples that highlight your ability to translate data requirements into technical solutions and your problem-solving skills.