Key Responsibilities:
• Collaborate with cross-functional teams to identify application and system dependencies on the current CDW platform.
• Analyze and interpret Business Requirement Specifications (BRS) and ETL code to support modernization goals.
• Work with stakeholders to define data requirements for Finance and Accounting systems.
• Develop detailed mapping documents capturing data flows, transformations, and system interactions.
• Create and validate complex SQL scripts to assist with data analysis and migration.
• Assist in mapping source systems to Nexus and defining derivation logic as part of the modernization effort.
• Support the transformation of legacy data into the new EBM format.
• Ensure clear documentation and traceability of all data lineage and mapping efforts.
⸻
Required Qualifications:
• Minimum of 6+ years of experience in data analysis, data warehousing, or related fields.
• Strong understanding of ETL processes and ability to read and interpret ETL code.
• Hands-on experience with tools such as DataStage, Informatica, SAS, and Python.
• Proficiency in SQL for data analysis, validation, and script development.
• Solid understanding of enterprise-scale systems and data environments.
• Excellent analytical skills and attention to detail.
• Strong communication and collaboration skills.
⸻
Preferred Skills:
• Familiarity with Corporate Data Warehouses (especially CDW).
• Prior experience in finance and accounting data flows.
• Exposure to modernization or data migration initiatives.
• Knowledge of Nexus platform and EBM data formats is a plus
Any Gradute