Data Engineer

Company Overview

TroyTech International Consulting Pte Ltd is a Singapore-based consulting firm specializing in SOA, EAI, JEE technical support, web & mobile solutions, and business integration with IBM and open source software. It serves Financial, Transportation, and Government sectors across APAC.

Job Summary

Manage and optimize IBM Planning Analytics (PA) systems by performing impact analysis, resolving defects, managing data refreshes, and supporting deployment and upgrade activities to ensure accurate budgeting and forecasting processes.

Responsibilities

• Analyze and resolve production defects to maintain IBM PA system stability and performance
• Manage nightly data refresh operations and monitor for anomalies or issues
• Troubleshoot and fix data load failures, errors, and warnings to ensure data integrity
• Conduct variance analysis and data validation during monthly and quarterly financial closes
• Implement and maintain data archival, restore, and backup procedures for IBM PA assets
• Upgrade IBM PA applications and apply patches on-premise and on GCC Cloud environments
• Execute cutover and deployment activities following established procedures to minimize downtime
• Collaborate with infrastructure teams to address environment, security, and system concerns
• Create and manage cubes, dimensions, hierarchies, and subsets within PAW to support reporting needs
• Define relationships, attributes, and aliases to enhance data modeling accuracy
• Write, test, and debug rules and feeders in PAW to optimize data processing and calculations
• Build and execute TurboIntegrator (TI) processes for data integration and automation
• Design user-friendly PAW books and sheets using widgets, tabs, selectors, and quick reports to improve usability
• Apply object-level and cell-level security rules to protect sensitive data and control access
• Perform backup and recovery of PAW books and related assets to ensure data availability
• Utilize Python scripting and advanced TI and rule debugging techniques to enhance system functionality
• Optimize feeders and debug feeder issues to improve system efficiency

Required competencies and certifications

• Minimum 4 years of relevant experience in IBM Planning Analytics (PA) system administration and development

Preferred competencies and qualifications

• Any IBM BI or Cognod or PA Certifications will be an advadvantage

Other Information

• Working hours: 8:30am to 6.30pm on weekdays,
• for deployments/upgrades, may require to work on weekend with OIL leaves compensation.