The Business Intelligence unit in Administrative Information Services (AIS) has an opening for a highly motivated Programmer/Analyst. The successful candidate will be responsible for the development of the extraction, transformation and load processes (ETL) to support the new Penn State Institutional Data Warehouse as well as the existing Data Warehouse, using a combination of SSIS packages, SQL store procedures and transact SQL. This includes understanding requirements; analyzing design alternatives by weighing costs and technical implications; application development and testing; providing tier two operational support; and creating documentation, procedures, and standards.
This job will be filled as a level 3, or level 4, depending upon the successful candidate's competencies, education, and experience.
Typically requires a Bachelor’s degree or higher plus four years of related experience, or an equivalent combination of education and experience for a level 3. Additional experience and/or education and competencies are required for higher level jobs. Candidates must have strong data analysis skills and current working knowledge of Microsoft SQL Server 2008, including Integrations Services (SSIS) and SQL Programming. Familiarity with ADABAS, Natural, and JCL is a plus. Candidates with knowledge and experience with Extract, Transform, and Load (ETL) processes, data conversion, and data warehousing will be preferred. The candidate must have excellent written and interpersonal communication skills, and must demonstrate commitment to quality work products and customer service. The successful candidate must be able to identify and solve problems independently, be detail oriented, be able to handle sensitive data professionally, and must be able to work effectively with people of diverse cultural backgrounds.
This is a fixed-term appointment funded for one year from date of hire with excellent possibility of re-funding.
Apply to job 38813 at http://www.psu.edu 
Penn State is committed to affirmative action, equal opportunity and the diversity of its workforce.