Part-Time Faculty - Data Warehousing (IST722)
Location: Syracuse, NY
Pay Range: Commensurate with Experience
FLSA Status: Exempt
Hours: As determined by Associate Dean for Academic Affairs
Campus: Syracuse, NY
Unionized Position Code: UA
Job DescriptionThe School of Information Studies at Syracuse University seeks a Part-time Instructor to teach one section of IST722 - Data Warehousing, Spring 2022 (3 credits)
This course provides concepts, principles, and tools for designing, implementing, and using Data Warehouses. More specifically, we introduce database constructs such as Operational Data Store (ODS), Data Warehouse, and Data Mart, as well as their components. We study the differences between Ralf Kimball's and Bill Inmon's approaches, roles and responsibilities in the design and implementation of a Data Warehouse, project management guidelines and techniques, requirements gathering, dimensional modeling, Extract Transform and Load (ETL) architecture, specification and data loading, master and reference data management, integration approaches (ETL, EII, EAI), analytical reporting concepts, data governance and recent trends in the data warehouse domain.
The course will leverage a portfolio of SQL Server tools that include SQL Server DBMS, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Service (SSAS) to provide hands-on experience in implementing a reporting solution through assignments, lab exercises and projects.
QualificationsMaster's degree in Applied Data Science, Enterprise Data Systems, or related field.
Candidates should have a minimum of two years of teaching experience at the college
or university level.
Job Specific Qualifications.
- Collaborate with professor of record, 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 (FCTL)
- Making semester-by-semester updates to due dates.
- 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 with appropriate.
- Prepare for weekly in-person or virtual sessions with students.
Physical Requirements"Not Applicable"
Application InstructionsIn addition to completing an online application, please attach a curriculum vitae and cover letter.
About Syracuse UniversitySyracuse 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 www.syracuse.edu.
About the Syracuse areaSyracuse 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.
EEOCSyracuse 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 VeteransSyracuse 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 CommunitySyracuse 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