Part-time Instructor- IST722 Data Warehouse



Job description

Job #

077023Location: Syracuse, NY

Pay Range: Commensurate w/ Experience

FLSA Status: Exempt

Hours: Fall 2023 on Campus, Mondays 9:30-12:15pm
Office hours required.

Rank: PTI/Adjunct

Campus: Syracuse, NY

Unionized Position Code: UA

Job Description

School of Information Studies is seeking part time instructor who can teach IST 722: Data Warehouse- Introduction to concepts of business intelligence (BI) and the practice/techniques in building a BI solution. Focuses are on how to use data warehouses as a BI solution to make better organizational decisions.
After taking this course, students will be able to:

* Describe various database constructs – ODS, Data Warehouse, Data Mart
* Describe the components of a data warehouse
* Differentiate between Ralf Kimball’s and Bill Inmon’s approaches
* Describe various integration approaches – ETL, EII, EAI

* Describe a Master Data Management (MDM) solution
* Create database objects using popular database management system products
* Design and implement data warehouse and business intelligence components
* Define the roles and responsibilities in the design and development of data warehouses
* Differentiate various requirements gathering and dimensional modeling techniques
* Define project management guidelines
* Describe the data governance concepts
* List some of the recent trends in Data WarehouseQualifications

  • Bachelor’s degree required, Master’s preferred in field related to Information Systems or Data Science, OR 5 or more years of experience as a data scientist

Job Specific Qualifications


Successful candidates will be prepared to serve as instructor and mentor and be willing to work with the Professor of Record, Program Director, and other instructors teaching this class. This course has a developed syllabus, exercises, and texts, however, we seek individuals who can bring their own experiences to the course.
* Collaborate with professor of record and/or program director, who is responsible for creating the course syllabus and course content, as well as providing an overview of their overall vision for the course.
* Attend onboarding and training with the iSchool’s Faculty Center for Teaching and Learning
* Maintain office hours and open communication with students.
* Maintain the course in the Blackboard Learning Management system
* Grade student assignments and exams in a timely manner; provide feedback when appropriate.
* Prepare for weekly in person sessions with students
* Prepare to offer the class in the Fall 2023 semester, in person, on campusPhysical Requirements

“Not Applicable”Tools/Equipment

“Not Applicable”Application Instructions

In addition to completing an online application, please attach a curriculum vitae and cover letter.About Syracuse University

Syracuse University is a private, international research university with distinctive academics, diversely unique offerings and an undeniable spirit. Located in the geographic heart of New York State, with a global footprint, and nearly 150 years of history, Syracuse University offers a quintessential college experience.

The scope of Syracuse University is a testament to its strengths: a pioneering history dating back to 1870; a choice of more than 200 majors and 100 minors offered through 13 schools and colleges; nearly 15,000 undergraduates and 5,000 graduate students; more than a quarter of a million alumni in 160 countries; and a student population from all 50 U.S. states and 123 countries. For more information, please visit the Syracuse area

Syracuse is a medium-sized city situated in the geographic center of New York State approximately 250 miles northwest of New York City. The metro-area population totals approximately 500,000. The area offers a low cost of living and provides many social, cultural, and recreational options, including parks, museums, festivals, professional regional theater, and premier shopping venues. Syracuse and Central New York present a wide range of seasonal recreation and attractions ranging from water skiing and snow skiing, hiking in the Adirondacks, touring the historic sites, visiting wineries along the Finger Lakes, and biking on trails along the Erie Canal.EEO Statement

Syracuse University is an equal-opportunity, affirmative-action institution. The University prohibits discrimination and harassment based on race, color, creed, religion, sex, gender, national origin, citizenship, ethnicity, marital status, age, disability, sexual orientation, gender identity and gender expression, veteran status, or any other status protected by applicable law to the extent prohibited by law. This nondiscrimination policy covers admissions, employment, and access to and treatment in University programs, services, and activities.Commitment to Supporting and Hiring Veterans

Syracuse University has a long history of engaging veterans and the military-connected community through its educational programs, community outreach, and employment programs. After World War II, Syracuse University welcomed more than 10,000 returning veterans to our campus, and those veterans literally transformed Syracuse University into the national research institution it is today. The University’s contemporary commitment to veterans builds on this historical legacy, and extends to both class-leading initiatives focused on making an SU degree accessible and affordable to the post-9/11 generation of veterans, and also programs designed to position Syracuse University as the employer of choice for military veterans, members of the Guard and Reserve, and military family members.Commitment to a Diverse and Inclusive Campus Community

Syracuse University maintains an inclusive learning environment in which students, faculty, administrators, staff, curriculum, social activities, governance, and all other aspects of campus life reflect a diverse, multi-cultural, and international worldview. The University community recognizes and values the many similarities and differences among individuals and groups. At Syracuse, we are committed to preparing students to understand, live among, appreciate, and work in an inherently diverse country and world made up of people with different ethnic and racial backgrounds, military backgrounds, religious beliefs, socio-economic status, cultural traditions, abilities, sexual orientations and gender identities. To do so, we commit ourselves to promoting a community that celebrates and models the principles of diversity and inclusivity.Open Until Filled: Yes

Job Category: Faculty

How to apply

Apply now

Syracuse University is interested in candidates who have the communication skills and cross-cultural abilities to maximize their effectiveness with diverse groups of colleagues, students and community members. Women, military veterans, individuals with disabilities, and members of other traditionally underrepresented groups are encouraged to apply. Syracuse University is an equal opportunity employer, as well as a federal contractor required to take affirmative action on behalf of protected veterans.

If you apply for this position or indicate an interest advise the HR person you saw this advertisements on

From its founding in 1870, Syracuse University has been the embodiment of Scholarship in Action—education that transcends traditional boundaries through a combination of innovative thinking, daring choices and entrepreneurial attitude. Our iconic campus is nestled amongst the rolling hills of Central New York—itself a crucible of historic change and progress.