Snaphunt Pte Ltd

Data Engineer

Snaphunt Pte Ltd| Date Posted: 14-Jul-2019
Save Job
Job Nature:
Permanent
Position Level:
Experienced, Manager
Qualification:
'A' Levels, Diploma, Bachelor's / Honours

Job Description

  • Excellent career development opportunities
  • Work within a leading employer in the Media & Entertainment industry

 

The Employer

Our client is Asia’s leading media organisation, engaging minds and enriching lives across multiple languages and platforms. The company's core business is publishing of newspapers, magazines and books in both print and digital editions. It also owns other digital products, online classifieds, radio stations and outdoor media.

 

The Job

In this role, you are responsible for the maintenance, improvement, cleaning, and manipulation of data in the business’s operational and analytics databases. You work with the business’s software engineers, data analytics teams, data scientists, and data warehouse engineers in order to understand and aid in the implementation of database requirements, analyze performance, and troubleshoot any existent issues.

 

You will be the expert in SQL development further providing support to the Data and Analytics in database design, data flow and analysis activities. You will also play a key role in the development and deployment of innovative big data platforms for advanced analytics and data processing.

 

You define and build the data pipelines that will enable faster, better, data-informed decision-making within the business.

 

Management

The Data Engineer manages his position and junior data engineering support personnel position by creating databases optimized for performance, implementing schema changes, and maintaining data architecture standards across all of the business’s databases.

 

In this position, you lead innovation through exploration, benchmarking, making recommendations, and implementing big data technologies for platforms. You are also tasked with the development and implementation of scripts for database maintenance, monitoring, performance tuning, and so forth.

 

You will be additionally tasked with designing and developing scalable ETL packages from the business source systems and the development of ETL routines in order to populate databases from sources and also to create aggregates. It is also the role of the Data Engineer to oversee large-scale data Hadoop platforms and to support the fast-growing data within the business.

 

In this capacity, you are responsible for enabling and running data migrations across different databases and different servers, for example, data migration from SQL servers to MySQL. He defines and implements data stores based on system requirements and consumer requirements.

 

You are also responsible for performing thorough testing and validation in order to support the accuracy of data transformations and data verification used in machine learning models. The Data Engineer strives to ensure proper data governance and quality across the Data and Analytics department and the business as a whole.

 

Analytics

The Data Engineer plays an analytical role where he performs ad-hoc analyses of data stored in the business’s MySQL/MS SQL databases and writes SQL scripts, stored procedures, functions, and views. In this position, you troubleshoot data issues within the business and across the business and presents solutions to these issues. You proactively analyzes and evaluates the business’s databases in order to identify and recommend improvements and optimization.

 

You will also prepare activity and progress reports regarding the business database status and health, which you present to senior data engineers. In this position, you will additionally analyze complex data elements and systems, data flow, dependencies, and relationships in order to contribute to conceptual physical and logical data models.

 

Support/Collaborative Role

You develop and implement scripts for database maintenance, monitoring, and performance tuning to be applied across the business. You also play a supporting role to various departments across the business where you support and provide useful insights on the implementation of workflows, as well as the data warehousing department in the implementation of the data warehouse for the new big data platforms. You work collaboratively with the entire Data and Analytics team, providing support to the entire department for its data-centric needs.

 

The Profile

  • You possess a bachelor’s degree in Computer Science, Applied Mathematics, Engineering, or any other technology related field. 
  • You have at least 3 years of working experience as a database engineering support personnel or a database engineering administrator within a fast-paced a complex business setting.
  • Experience working with MySQL databases and Redshift, strong knowledge of AWS, Redshift, Data Lakes, Snowflake, ETL is required.
  • You keep up with industry trends and best practices, advising senior management on new and improved data engineering strategies that will drive departmental performance leading to improvement in overall improvement in data governance across the business, promoting informed decision-making, and ultimately improving overall business performance.
Company Overview
Snaphunt Pte Ltd