Previous Job
Previous
Technical Architect Expert High
Ref No.: 17-00794
Location: Albany, New York
Start Date: 06/27/2017
Agency: Information Technology Services (ITS)
 Is this a Project or Program specific request (e.g., Connections, SFS)?
Yes
If yes, please list the Project or Program Name:
AnalyzeNY
Please provide a short description of the project:
Statewide Data Warehouse
Please provide a full listing of the day to day tasks to be performed by the Consultant (be descriptive and specific):
Support and development for the AnalzyeNY Statewide Data Warehouse.  Analyze, design, build and test both ETL components and OBIEE reports for a BIApps Peoplesoft Financials data warehouse.
Which Service Group is required?
Service Group 1. STANDARD TITLES
What is the number of staff being requested?
(maximum of 5)
2
Which Job Title Category is required?
Technical Architect
Which Skill Level is required?
Expert
Which Skill Demand is required?
High
How many Candidate Response Forms are being requested per Contractor per position?     (1 or 2)
2
When is the Target Start Date?
(30 Business Days minimum from date of request)
7/24/2017
How long is the engagement? (in months)
24
When is the estimated completion date?
7/23/2019
Is this a Full or Part-Time Position (Full time is considered 40 Hours Per Week)?
Full Time
If  Part-Time, enter approximate number of hours per week:
What are the daily work hours? (note if negotiable or list preferred start and end time):
M-F 8:00 to 5:00
Where is the Home Base Region?
Region 1 - Capital Area
Where is the work office located?  Enter Building Name (if known) Full Street Address, City, and ZIP
Agency Bldg #1, ESP , Albany,  NY , 12239
What type of software is typically used by the Agency?  (e.g., Agency is an "IBM shop.”)
Oracle DBMS and BIApps
What type of hardware is typically used by the Agency? (e.g., Agency is a "Client shop.”)
Oracle on AIX
Position Mandatory Qualifications
 Technical Architect
- Technical expert centered around a technology, technologies or a portfolio of applications- Designing and implementing Information Technology solutions
Expert
84+ Months: Candidate is able to provide leadership of large teams and/or extensive industry experience and is considered at the top of his/her field​
 Requested Qualifications

84 months of experience in Business Intelligence apps building ETL scripts and programming reports
84 months of experience in PL/SQL maintaining Oracle databases
60 months experience working in a State or Federal government environment
48 months of experience in Cognos DW modeling and developing reports
48 Months of experience in OBIEE report development
24 months of experience in Oracle BIApps for Peoplesoft Financials modeling and developing reports
Additional Information Requests:
Are there additional security requirements for the Authorized User?
Yes: ITS-NDA, Background Check and Fingerprinting   
Will additional training possibly be required during the Engagement?
Yes 
If Yes, provide description of anticipated training.
Annual NYS Mandatory training
What type, or manner, of Knowledge Transfer is requested during the engagement?
Documentation / In-person briefings
Is travel anticipated during the Engagement?
No
If Yes, please list anticipated frequency and locations for travel: