San Jose State University Data Warehouse ETL/BI Developer in San Jose, California


Classification: Analyst/Programmer - Career Salary Range: $4,372/month to $9,877/month FLSA status: Exempt

San Jose State University offers employees a comprehensive benefits package. For more information on programs available, please visit

About the Position

Reporting to the Director of Web and Campus Apps, the Data Warehouse ETL/BI Developer supports SJSU's Student Data Warehousing/Business Intelligence implementation. This position will play a key role in the design, creation, development, and maintenance of Student Data Warehouse.

Responsibilities include, but are not limited to:

  1. Business systems analysis
  • Consult with users to assess their needs and communicate technology systems and solutions.

  • Analyze business and technical problems, performs systems analysis and design, identifies and assesses alternative solutions to make appropriate recommendations, and develops suitable application specifications.

  1. ETL Development/Programming
  • Use industry standard programming languages and frameworks to develop, support and integrate solutions into Student Data Warehouse.

  • Perform Business analysis, analyze source data, translate business requirements and manage data models.

  1. Data reporting and analytics
  • Write SQL statements and scripts, and develop custom reports using OBIEE, Tableau.

  • Migrate and enhance reports as needed to Student Data Warehouse.

  • Develop efficient database manipulation code to ensure reliable and consistent result sets.

  1. Customer service and communication
  • Triage and address support tickets for timely resolution.

  • Work effectively with business partners and peers. Promote collaboration and customer service culture

  • Document plans, roadmaps and communicate to IT and Functional groups.

Education and Experience

A bachelor's degree, preferably in computer science or business, or equivalent training and applied experience and three years of experience in business applications analysis, design, and programming for medium or large scale, multi-programmed computers.

Preferred Qualifications

  • 5 years of development experience with People Code, Application Engine, Integration Broker, Component Interface and PeopleSoft web services

  • 5 plus years of experience leading PeopleSoft Student Application implementation and/or upgrade projects.

  • 2 plus years of PeopleSoft version 9.0 or greater and People tools 8.53 experience focusing on Campus Solution modules and Student Applications; Transfer Credit Rules, Degree Audit, Advisement and Records applications

  • 3 plus years of experience developing business requirements and leading systems analysis, design, and testing;

  • 3 plus years of experience in troubleshooting and testing Oracle/PeopleSoft Student Administration modules and integrations.

  • 2 plus years of experience with setting standards, creating and maintaining application architecture and design and leading technical and functional teams.

  • 3 plus years of experience with database design and development, SQL, Stored Procedures, and Triggers.

Knowledge, Skills & Abilities

  • Expert in Oracle Database, SQL, PL/SQL, ETL integration tools like IBM DataStage, ODI, Informatica and SSIS etc.

  • Strong knowledge in Oracle Data Integrator and OBIEE.

  • Strong understanding of Enterprise Data modeling and Enterprise Data Dictionary methods.

  • Advanced knowledge of enterprise data architecture, ETL integration, data warehousing techniques, analytics/end-user reporting toolsets.

  • Advanced knowledge of Systems development life cycle methodologies (Agile and Waterfall) in order to develop effective systems.

  • Advanced knowledge of solution architecture, data architecture and programming techniques.

  • Advanced knowledge of application development, testing and deployment processes and tools.

  • Advanced knowledge of Performance tuning techniques and related database designs.

  • Working knowledge of Java, JavaScript and Python.

  • Working knowledge of Oracle PeopleSoft or equivalent enterprise system.

  • Working knowledge of software code repositories (e.g. TFS, subversion) and release management process.

  • Working knowledge of Quality assurance and quality control methodologies in order to comply with established standards.

  • Working knowledge in conducting technical reviews, creating definition of business problems, including the preparation of business/technical requirements to support the mission of the university and administrative departments;

  • Strong consultative skills to assess user needs, analyses business processes, and communicate technology solutions.

  • Strong communication skills with team members - listening first.

  • Maintain cooperative working relationships with various individuals to ensure a cohesive working environment.

  • Work independently to ensure work activities are completed in a timely and efficient manner.

  • Working knowledge of Application program documentation techniques to ensure application development processes are recorded according to standards.

Posting Date

October 12, 2017

Application Screening

Application Screening begins October 27, 2017. Applications received before that date will receive first consideration.

This position is open until filled; however, applications received after screening has begun will be considered at the discretion of the university.

Required Application Material:

Resume Letter of interest List of References Letter of Recommendation Complete SJSU Online Employment Application

Please note that failure to completely fill out each section of the online application may result in your application not receiving consideration.

Note To Applicant

Every applicant who reaches the final level of interviews will be required to complete a background check. The standard background check includes: criminal check, employment and education verification. Depending on the position, a motor vehicle and/or credit check may be required. All background checks are conducted through the university's third party vendor, Accurate Background. SJSU will pay all costs associated with this procedure. Evidence of required degree(s) or certification(s) will be required at time of hire.


All San José State University employees are considered mandated reporters under the California Child Abuse and Neglect Reporting Act and are required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment.

Equal Employment Statement

SJSU is an Equal Opportunity Affirmative Action employer. We consider qualified applicants for employment without regard to race, color, religion, national origin, age, gender, gender identity/expression, sexual orientation, genetic information, medical condition, marital status, veteran status, or disability.

It is the policy of SJSU to provide reasonable accommodations for applicants with disabilities who self disclose.

Contact Information

One Washington Square San Jose, CA 95192-0046 Phone: 408-924-2250

Job Title: Data Warehouse ETL/BI Developer

Job ID: 24301

Full/Part Time: Full-Time

Regular/Temporary: Regular

Job Code: 0400

Department: Web & Campus Applications