Data Warehouse ETL/BI Developer

Location
San Jose, CA
Posted
Mar 29, 2018
Institution Type
Four-Year Institution

Job ID: 24332
Full/Part Time: Full-Time
Regular/Temporary: Regular
Job Code: 0400
Department: Web & Campus Applications

Compensation

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 http://www.sjsu.edu/hr/benefits/

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.

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.
- Research and evaluate the functionality of vendor or other CSU campus software to meet user needs, and serve as a technical liaison.

2. 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.
- Develop new ETL scripts supporting new custom functions as well as enhancements to existing functions.

3. 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.

4. 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.

5. Knowledge Skills & Abilities:
- Expert in Oracle Database, SQL, PL/SQL, ETL integration tools like IBM DataStage, Oracle Data Integrator(ODI), Informatica and SSIS etc.
- Strong knowledge in Oracle Data Integrator(ODI) 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.
- Skills to assess application program operational and maintenance procedures to ensure efficient program functioning
- Writing/Presentations- Communicating effectively in writing and in creation of presentations as appropriate for the needs of the audience.
- Complex problem solving and conflict resolution skills.
- Skills to assess and address operational and administration procedures supporting the SJSU application programming needs.
- Grasp new concepts in order to keep up with changes in the industry.
- Time Management - Ability to multi-task. Efficient use of others time.
- High EQ (Emotional IQ).

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-6 years of experience with Oracle Database, SQL, PL/SQL, and any of ETL integration tools like IBM DataStage, Oracle Data Integrator(ODI), Informatica, SSIS etc.
- 3-4 years of experience with analytics/end-user reporting toolsets.
- 2-3 years of experience in Oracle Data Integrator(ODI), OBIEE.
- Experience with Enterprise Data modeling.
- Experience with Enterprise Data Dictionary methods.
- 3-4 years of experience Java, JavaScript and Python.

Knowledge, Skills & Abilities

- Expert in Oracle Database, SQL, PL/SQL, ETL integration tools like IBM DataStage, Oracle Data Integrator(ODI), Informatica and SSIS etc.
- Strong knowledge in Oracle Data Integrator(ODI) 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

November 14, 2017

Application Screening

Application Screening begins November 28, 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.

SJSU IS NOT A SPONSORING AGENCY FOR STAFF OR MANAGEMENT POSITIONS. (i.e. H1-B VISAS)

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

PI101820227

Similar jobs

Similar jobs