Data Analyst

Competency-Based Apprenticeship
Sponsoring Company:
The Center for Economic Growth
Industries
O*Net Code
15-2031.00
Rapids Code
Req. Hours
0
State
NY
Created
Apr 29, 2021
Updated
Apr 29, 2021

Competency-Based Skills

4 skill sets | 19 total skills
Workplace Orientation
Learn and follow employer-specific administrative policies, procedures, safety protocols.
Demonstrate familiarity with data science nomenclature and explain Data Analyst’s operational role.
Articulate and practice employer-specific “work culture” models (if applicable).
Complete tutorials (e.g., DataCamp, codecademy, Lynda.com) to attain basic knowledge and skills in common data science software and techniques (e.g., SQL, R, Python, Java, visualization, statistics).
Project Intake and Project Management
Demonstrate understanding of work intake process.
Acquire project management knowledge: e.g., SixSigma, or applicable internal program.
Analyze prospective projects: “Understand the ask up front.”
Communicate with coworkers, clients, users, and management throughout process.
Determine documentation needs at process inception.
Perform cost benefit analysis.
Develop process map.
Manage workflow with the aid of project management platforms, such as: SharePoint, Huddle, Confluence, Workfront.
Data/Extract, Transform, and Load (ETL)
Learn various data and statistical analysis concepts, such as: population, sample, data sets, variables, types of data, i.e. numerical, categorical.
Collect (extract) data from multiple sources, and ready for submission to workflow.
Utilize data manipulation tools, such as Structured Query Language (SQL), Alteryx, and Pentaho to transform data into operable format: address and resolve naming conflicts, duplicate records, and different value representations.
Load data into appropriate tables, where further manipulation may take Place, or final product displayed.
Data Visualization
Conceptualize data presentation formats for various audiences (clients, customers, internal/external, etc.).
Use data visualization software (such as Tableau, Cognos, Qlikview) to capture and re-present data.
Develop ability to manipulate and present data in complicated ways.

Technical Instruction

Safety and the Workplace
Sexual Harassment Prevention Training
# | 48 hrs
Employer Onboarding (if applicable)
# | 48 hrs
Trade Science and Theory
Data Science
# | 48 hrs
Data Analytics
# | 48 hrs
Database Concepts
# | 48 hrs
Project Management
# | 48 hrs
Logic
# | 48 hrs
Probability
# | 48 hrs
Statistics and Statistical Methods for Data Science
# | 48 hrs
Modeling
# | 48 hrs
Data Mining
# | 48 hrs