Job description:
As a DRM (Dimension Relationship Management) Developer on the Corporate Reporting team, you will own the design, development, and operational support of dimension management pipelines that power Amazon''s enterprise planning and financial reporting systems. You will build and maintain the end-to-end orchestration of dimension data flowing from DRM through the DataService layer into TM1 planning applications , Redshift, and EDX — ensuring the accuracy and timeliness of financial hierarchies used in monthly book close and quarterly earnings reporting.
________________________________________
Key Responsibilities
• Develop and maintain DRM dimension management pipelines including DJS job orchestration, S3 file ingestion, and TM1 Dim Management instance updates.
• Build and manage TM1 processes and workstreams for creating, modifying, and validating financial dimensions .
• Automate dimension build workflows using Airflow, replacing manual execution steps with reliable, scheduled pipelines.
• Monitor and troubleshoot dimension file generation from DRM, S3 bucket delivery, Linux mount synchronization, and TM1 process execution.
• Manage dimension hierarchy logic including alternate hierarchies, orphan handling, attribute mapping (Alias, String, Numeric), and hierarchy skip configurations.
• Support production deployments across Prod, Test, and Dev environments, ensuring proper parameter configuration and backup procedures before dimension loads.
• Collaborate with Finance stakeholders and the DRM team to translate dimension change requests into technical implementations.
• Maintain operational runbooks and respond to dimension build failures during critical close cycles.
________________________________________
Basic Qualifications
• 5+ years of software development or data engineering experience.
• Proficiency in TM1/Planning Analytics (TI processes, cube design, dimension management).
• Experience with AWS services: S3, Redshift, Airflow, and DJS (or equivalent orchestration tools).
• Strong scripting skills (Python, Shell) for automation of ETL/ELT pipelines.
• Familiarity with dimension modeling concepts, hierarchies, and attribute management.
• Experience working with CSV-based data ingestion and file-based orchestration patterns.
Preferred Qualifications
• Experience with DRM (Dimension Relationship Management) or Oracle DRM/EDMCS.
• Experience with Linux server administration and S3 directory mount configurations.
• Understanding of corporate finance processes — monthly close, quarterly reporting, and planning cycles.
• Ability to operate independently in a fast-paced environment with tight financial close deadlines.
Never miss an opportunity! Create an alert based on the job you applied for.
