ADT's Planning, PCM, EDM, Dodeca, Essbase, and financial systems data hub requires ongoing solutions development, data strategies, end-to-end data integrations, and system design improvements.
Requirements
- Strong Understanding of Oracle EPM tools.
- Experience with writing SQL code (store procedures in MS SQL, Google’s Big Query and Oracle’s PL SQL).
- Experience with using Microsoft SSIS (ETL packages).
- Experience with data validation between target and source systems.
Responsibilities
- Creates, update and maintains the library (currently in Microsoft SSIS ETL task) of automation routines for data sources to be used by financial systems tools (EPBCS, PCM, Dodeca, Essbase, EDM).
- Creates data validations for data sets to validate that changes done to the library does not affect the accuracy of existing data.
- Works with the Admin side of the financial systems group to build new data sets that meet the end user requirement.
- Works with the Admin side of the financial systems group the transition of new data sets for the daily execution of the same.
- Provides support and guidance to the admin side of the financial systems group whenever there is a data discrepancy or data challenge.
- Creates and maintains documentation of existing processes.
- Ensures systems are running efficiently and leads any fixes required to keep systems running.
Other
- A hybrid schedule where employees work on-site four days per week and remotely one day.
- 5+ plus years of prior related experience is required.
- Experience understanding, communicating, and prioritizing projects.
- Excellent interpersonal, written, and verbal communication skills.
- Resourceful and able to work independently.
