Data Engineer

The Data Engineer will be responsible for expanding and optimizing the data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The Data Engineer is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. The Data Engineer will support software developers, database architects, data analysts and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.

They must be self‑directed and comfortable supporting the data needs of multiple teams, systems and products. The Data Engineer will be required to optimise or even re‑design the data architecture to support the next generation of products and data initiatives. The Data Engineer is also responsible for the maintenance, improvement, cleaning, and manipulation of data in the business’s operational and analytics databases in order to understand and aid in the implementation of database requirements, analyse performance, and troubleshoot any existent issues.

The Data Engineer has to be an expert in SQL development further providing support to the Data and Analytics in database design, data flow and analysis activities. The position of the Data Engineer also plays a key role in the development and deployment of innovative big data platforms for advanced analytics and data processing.

• Create and maintain optimal data pipeline architecture, assemble large, complex data sets that meet functional and non‑functional business requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re‑designing infrastructure for greater scalability.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and 'big data' technologies.
• Implement analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.
• Work with stakeholders including the Executive, Product, Data and Design teams to assist with data‑related technical issues and support their data infrastructure needs.
• Keep our data separated and secure across national boundaries through multiple data centres.
• Implement data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
• Work with data and analytics experts to strive for greater functionality in our data systems.
• Supports junior data engineering personnel by creating databases optimized for performance, implementing schema changes, and maintaining data architecture standards across all of the business’s databases.
• The Data Engineer leads innovation through exploration, benchmarking, making recommendations, and implementing big data technologies for platforms.
• Develop and implement scripts for database maintenance, monitoring, performance tuning, and so forth.
• Designing and developing scalable ETL packages (Abinitio) from the business source systems and the development of ETL routines in order to populate databases from sources and also to create aggregates.
• Oversee large-scale data Hadoop platforms and support the fast‑growing data within the business.
• The Data Engineer is responsible for enabling and running data migrations across different databases and different servers, for example, data migration from SQL servers to Oracle.
• Define and implement data stores based on system requirements and other requirements.
• Perform thorough testing and validation in order to support the accuracy…