DATA WAREHOUSE SPECIALIST - JOB 45588

DATA WAREHOUSE SPECIALIST – JOB 45588 ACTUNIVERSITY OF CALIFORNIA, SAN DIEGOLOCATION: SAN DIEGO, CA (LA JOLLA 92093)Salary commensurate with qualifications and experienceFULL SALARY RANGE: $56,500- $128,000/ANNUALLYFull Time Position. Open Until Filled To receive full consideration for this position, applicants must please complete the following two steps:1. Apply to the position via the UC San Diego Online Application/Resume form. https://joblink.ucsd.edu/awb/resume/create_resume.html2. Visit the Administrative Computing & Telecommunications (ACT) Information Technology (IT) Jobs page (http://www.act.ucsd.edu/jobs/dw_specialist_43770.html) and answer the questions associated with the position (Job #45588). Send your answers and a copy of your resume to actjobs@ucsd.edu Join the UC San Diego Team! UC San Diego offers a unique and supportive working environment for employees, providing excellent benefits the day you start, a vibrant campus community, and a range of career development options. Founded on principles of individual integrity, mutual respect, and trust, UC San Diego has earned national recognition for its technology solutions and management philosophy. Administrative Computing and Telecommunications (ACT) at UC San Diego houses a team of top IT professionals developing innovative technology for higher education. ACT serves a unique clientele, and we are always working to increase the functionality and usability of campus technology for all users. Additionally, at ACT, we offer excellent training opportunities for staff.Become part of UC San Diego’s IT Infrastructure team, a leading edge group who is responsible for supporting over 60,000 on-campus users. This team is consistently held up as a model of how to implement advanced data warehouse methodologies and support data warehouse technology to other university teams.DESCRIPTION:The Data Warehouse Specialist will be responsible for researching, recommending, mentoring internal staff and potentially implementing ETL processes and methodologies using INFORMATICA, DB2 UDB and UNIX along with other tools and methodologies to support a highly diverse Data Warehouse environment. In addition, duties would also include developing, implementing and maintaining server-based Data Warehouse systems.Specific duties could include the complete detail responsibility for one or more Data Warehouse sub-systems (e.g., student). Duties include giving direction and assistance to other personnel on assigned projects, assisting campus departments with their Data Warehouse-based information needs, providing presentations and support for production systems. Development and support is performed on high-end server systems using modern relational and data warehouse DBMS software.QUALIFICATIONS:* In-depth understanding of data warehouse and business intelligence tools, technologies, architecture, and trends in data and information management. Proven ability to leverage extensive expertise in data warehousing and business intelligence to develop 'best in class' strategic vision for data management.* Proficiency in business analysis, event modeling, data modeling including dimensional modeling, logical and physical database design, database optimization, load strategy design including transformation, loading and cleansing.* Extensive knowledge of INFORMATICA, SQL and DB2UDB.* Ability to think independently to provide solutions and procedures to central administrative databases.*Proven project leadership ability and experience in directing other technical staff in the development and implementation of complex computerized databases. Minimum of six years of successful data warehousing project experience.* Experience in providing training and support to other technical staff. Strong facilitation, influencing and team consensus-building skills.* Knowledge and experience with Data Warehouse ETL tools such as Informatica with a minimum of two years required.SPECIAL CONDITIONS OF EMPLOYMENT: Background check required.UC San Diego is an Equal Opportunity / Affirmative Action Employer that values a diverse workforce.