Data Engineering and Analytics with Co-op

Data Engineering and Analytics with Co-op

This program is designed for students looking to pursue a rewarding career in the field of Information Technology as a highly qualified Data Analyst.

Program Courses:

Information Systems Management 

• In this course, students will be introduced into the Information Technology Organizational Structure and become familiar with the different I.T. business units that make up an enterprise-level project and their respective roles. Students will gain an understanding of the effective collaboration and coordination of these different business units and roles in order to drive project objectives to the solution.
  
  
• This course will introduce students to different Software Development Lifecycle models and frameworks and how projects are organized and initiated within each model.
  
  
• This course will introduce the concept of business requirement interpretation and analysis and how they translate into a strategic objective for a project. Students will become familiar with issue tracking and reporting as well as become proficient in the Application Lifecycle Management (ALM) and Quality Center backtracking system software.

Introduction to Linux Administration 

• This course is an introduction to Linux and Unix System Administration. Students will be introduced to a variety of topics including the underlying system architecture, command-line interface administration, device and filesystem management, networking, common administration practices and bash shell scripting.

Relational Database Systems and SQL 

• In this course, students learn the tools and processes for data modelling in Relational Database Management Systems (RDBMS) and the Structured Query Language, SQL, to define and manipulate data.

Introduction to Data Structures, Design and Analysis

• This course will develop the foundation skills and knowledge required for the design, implementation and analysis of data structures.

Business Analysis and Systems Design

• In this course, students will learn the foundation of business analysis.

Probability and Statistics Fundamentals 

• In this course, students will learn the main concept and methodology of statistics and the main concepts of probability.

Statistics for Data Analysis 

• In this course, students will learn a programming language R that was created for statistical analysis. Will be able to apply multiple linear regression model and its components and approaches. ANOVA table. Correlations.

Applied Multivariate Statistical Analyst

• In this course, students will learn a programming language R that was created for statistical analysis. Will be able to apply multiple linear regression model and its components and approaches. ANOVA table. Correlations.

Machine Learning

• In this course, students will learn about artificial intelligence.

Data Warehouse (EDW) Concepts 

• In this course, students will learn about artificial intelligence. In this course, students will learn how to design warehouses and create data integration workflows from multiple sources.

Visual Analysis for Business Intelligence (BI) with Tableau

• In this course, students will learn about data visualization.

Business Intelligence (BI) with SSIS, SSAS, SSRS

• In this course, students will learn about SQL Server services.

Advanced Topics in Data Analysis: Big Data, Data Mining, Cloud Computing

• In this course, students will learn the main concepts of Big Data, Data Mining and Cloud Computing.

Security and Privacy Issues in Data Analytics

• In this course, students will learn about the security and privacy issues of big data.

Employment Preparation Training

• The purpose of this course is to prepare students for the employment upon completion of the program. This course will ready students through resume crafting, portfolio development, job search strategies, interview preparation and salary negotiations as well as career development training

Check the requirements below to prepare your application to CCTB

Students must be in possession of one of the English Language Equivalencies in the list below.

Language proficiency requirements are admission requirements and may not be waived by either the institution or the student.

Admission Requirements:

• Have a Secondary School Diploma or equivalent or be at least 19 years of age
• Good command of English language IELTS 5.5 or equivalent outlined below
• High school diploma or equivalent from an approved government institution of applicant’s home country, or applicant is minimum 19 years of age
• Students are required to have and use their own personal computer in class

The following are accepted:

• English Grade 12 (from a high school program in Canadian, US, UK, or other English-speaking country)
• Communications Grade 12 (from a high school program in Canadian, US, UK, or other English-speaking country)
• Successful completion of CCTB EAP (English for Academic Purposes) Level 4
• IB (International Baccalaureate) English A1/A2 (HL or SL)
• IELTS: (International English Language Testing System) Band 5.5 or higher
• TOEFL iBT: (Test of English as a Foreign Language) 55 or higher
• TOEFL Paper: (Test of English as a Foreign Language) 496 or higher
• CAEL: (Canadian Academic English Language Assessment) Score of 40 or higher
• PTE A: (Pearson Test of English) Score of 36 or higher
• CEFR: B2 or higher
• CLB: (Canadian Language Benchmarks) Level 6 or higher
• Cambridge: FCE (B2 First - grade C) or higher
• CELPIP: 7 or higher
• Aptis: B2 or higher
• EIKEN: Pre-1 or higher
• MET: B2 or higher
• GTEC: 1190 or higher
• TOEIC: (Test of English for International Communication) Score 310 or higher
• Duolingo: score of 95 or higher
• LanguageCert (LC IESOL): B2 Communicator (25-32) or higher
• GCAS Interview: Level 4 or higher
• Successful completion of a Designated ESL school program with level equivalent to tests outlined in section 1 above OR from an established pathway partner of CCTB
• Applicants may choose to complete the TLGC Online Pre-Arrival Test and receive customized language study plan based on the applicant’s test results if a passing grade is not achieved
• Applicants that are not in possession of one of the credentials above, are advised to enroll in The Language Gallery Canada (TLGC) UPP (University Pathway Program). Successful completion of TLGC UPP level 4.5 is recognized by CCTB in lieu of the aforementioned assessments

Data Engineering and Analytics with Co-op Career Opportunities

At CCTB, your success is our goal. We provide you with the highest quality training, preparing you for a rewarding career in an increasingly digitalized world. 

Our curriculum is designed and taught by seasoned professionals and is based on real-life industry needs in tools and methodology. Our database developer program is taught in a highly interactive environment, engaging you in a format most companies use to conduct their business.  

CCTB is committed to providing career orientation, guidance and complete employment support. Throughout your studies, you will learn self-marketing techniques and receive support in securing employment in your desired field. We strive to deliver an outstanding level of support as you enter or re-enter the workforce. 

Studying the Data Engineering and Analytics program will provide you with the skills that you can take into many different roles. Some roles you could consider after your finish the program include: 

NOC 2173

• Database Administrator: These people are responsible for building computer systems that can store data securely. They then monitor the performance and integrity of the system.  

• Data Analyst: Otherwise known as Data Modelers, these analysts are responsible for maintaining, organizing and interpreting data in different technology systems.  

• Data Conversion Analyst: A Data Conversion Analyst focuses on database management systems. The responsibilities of this role include determining the specifications needed to transfer data from one format to another, testing the conversion process to ensure that data is corruption-free, and providing resolutions to any errors or issues that may occur. 

• Data Migration Specialist: A Data Migration Specialist migrates data from an old application to a new one or to an entirely different platform. Data migration specialists plan, implement, and manage varying forms of data for organizations. 

• Data Architect: A Data Architect is responsible for visualizing and designing an organization's enterprise data management framework. Their duties also include creating database solutions, evaluating requirements, and preparing design reports. 

• Database Developer: Database Developers use computer software to organize and save data. Their key responsibilities include determining users' needs, ensuring the security of information, monitoring database performance, and providing support. 

• Technical Architect: This person supervises an organizations’ IT architecture while also helping to plan, design and build IT systems.  

The average Data Engineering and Analytics salary in Canada is $63,081 per year or $30.32 per hour. Entry-level positions start at $44,923 per year while most experienced workers make up to $91,213 per year. 

Intake Dates:

Jan, May, Sep

Program Fees:
*Click here for 2024 Tuition Fees

International Tuition: $19,450 CAD

Discounts: $1,500 CAD

Final International Tuition after Discounts: $17,950 CAD

Domestic Tuition:$19,450 CAD

Discounts: $2,500 CAD

Domestic Discount: $2,700 CAD

Final Domestic Tuition after Discounts: $14,250 CAD

Financial assistance may be available to eligible students under the StudentAid BC program. For more information please go directly to https://studentaidbc.ca/sabc-home-page

*Additional fees may apply. 

When applying to CCTB, please note that all applications must be submitted online using the Online Application in the link below:

REGISTER NOW

When applying to CCTB, please note that all applications must be submitted online using the Online Application in the link below:

REGISTER NOW

Work Experience Policy

This policy applies to all students who are enrolled in CCTB programs that offer a work experience component (e.g., practicum or co-op).

The work experience is a required part of Data Engineering and Analytics with Co-op (DEAC) in which the student obtains practical skills relevant to the learning objectives of the program.

 Policy Statement

1. Work Experience Requirements

The requirements for participation in the work experience are as follows:

• Be in Good Academic Standing, such that the student has satisfactorily passed all academic courses in the program and has met the minimum passing grade for each course, as per the CCTB Academic Standing, Promotion, and Graduation Policy;
• Be in Good Financial Standing, such that the student has no outstanding tuition fees as per the CCTB Late Payment Policy;
• Submit the Work-Term Agreement to the Career Services Manager one week before the intended start date of Work Experience
  • Missing the deadline to submit the Work-Term Agreement to the Career Services Manager may result in delays in work placement
• Be eligible to work in Canada with the appropriate Canadian residence permit; and
• Submit an up-to-date resume

2. Placement Process

The process by which the student will be placed in a work experience is as follows:

• Eight (8) weeks before Work Experience: An initial orientation session will be conducted by the Career Services Manager to students;
• The Career Services Coordinator (or designate) will set up an initial meeting with the student to conduct career counselling and to collect the student’s updated resume;
• The Career Services Manager will send a list of potential employers to students;
• The Career Services Manager will assist in setting up interviews between the student and employers;
• A Work-Term Agreement will be signed by both the student and the supervisor and collected by the Career Services Coordinator (or designate) one week before the intended Work Experience start date;
• Students who do not satisfy the requirements to enter the Work Experience component will be required to postpone the Work Experience start date to the next available cohort of the same program.

The Canadian College of Technology and Business, the student, and the host organization will enter into a written agreement (the Work-Term Agreement) detailing each party’s responsibilities and the activities the student will undertake during the work experience.  A copy of the Work-Term Agreement will be provided to the student before the start date of the work experience.

3. Evaluation Process

The process by which the student will be evaluated in relation to the work experience component is as follows:

• The student will be provided with at least one written evaluation in relation to the work experience component.
• The Work Experience supervisor/employer will fill out a comprehensive Work Experience Evaluation form upon completion of the work experience hours.
• The CCTB Academic Standing, Promotion, and Graduation Policy and CCTB Student Attendance Policy apply in evaluating the student’s Work Experience performance.
• Students who consistently refuse to comply with the deadlines stipulated to submit work placement documents will be given two formal written warnings. If a student refuses to comply after the final warning, they are considered to have abandoned their work placement and will need to retake the work placement component of their program with a retake fee.

4. Monitoring Process

The Canadian College of Technology and Business will monitor the student during the work experience by reviewing:

• The Canadian College of Technology and Business will monitor students’ performance during the work experience by reviewing attendance as well as the quality of work assignments delivered through the Bi-Weekly Attendance Report.
• Each bi-weekly reporting period consists of evaluating:
  • whether the student is attending the work experience;
  • whether the student is meeting the learning objectives of Data Engineering and Analytics with Co-op, and
• The Canadian College of Technology and Business will monitor the overall performance of the student through a Pass/Fail designation in the Work Experience Evaluation Report.