This company is committed to hiring Veterans

Data Warehouse Architect, Student Information Systems

This job is no longer active. View similar jobs.

POST DATE 9/2/2016
END DATE 10/9/2016

University of California - Los Angeles Los Angeles, CA

Company
University of California - Los Angeles
Job Classification
Full Time
Company Ref #
23977
AJE Ref #
576076016
Location
Los Angeles, CA
Experience
Mid-Career (2 - 15 years)
Job Type
Regular
Education
Bachelors Degree

JOB DESCRIPTION

APPLY
JOB SUMMARY

Requisition Number:
23977

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:


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 equivalent combination of education and 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:
10-07-2016

External Posting Date:


Quicklink To Posting:
hr.mycareer.ucla.edu/applicants/Central*quickFind=68210

Special Instructions:
This will be a two year Contract Appointment.

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