Logo
Stanford
International College
of Business & Technology
Let Stanford be your pathway to a new career!
Home Programs Admissions Services About Us History Contact Us

Business Intelligence Developer/Analyst

Thinkstockphotos 518177475
Schedule Full time
Category Technology
Accreditation Diploma
Articulations
Duration 52 Weeks

Campuses Offered

Scarborough 416-383-1608

In today’s business world companies require information on which to base their business decisions.  The Business Intelligence Developer/Analyst provides this information by collecting data from multiple sources to develop reports used to analyse information. The program provides full coverage of Microsoft Business Intelligence Technology Stack and engineering fundamentals including SDLC, Project implementation Methodologies such as Waterfall,Incremental/Agile methodologies, and programming languages, C#/Java with OOA/OOP design patterns and principles as well as an understanding of others database solutions including Oracle Database and related ETL tools.
Upon completion of the program the student will be able to develop Business Intelligence presentations such as reporting, business KPI, Dashboard and Visualization with Microsoft BI technical stacks; install and manage Microsoft SQL Server; implement Data Modelling for Databases; design and model  OLTP and OLAP Data Process Model; develop complex SQL Query and Stored Procedure based on Microsoft SQL Server; process non-structure data with Hadoop and HDFS technology; debug and troubleshoot system problems and issues and resolve issues and write technical proposals, technical requirements and solution designs.

Program Overview
    • Computer & Networking Fundamentals
    • Introduction to Linux
    • C# & .Net Fundamentals
    • Java Programming
    • Software Engineering Principles
    • Software Testing and Quality Assurance
    • SQL Server & Development
    • Business Intelligence Development with SQL Server
    • Big Data Foundation and Programming
    • Employment Search
  • An Ontario Secondary School Diploma or equivalent, OR
  • Students are 18 years of age or older and pass the program entrance examination.
Please see Admissions for detailed information.

The Business Intelligence Developer is responsible for aggregating data from multiple sources in an efficient data warehouse and for designing enterprise-level solutions for very large multidimensional databases. *Database analysts design, develop and administer data management solutions using database management software. Data administrators develop and implement data administration policy, standards and models.

*Employment opportunities may be found in information technology consulting firms and in information technology units throughout the private and public sectors. Graduates of the program may apply for may apply for positions as a:

Possible Careers NOC: 2172

  • Database Administrator
  • Business Analyst
  • Business Intelligence Developer
  • Database Analyst
  • Business Report  Developer
  • ETL Specialist 
  • Database Report Developer 
  • SQL Developer 
  • Microsoft BI Architect 




Request Information

Please fill in this form to learn more

Your Name*: Your Email*: Phone (10 digit number): Select Campus of Interest
What can we help you with?

Logo
© Copyright 2015
Stanford International College
of Business and Technology