Data Engineer

Join us at AFFIN, where the open minds meet and be inspired by a shared commitment to great work. Here, you don't just stay at the forefront of the industry – you can make a difference too.

JOB PURPOSE

Develop thorough understanding of data acquisition, data transformation, data monitoring, data retention, data mobilization, automation, and access and change management. Manage and monitor daily and monthly data in Data & Analytics

CoE data marts/EDW to ensure data availability, quality and consistency. Consolidate, plan and execute data acquisition, data transformation and data mobilization activities based on requirement from Data & Analytics CoE or business units. Coordinate with the project manager to provide exceptional service to our clients; communicate with clients on a regular basis for requirements status updates and gathering issue resolution.

ACCOUNTABILITIES

Automation of repetitive reporting from the reports designed by Data & Analytics CoE.

Automation of new data acquisition or data mobilization processes with regards to Data & Analytics CoE data mart enrichment, analytics initiatives or database campaign improvement.

Automation of processes within pillars of Data & Analytics CoE.

Management and continuous development of the Data & Analytics architecture and applications on behalf of Data & Analytics CoE, which covers and not limited to the areas of:

• Day-to-day maintenance which involving monitoring and assessment of the server performance and capacity.

• Any upgrade/patching activities for the Data & Analytics applications for product version/patch and software upgrade.

• Any enhancement or integration initiative of Data & Analytics and infrastructure to other Affin systems.

• Managing and anticipating the operational risk available/exposed to the current Data & Analytics application and architecture.

• Coordination with IT & Vendor team with regards to continuous improvement and performance stability.

Project Management

• Assist in creating project plans for small projects in conjunction with the business.

• Assist with managing, supporting, and following up with the project team on these projects.

• Monitor and manage project progress.

Key Liaison

• Collaborate with IT team on new data sources or data fields and incorporate them into CoE data marts/EDW

• Ensure CoE data marts/EDW and reporting batch jobs aligned with the bank's database batch activities.

• Collaborate with Data Governance with regards to data quality, data governance and enterprise data house development.

• Department Risk and Compliance Officer.

• Department System Administrator.

JOB REQUIREMENTS

• Has a BSc/Masters in Computer Science or equivalent.

• Has 4 to 7 years of experience in data management or data warehousing.

• Good knowledge of MS SQL and understanding of ETL Development and Talend, Airflow and GCP applications development.

• Has good understanding of data warehousing and software development design concepts.

• Familiarity on Talend, PostgreSQL, Google Cloud Platform and Qlik architecture and environment will be added advantage.

• Industry and/or product specific certification required.

• Expected to keep up with new technologies and apply effectively on the existing environment.

• Must be a team player and team builder.

• Highly self-motivated and self-directing.

• Must have skills in analytical thinking, numerically strong, planning and organizing, monitoring performance, empowerment & goal setting.

• Ability to manage projects while working under pressure, have high spirit, improving as per coaching, attitude & behavior in office.

• Change management.

• Excellent verbal and written communications skills, and the ability to obtain buy-in for ideas.

• Career ambition and the desire to make a difference.

• Effective business writing skills.

• Strong computer skills and standard office applications.

• Strong problem-solving skills.

• Keep up with new technologies.