Data Engineer
Summary
The Data Engineer will manage daily operations, data refreshes, and system maintenance for IBM Planning Analytics (PA) projects. The role involves performing variance analysis, resolving production defects, and ensuring system security and performance.
Responsibilities-
- Good understanding of the budgeting & forecasting process.
- Quick learner and able to understand implemented system functionality.
- Perform impact analysis and resolve production defects.
- Manage daily operation chores/nightly data refresh in the IBM PA project and share observations if any.
- Fix data load failure, errors and warnings.
- Variance analysis/ data validation on monthly or quarterly close.
- Ensure data archival, restore and backup procedure.
- Upgrade and apply patches for IBM PA application (on premise IBM PA on GCC Cloud).
- Experience in cutover activities and well verse in executing the steps.
- Experience in deployment activities post fixes and enhancement.
- Work closely with infrastructure team for any environment issues, security, and concerns.
TechnicalSkills -
Fundamentalconcepts:
- Cube, Dimension, element and hierarchy.
- Rules and feeders
- TI Process
- Data Type (numeric, string, consolidation)
- PAW, PAX, Pafe, TM1 web
PAW:
- Creating and managing cubes, dimensions, hierarchies, and subsets directly from PAW
- Defining relationships, attributes, and aliases
- Writing and testing rules within PAW’s rule editor
- Building and executing TI (TurboIntegrator) processes
- Managing feeders efficiently
UI/UX:
- Designing intuitive PAW books and sheets
- Using widgets, tabs, selectors, and quick reports
- Best practices for layout, formatting, and usability
Security:
- Object security (cube, dimension, element, process, chore)
- Cell-level security rules and application security
Admin:
- Backup and recovery of PAW books and assets
- Deployment and upgrade
Others:
- Python Scripting
- Advance TI & Rule debugging
- Conditional Rule
- Feeder optimization
- Debugging feeders
Minimum 4years of relevant experience.