Subscribe:   RSS  RSS   Mail Alerts  Mail Alerts  
   

Programmer/Analyst

Job Category:
Technology Provider
Career Level:
Mid Career (2+ years of experience)
Job Type:
Full Time/Permanent
Positions:
1
Company Name:
UCLA
City:
Los Angeles
Country:
USA
Description:
Job Summary
Requisition Number: 25425  
Job Title: PROGRAMMER/ANALYST IV  
Working Title: Data Warehouse Architect, Student Information Systems  
Salary: Salary commensurate with skills, knowledge and experience.  
Job Type: Contract  
Department Name: 4100-ADMINISTRATIVE INFORMATION SYSTEMS  
Department Website URL: www.it.ucla.edu  
Job Summary Statement: As a member of the IT Services Information & Data Strategy Team, the Data Warehouse Architect will be responsible for the analysis, design and deployment of the Operational Data Store (ODS) and data marts for the implementation of UCLA's next generation Student Information System (SIS). Major responsibilities include working collaboratively with functional and technical analysts and subject matter experts to gather business requirements for the design and development and deployment of data models and design specifications using star schema techniques; analyze and create Extract-Transform-Load (ETL) specifications; collaborate with Business Intelligence Analysts, conduct system performance analysis and problem resolution. The Data Warehouse Architect will develop and oversee data warehouse specific project plans, comprehensive testing of system to ensure data integrity and ensuring effective alignment of business requirements with technical solutions.  
Percentage of Time: 100  
Shift Start: 8:00 am  
Shift End: 5:00 pm  
Qualifications for Position
11 Records
  Qualifications Required/Preferred
  Bachelor's degree in relevant discipline OR five years (or more) of equivalent experience. Required
  Five or more years demonstrated experience in database management, application development or systems engineering. Required
  Demonstrated experience integrating in data management practices and principals into life-cycle. Required
  Possess broad and deep technical skills with various operating systems, databases, protocols and programming languages to evaluate highly complex systems or applications. Required
  Experience applying modern data management frameworks and methods. Required
  Possess the verbal and written communication skills to work effectively with technical and non-technical personnel at various levels in the organization; ability to use standard English grammar and punctuation. Required
  Demonstrated knowledge of Kimball Lifecycle Methodology for Data Warehouse and Business Intelligence solutions. Required
  Experience using SQL Server including knowledge with associated architecture, tools and security. Required
  Advanced skill in creating indexes, aggregations and stored procedures suing SQL programming and data analytics. Required
  Advanced skill in developing Extract-Transform-Load (ETL) specifications. Required
  Experience working within a higher-education information technology organization with emphasis on Data Warehousing. Preferred
   

 
Additional Posting Information
Bargaining Unit: 99-Policy Covered  
Application Deadline: 05-03-2017  
External Posting Date:  
Quicklink To Posting: hr.mycareer.ucla.edu/applicants/Central?quickFind=69997  
Special Instructions: This is a one-year contract appointed position with standard employee benefits. 

NOTE: This position REQUIRES that a RESUME, COVER LETTER, and SALARY HISTORY be submitted in addition to the application. Please have ALL THREE FILES ready to upload when applying.  
Contact information:  
Number of Positions:  
Special Employment Designations/ Requirements Per UC Policy
Conflict of Interest: N/A  
Critical: Continued employment contingent upon completion of satisfactory background investigation.  
Driving Record: N/A  
E-Verify Check:

Certain positions funded by federal contracts/subcontracts requires UCLA to notify job applicants that an E-Verify check will be conducted and the successful candidate must pass the E-Verify check.

More Information
This position does not require E-Verify check.  
CANRA:
Is this position designated as a mandatory reporter under CANRA?
No  
Other Special Employment Requirements:  
Position is subject to performance standards and other requirements of the University wide Police Policies and Administrative Procedures.  
Return to Search Results
 

 

 
 

The University of California is an Equal Opportunity/Affirmative Action Employer advancing inclusive excellence. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected categories covered by the UC nondiscrimination policy. UC Nondiscrimination & Affirmative Action Policy


UCLA is a Tobacco-Free environment. For more information, please view the policy at Tobacco-Free Campus Policy 

For additional support, please visit http://peopleadminsupport.com/5-8/