IT STAFFING SERVICES SOLICITATION UNDER DEPARTMENT OF INFORMATION RESOURCES IT STAFF AUGMENTATION CONTRACT (ITSAC) ================================================================================== Working Title: Data Warehouse Integration Analyst Solicitation Number: 70112051 ITSAC Level Description: Data Warehouse ITSAC Technology Type: Emerging Architect 2 I.
DESCRIPTION OF SERVICES The Department of Information Resources (DIR) requires the services of one Data Warehouse Integration Analyst, hereafter referred to as Worker(s), who meets the general qualifications of ITSAC Data Warehouse Architect 2 Category, Emerging Technology Type and the specifications outlined in this document for the Texas Education Agency (TEA). All work products resulting from the project shall be considered “works made for hire� and are the property of the TEA. TEA may include pre-selection requirements that potential Vendors (and their Workers) submit to and satisfy criminal background checks as authorized by the Texas law. TEA will pay no fees for interviews or discussions, which occur during the process of selecting a Worker(s). The Data Warehouse Integration Analyst will have primary responsibility for the technical interface between the State-sponsored Student Information System (SSIS) Vendor and the Texas Education Agency. In this role the Analyst will understand and communicate the business and technical objectives of the Texas Education Data Warehouse Solution (EDW). As the technical interface, the Analyst will be required to develop and maintain an in-depth knowledge of the Texas Education Data Standard, based on the Ed-Fi national education data standard. The Analyst will assist Vendors with interface programming required to produce the required data for the EDW. The analyst must identify opportunities for improvements that will enable TEA to have a smooth, accurate and secure migration of data into EDW by meeting TEA and other industry data standards. Vendor integration efforts must comply with state and federal mandates like HIPAA and FERPA and support the business needs of the Education Data Warehouse implementation. The position will require the candidate to work closely with TEA internal users and management team, as well as Regional Education Service Center (ESC) staff, LEA staff, and student information system Vendor staff. The successful candidate must have the following skills: Skilled in data analysis, data integration, and auditing, and troubleshooting related issues. Listening skills, to understand what people say and to detect what they might be hesitant to say Analytical skills, to critically evaluate the information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, and generalize from low-level information Negotiation and facilitation skills, to lead problem-solving and consensus-building efforts among TEA, LEAs, ESCs, and Vendor stakeholders Interpersonal skills, to help negotiate priorities and to resolve conflicts among project stakeholders (such as customers, product management, and engineering) Writing skills, to communicate information effectively to managers and technical and business stakeholder staff
Page 1 of 7
IT STAFFING SERVICES SOLICITATION UNDER DEPARTMENT OF INFORMATION RESOURCES IT STAFF AUGMENTATION CONTRACT (ITSAC) ================================================================================== The duties of the position will require the analyst to: • • • • • • • • • • • • • • • • • • • • •
Serve as the lead technical resource, performing strategic oversight for the Vendors’ development of web services or programmatic interfaces for data transfers using XML while remaining FERPA and HIPAA compliant for privacy Provide expert knowledge and responsibility for designing, developing, testing and maintaining interfaces of the Vendors’ interface engines and all related inter-system data transmissions Assist Vendors with design, development and configuration of all required components of the interface engine for building efficient interfaces. Coordinate and assist to update, upgrade and maintain the interface engine for optimal performance and functionality. Oversee Vendor preparation of technical specifications and release plans as needed. Assist Vendor with the element mapping from the Vendor application to the XML format. Oversee Vendors thorough unit and integration tests. Oversee Vendors system integration and quality assurance testing. Oversee Vendors as they author and execute unit testing strategies and results, related to all development efforts. Work with the Vendor technical team lead for direction/design and collaboratively with Vendor developers, Architects, DBAs, Integrations Administrators and others to achieve cohesive, compliant software deliveries. Effectively evaluate technical issues and articulate their business and organizational impact to peers and stakeholders. Collaborate with Vendor and coordinate problem analysis and root cause determination and resolution. Report status and problems to TEA Project Manager and participate in negotiations to resolve issues. May plan, assign, and/or supervise the work of others. Perform related tasks as assigned by the direct supervisor. Work under limited supervision with considerable latitude for the use of initiative and independent judgment Follow and comply with TEA processes, procedures, and guidelines for all work and participate in technical reviews of all work. Communicate with the contract manager, team members, and customers about change requests and to understand their needs. Document all technical work as requested. Keep agency supervisor and management informed on issues and the status of work planned and complemented by submitting weekly status reports. Provide technical leadership and expertise on data integration in the Vendor data center. Interface as appropriate in carrying out systems design and development responsibilities with data analysts, database administrators, network operations, security officer, and other information technology peers and management.
Page 2 of 7
IT STAFFING SERVICES SOLICITATION UNDER DEPARTMENT OF INFORMATION RESOURCES IT STAFF AUGMENTATION CONTRACT (ITSAC) ================================================================================== II. WORKER SKILLS AND QUALIFICATIONS Minimum Requirements: Years
Skills/Experience
7
Experience with industry data standards and database architecture
7
Experience with XML
7
Experience with design and integration principles for complex, heterogeneous databases Experience with diagnosis and resolution of complex data infrastructure issues including development of methods to identify and resolve data incompatibilities among systems Experience in integration of complex multi-Vendor sites, systems and applications
7
5 5 5
Must have a strong analytical, problem-identification and process analysis skills with the ability to envision a solution from requirements Three (3) plus years Oracle 10g (greater) as well as another enterprise database
5
Professional who works well independently or as part of a team
5
Three (3) plus years SQL based language
5 5
Work experience and knowledge in managing the integration and maintenance of complex multi-Vendor sites and applications Must have excellent communication skills both orally and in writing
3
Work experience with Software as a Service (SaaS)
3
Experience with SQL tuning and optimizing
3
Work experience and understanding of software development lifecycle methodologies, thorough knowledge of the software specification process and software development processes, and software architecture. Exposure to data warehouse architectures
2
Preferences: Years 3 3
III.
Skills/Experience Experience with management tools like Optimal Trace and UML modeling tools like Enterprise Architect Experience with defining business workflow.
TERM OF SERVICE Services expect to start as soon as possible and are expected to be completed by August 31, 2012. Total estimated Worker hours shall not exceed 1760 hours per worker. This service may be amended, renewed, and/or extended providing both parties agree to do so in writing.
Page 3 of 7
IT STAFFING SERVICES SOLICITATION UNDER DEPARTMENT OF INFORMATION RESOURCES IT STAFF AUGMENTATION CONTRACT (ITSAC) ================================================================================== IV. WORK HOURS AND LOCATION A. Services shall be provided during normal business hours unless otherwise coordinated through the TEA. Normal business hours are Monday through Friday from 9:00 AM through 5:00 PM, excluding State holidays when the agency is closed. B. The primary work location(s) will be at 1701 North Congress Ave., Austin, Texas, 78701.
Page 4 of 7
IT STAFFING SERVICES SOLICITATION UNDER DEPARTMENT OF INFORMATION RESOURCES IT STAFF AUGMENTATION CONTRACT (ITSAC) ==================================================================================
FORM A – VENDOR INFORMATION/WORKER LIST FORM Working Title: Data Warehouse Integration Solicitation Number: 70112051 ITSAC Level Description: Data Warehouse Architect 2
Primary Vendor Information
Primary Vendor HUB Ethnicity & Gender Codes
Analyst ITSAC Technology Type: Emerging
Vendor Name: EKHP Consulting, LLC Address: 425 Oak Springs Dr. Seguin, Texas Vendor Contact: Bill Peek Phone Number: 512-925-4541 Email: bill@ekhpconsulting.com Asian Male
American Indian
Female
Male
Female
Black
Hispanic
Male Female
Male Female
(Only check one)
Woman Owned N/A Female X
Worker # 1 Worker Name Hourly Rate Date of availability NO _____ YES _____ If YES, complete the SUB-Contracting information below. Is the Worker being Sub-Contracted? Sub – Contracted Vendor Name Sub Contract Percentage Sub- Contracted Vendor Asian American Indian Black Hispanic Woman Owned N/A HUB Ethnicity & Gender Female Male Female Male Female Male Female Male Female Codes
Worker # 2 (as applicable) Worker Name Hourly Rate Date of availability Is the Worker being Sub-Contracted?
NO _____ YES _____ If YES, complete the SUB-Contracting information below.
Sub – Contracted Vendor Name Sub - Contract Percentage Sub - Contracted Vendor Asian American Indian HUB Ethnicity & Gender Male Female Male Female Codes
Black
Hispanic
Male Female
Male Female
Woman Owned N/A Female
By submission of this form Vendor acknowledges familiarity with DIR Staffing Services Contract and agrees to abide by all the terms and conditions as specified in the contract.
Page 5 of 7
IT STAFFING SERVICES SOLICITATION UNDER DEPARTMENT OF INFORMATION RESOURCES IT STAFF AUGMENTATION CONTRACT (ITSAC) ================================================================================== FORM B – WORKER REFERENCE FORM
Working Title: Data Warehouse Integration Analyst ITSAC Level Description: Data Warehouse Architect 2 ITSAC Technology Type: Emerging
Solicitation Number: 70112051
Worker Name (Required):
Reference Name (Required): Title (Optional) Company Name (Required): Phone Number (Required include area code): E-mail address (Optional): Professional Relationship: (Optional): Peer
Co-Worker
Supervisor
Customer
End-User
Subordinate
Reference Name (Required): Title (Optional) Company Name (Required): Phone Number (Required include area code): E-mail address (Optional): Professional Relationship: (Optional): Peer
Co-Worker
Supervisor
Customer
End-User
Subordinate
Reference Name (Required): Title (Optional) Company Name (Required): Phone Number (Required include area code): E-mail address (Optional): Professional Relationship: (Optional): Peer
Co-Worker
Supervisor
Customer
End-User
Subordinate
NOTE: ONLY INCLUDE THE INFORMATION REQUESTED ON THIS FORM. DO NOT INCLUDE ADDITIONAL INFORMATION.
Page 6 of 7
IT STAFFING SERVICES SOLICITATION UNDER DEPARTMENT OF INFORMATION RESOURCES IT STAFF AUGMENTATION CONTRACT (ITSAC) ==================================================================================
FORM C – WORKER REQUIREMENTS GRID SHEET Working Title: Data Warehouse Integration Analyst ITSAC Level Description: Data Warehouse Architect 2 ITSAC Technology Type: Emerging
Solicitation Number: 70112051
(This is Page 1 of the Worker Resume) Worker Name (Required): Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will not be considered for this opportunity and the resume will not be submitted to the customer. Skills/Experience Years Years Vendor (Required, Comments (as leave no applicable) blanks) 7 Experience with industry data standards and database architecture 7 Experience with XML 7 Experience with design and integration principles for complex, heterogeneous databases 7 Experience with diagnosis and resolution of complex data infrastructure issues including development of methods to identify and resolve data incompatibilities among systems 5 Experience in integration of complex multi-Vendor sites, systems and applications 5 Must have a strong analytical, problem-identification and process analysis skills with the ability to envision a solution from requirements 5 Three (3) plus years Oracle 10g (greater) as well as another enterprise database 5 Professional who works well independently or as part of a team 5 Three (3) plus years SQL based language 5 Work experience and knowledge in managing the integration and maintenance of complex multi-Vendor sites and applications 5 Must have excellent communication skills both orally and in writing 3 Work experience with Software as a Service (SaaS) 3 Experience with SQL tuning and optimizing 3 Work experience and understanding of software development lifecycle methodologies, thorough knowledge of the software specification process and software development processes, and software architecture. 2 Exposure to data warehouse architectures Preferences: Years (Optional)
Years
3 3
Skill/Experience
Vendor Comments (as applicable)
Experience with management tools like Optimal Trace and UML modeling tools like Enterprise Architect Experience with defining business workflow.
Page 7 of 7