Job Description: San Diego State University Research Foundation
IS Analyst Programmer III
US-CA-San Diego
Job ID: 2024-18354 Type: Full-Time Contract # of Openings: 1 Category: Information Technology Global Campus
Overview
The salary range for this position is $6,686.00 - $8,333.33 per month depending upon qualifications and is non-negotiable.
SDSU Global Campus strives to be a global leader in providing innovative education programs that transform lives locally and internationally. Our mission is to deliver innovative educational experiences to all learners through credit and non-credit academic and special programs for individuals and groups at various times, in myriad locations, and via different modalities throughout the year.
Responsibilities
The IS Analyst Programmer III will be actively involved in the evaluation, review, and management of database resources and services across the organization in order to ensure a high level of database integrity is reached and maintained. The ideal candidate will have a proven track record of forming an excellent database infrastructure in close collaboration with Global Campus colleagues and vendors. While providing the database expertise needed for the team’s success, this individual will be required to help provide guidance for a team to develop, implement, and enforce high-quality database standards. This position reports to the Director of Facilities and Information Technology.
Database and Data Management 40%
Design, create, maintain, and manage Enterprise Data Warehouses (EDW), data lakes, data marts, Operational Data Stores (ODS), and data mining solutions.
Develop, manage, and optimize Extract Transform Load (ETL) processes, and manage XML data, indexes, T-SQL, stored procedures, views, functions, and data manipulation scripts.
Provide database administration including creation, modification, testing, monitoring, tuning, backup, and recovery.
Technical Documentation and Support 15%
Create comprehensive and clear data dictionaries for all database efforts, documenting:
Logical data element name, definition, context, and domain (allowable values).
Data type, length, and unit of measure.
Provide consulting services and technical support related to database administration and troubleshooting.
Ensure detailed project documentation is created and communicated clearly.
Integration and Reporting 15%
Maximize the use of SQL Server Integration Services (SSIS) for data integration and SQL Server Reporting Services (SSRS) for information delivery.
Leadership and Collaboration 10%
Lead and support a team of system administrators.
Contribute to the development of solutions based on technical specifications and business requirements.
Contribute to business process and workflow mapping.
Stakeholder Engagement 10%
Attend and actively participate in stakeholder meetings, including documenting meeting records.
Additional Duties as Assigned 10%
Qualifications
Knowledge & Abilities
Ability to use systems workflow and logic flowchart techniques.
Knowledge of formal data flow analysis methodologies.
Ability to apply and use operations analysis and structured design analysis techniques.
Knowledge of campus-defined systems, applications, and standards.
Ability to identify hardware/software interface problems.
Knowledge of system/equipment capability, design restrictions, and security requirements.
Knowledge of system development life cycle and structured systems development concepts.
General knowledge of network connectivity, integration, configuration, and protocols.
Understanding of and ability to integrate all systems including operating systems, applications, network,
and databases, as well as knowledge of distributed processing technology.
Knowledge of client/server technologies.
Ability to communicate effectively.
Ability to apply consultative skills to assess user needs and communicate technology systems and solutions.
Ability to perform systems and applications needs analysis, prepare requests for proposals, and conduct
feasibility studies.
Ability to use project management tools.
Ability to research and evaluate the functionality of vendor software to meet user needs, assess vendor
proposals, and serve as a technical/vendor liaison.
Minimum Education & Experience
Bachelor’s degree, preferably in computer science or business, or equivalent combination of education and relevant experience AND appropriate Oracle Certification.
Four-years of related work experience
Preferred Qualifications & Special Skills
Familiar with data cleansing; Programming in XML, T-SQL, JAVA, C, C++, Python and Perl development languages.
3+ years of experience leading an IT team.
Strong knowledge of high-availability and disaster recovery in relational database environments. Experience collaborating with teams across an organization.
Ability to perform in a fast-paced environment across multiple projects and issues with various timelines.
Excellent communication and presentation skills.
Familiar with Cloud implementation.
Experience working in higher education environments.
What We Offer
Comprehensive medical, dental, and vision plans
Life and disability insurance plans
Generous employer contributed 403b retirement plan. We match 200% on the first 5% of contributions, up to 10% maximum employer matching contribution. All contributions are 100% vested.
Vacation and sick leave accruals
Employee Assistance Program (EAP)
Access to campus amenities, including Love Library, Aztec Lanes bowling alley, SDSU transit center, and a variety of coffee shops and eateries.
Discounted Aztec Recreation Center gym membership and SDSU events
Wellness workshops
Additional Applicant Information
Candidate must reside in California and live in a commutable distance from SDSU at time of hire.
Job offer is contingent upon satisfactory clearance based on Background Check results (including a criminal record check).
San Diego State University Research Foundation is an EEO/AA/Disability/Vets Employer/Title IX employer.
