IT - Data Analyst Apprenticeship
The primary role of a Data Analyst is to collect and organize data to provide business insight. Data analysts are typically involved with selecting, integrating, querying, and aggregating data, and conducting a range of analytical studies on that data. They work across a variety of projects, providing technical data solutions to a range of stakeholders/customers issues. They document and report the results of data analysis activities to improve business performance. They have a good understanding of data structures, database systems, and data processing and manipulation skills using analytical tools to undertake a range of different types of analyses.
First Term (144 Hours)
INTRODUCTORY SQL 72 Hours
The introductory SQL course prepares apprentices to leverage a relational database management system to retrieve data. They will create and execute queries using SQL statements. They will read an Entity-Relationship Diagram to direct the creation of the correct query.
INTERMEDIATE SQL 72 Hours
The Intermediate SQL course reviews the construction of a SQL query joining multiple tables using both INNER and OUTER joins, subqueries, scalar functions and aggregate functions. Apprentices add, modify and remove data records using DML statements; identify and create appropriate indexes to improve system query performance; and analyze the results for accuracy and completeness as well as review query performance. Prerequisite: 50-156-701 INTRODUCTORY SQL.
Second Term (108 Hours)
DATA PRESENTATION 108 Hours
Introduces data report creation. Apprentices learn data presentation formats and types of reports. Focus is placed on the creation of a variety of reports utilizing industry standard reporting tools. Data findings will be presented verbally and in writing, including through executive summaries. Prerequisite: 50-156-701 INTRODUCTORY SQL.
Third Term (54 Hours)
INTRODUCTORY BUSINESS ANALYST 54 Hours
Prepares apprentices to work as liaisons among stakeholders and understand the structure, policies, and operation of an organization. Apprentices use techniques to gather and analyze business requirements using best practices and relevant technologies. Prepares apprentices to function as liaisons with IT and subject matter experts supporting the needs of businesses in a wide variety of industries.
Fourth Term (54 Hours)
INTRODUCTORY ETL 54 Hours
Prepares apprentices to extract from unstructured and structured data stores, transform data for usability and readability and load data for consumption. Apprentices use applicable technology and techniques to provide reliable and accurate data for the end user or application. Prerequisite: 50-156-702 INTERMEDIATE SQL.
You must be employed by a company/organization that is willing to participate in an apprenticeship program. Each employer has their own requirements
for entry into the apprenticeship program. Contact your employer’s human resources department to see what is available.
If you have questions about this apprenticeship or the application process, please contact Katie Metko.