UCSD – Data Warehouse Application Services Support

Must Apply Here: http://jobs.ucsd.edu/bulletin/job.aspx?cat=informationsortby=postjobnum_in=60902

DESCRIPTION
Under the direction of the ACT External Affairs Data Team Supervisor, the Data Warehouse Application Services Analyst will be responsible for providing complex data analysis, supporting client ad-hoc and scheduled reporting requests, and using available tools to import and export data from various sources into the External Affairs constituent database. This position will serve the entire External Affairs community, other constituents on the UC San Diego campus as well as the UC Office of the President. The data as well as the reporting services are critical to the development efforts of the university and directly affect the UC San Diego capital campaign. The incumbent's primary focus will be to ensure the continuous availability of data for software systems and the integrity of the data provided by these systems.

QUALIFICATIONS
Experience with relational databases, including, but not limited to DB2, SQL Server and Microsoft Access. Proven experience using MS SQL Server SQL. Experience using SQL scripts, cursors, and advanced SQL functions.

Proven experience using Crystal Reports.

Proven experience using Sage Software's Millennium constituent management system. This experience should include using the front end user interface and also expert knowledge of the database behind the Millennium system.

Ability to test and resolve database issues as needed; experience with software quality assurance methods and policies.

Proven creativity, decision making, and follow-up, flexibility, initiative, interpersonal effectiveness, political acumen, and quantitative analysis.

Able to work with staff with varying skills/knowledge and reach consensus as needed in order to support business needs.

SPECIAL CONDITIONS
Background check is required.

UC San Diego is an Equal Opportunity / Staff Affirmative Action Employer that values a diverse workforce and provides reasonable accommodations to people with disabilities.