Orion Systems Integrators, Inc. Career Portal
Jobs > - Data Architect - Cognos Developer

- Data Architect - Cognos Developer (closed)

Location New Brunswick, NJ
Salary/Pay Rate$50-$60/Hr. W2 DOE
Employment TypeContract
Job Description

- Data Architect - II (Infrastructure Projects)

Support activities 
? Troubleshoot requests ( Ex: Research / Analyze data / report issues ) 
? Database design, build & maintenance (Ex: ETL) 
? Responding to source data systems changes (Ex: JCT / CompNav / TalNav, etc.,) 
? Report maintenance (Ex: Cognos FM / Reports) 
? Create scripts for date extractions (Ex: VP initial load data to WorkDay) 
? Adhoc requests for report data (Ex: Duplicate wwids for prior employees) 
? Migration of existing environments (Ex: Cognos 10 to Oracle 11) 
? Gather user business requirements. 
? Prepare functional specifications. (FRS) 
? Prepare detailed design documents. (TRS) 
? Create complex Oracle dataviews to enable effective reporting. 
? Design & code reports via Cognos BI tools. 
? Report maintenance (Cognos 10). 
? Develop & run test scripts for report development & Oracle upgrades. 
? Training / user education / documentation (Ex: Talent Dashboard data load process) 
? Legacy system infrastructure support 
? Develop processes for integration of data from multiple HR systems. 
? PL/SQL procedure & UNIX scripts - design & coding. 


Operational activities 
? HR Analytics Job execution and monitorig (Ex: Talnav/CompNav Maestro jobs, SAP interface) ? daily schedule 
? Authoritative Source Load ? daily ETL 
? SAP data load to Reporting database ? weekly ETL 
? Load Transactional system data (JCT/GJC/Bravo/SAP) to Reporting database ? monthly ETL 
? Reporting Authoritative Source History load ? monthly ETL 

Project work 
? Talent Dossier - requirements/design/build/ETL 
? Talent Dashboard - requirements/design/build/ETL 
? GDW (Global Data Warehouse) 
o Legacy data load 
o FRS ?Functional requirements specifications 
o TDS ?Technical design specifications 

Adhoc 
? Assist in new user setup 
? General system support 

General Technical skills needed. 
? SQL 
? PL/SQL 
? Unix scripting 
? Cognos 10 
? MS Office (excel, word, visio, powerpoint)

 
Stay in touch with Orion Systems Integrators,Inc

Silent Follow

Get job updates anonymously