University of Calgary
UofC Navigation
Share this Job:

Instructors, Data Preparation and Dimensional Modeling & Data Analysis and Presentation, Continuing Education

Job ID: 15063

Updated: June 13, 2018

Location: Main Campus

Position Description

University of Calgary Continuing Education (UCCE) houses one of Canada's largest and most successful continuing education departments. It is a multi-disciplinary unit offering diploma, certificate and non-degree programs in the classroom and online through technologies for course delivery.

In support of the University of Calgary's core principles and financial objectives, Continuing Education is an academic unit with a mandate to respond to the needs of the community through the design, development and delivery of high-quality lifelong learning opportunities.

Each year, UCCE serves over 20,000 adult learners and offers more than one thousand courses taught by hundreds of instructors—all experts in their fields. It is expected to fund, through revenue generation, the majority of its operational costs while contributing financially to the university.

The success of University of Calgary Continuing Education in meeting its business target in a competitive environment is dependent upon effectively serving students and by providing high-quality instruction and programs.

Position Description

University of Calgary Continuing Education is currently recruiting for an instructor (contract (term) position) to teach the following ICT 706 – Data Preparation and Dimensional Modeling – Classroom delivery course and ICT 707 – Data Analysis and Presentation – Classroom delivery course.

These instructional positions are non-credit teaching appointments and, as such, are contract positions without benefits (other than those required by Employment Standards).

Course details:

  • ICT 706 – Data Preparation and Dimensional Modeling – [Classroom Delivery]

FALL Monday - Friday, October 1-5, 2018

Monday – Friday: 9 am – 4 pm, Classroom delivery only, Downtown Campus

 

  • ICT 707 – Data Analysis and Presentation – [Classroom Delivery]

FALL Monday - Friday, October 15-19, 2018

Monday – Friday: 9 am – 4 pm, Classroom delivery only, Downtown Campus

 

Course Description (706):

This course will help business and technical people, providing training and exposure that is necessary for both development and the effective use of common data systems.

The ability to use data systems has become an essential skill for the modern business and data analyst in the workplace. The volume and the complexity of modern data analysis requires a fundamental understanding of the systems designed to serve data requirements.

Students will learn the rudiments of standard and analytically-oriented data storage theory and design complemented by hands-on development. Upon completion of this class, students will be able to explain and execute the process of creating an analytical data solution, from conceptual design, transforming and loading data, to the exposure of information through an analytical semantic layer.

Course Level Learning Outcomes (706):

  • Develop basic ETL Packages
  • Design, develop and implement a SQL Server BI solution using the Analysis Services Tabular Model
  • Query a Tabular Model with DAX
  • Develop familiarity with SQL Server BI Client Tools through hands on work

Course Description (707):

In this course, students will learn to create useful analysis for the business within a functional reporting framework. Also, students will learn to gather the right requirements and ask the right business questions to create dashboards and reports for presenting the results of business analysis using the MAD framework.

Business Intelligence is often misunderstood because it resides in-between the business and the technology departments of an organization. Both its challenges and its potential are borne from the dependence on collaboration to achieve the desired outcome. However, this collaboration requires that both groups understand the needs and capabilities that Business Intelligence solutions can provide.

The concepts in this course will be taught through a class-long mini-project where you will engage in the hands-on development of dashboards, scorecards and reports primarily using tools from the Microsoft suite.

Course Level Learning Outcomes (707):

  • Model a MAD framework presentation
  • Use industry best practices to develop visual dashboard layouts
  • Develop monitor level dashboards using SQL Server Mobile Report Publisher
  • Develop analysis level dashboards using Power BI Desktop
  • Develop detail level reporting using SQL Server Reporting Services

Scope of Responsibilities (high level)

  • Create effective lessons plans, develop content, learning activities, presentations, assignments, evaluations, examinations.
  • (If classroom): Utilize Desire2Learn for all course materials, assessment and, student communication.
  • (If online) Utilize Desire2Learn (D2L) and Adobe Connect to facilitate synchronous and asynchronous course delivery including all course materials, experiences and student communication.

Qualifications

  • Master’s degree or equivalent and work experience in the field are desirable.
  • Industry experience an asset.
  • Adult learning certificate or equivalent is an asset.
  • Previous teaching experience is essential; post-secondary teaching experience is preferred.
  • Previous experience utilizing Learning Management Systems such as Desire2Learn, Adobe Connect, Blackboard or Moodle, is preferred.

Application Deadline: July 13, 2018.

We would like to thank all applicants in advance for submitting their resumes.  Please note, only those candidates chosen to continue on through the selection process will be contacted.

The University of Calgary recognizes that a diverse staff/faculty benefits and enriches the work, learning and research experiences of the entire campus and greater community. We are committed to removing barriers that have been historically encountered by some people in our society. We strive to recruit individuals who will further enhance our diversity and will support their academic and professional success while they are here. All qualified candidates are encouraged to apply; however Canadians and permanent residents will be given priority. In this connection, at the time of your application, please answer the following question: Are you a Canadian citizen or a permanent resident of Canada? (Yes/No)

Additional Information

To view a listing of all available academic opportunities and to find out more about what the University of Calgary has to offer, please visit our Academic Careers website.

About the University of Calgary

The University of Calgary is Canada’s leading next-generation university – a living, growing and youthful institution that embraces change and opportunity with a can-do attitude. Located in the nation’s most enterprising city, the university is making tremendous progress on its Eyes High journey to be recognized as one of Canada’s top five research universities, grounded in innovative learning and teaching and fully integrated with the community it both serves and leads. The University of Calgary inspires and supports discovery, creativity and innovation across all disciplines. For more information, visit ucalgary.ca.

About Calgary, Alberta

Calgary is one of the world's cleanest cities and has been named one of the world's most livable cities for years. Calgary is a city of leaders - in business, community, philanthropy and volunteerism. Calgarians benefit from a growing number of world-class dining and cultural events and enjoy more days of sunshine per year than any other major Canadian city. Calgary is less than an hour's drive from the majestic Rocky Mountains and boasts the most extensive urban pathway and bikeway network in North America.  

 

Need help?

View our Application FAQs for answers to common questions regarding the application and selection process.