Data Analyst

Anonymous

Colorado (OA)

Documents

Individual state requirements may vary. Please contact your local apprenticeship office to ensure this version is suitable to your state’s requirements.

Work Process Schedule

Work Process Content

On the Job Training

Anonymous

Skills

Core Competencies

Acquires, organizes, and interprets data from various data sources. Navigates system to access data on a basic level. Identifies best practices & concepts regarding how to organize data based on the data analysis request. Begins to generate questions & observations about query results. Demonstrates an ability to apply and comprehend basic queries or formulas in a program (such as Excel). Understands the concepts related to familiarizing with a data set, cleaning a data set, and analyzing relationships between variables. Identifies a variety of possible issues in a data set independently. For example, redundant variables or outliers. Develops simple formulas/queries to gather necessary data outputs, with support from supervisor. Organizes data for analysis, based on best practices for the data analysis business request, with support from supervisor. Analyzes data output/query results by performing basic calculations and begins development of the narrative, with support from supervisor. With support from supervisor, accesses data set and completes basic summarization and descriptive tasks. With support from supervisor, identifies and addresses issues in a data set (e.g. null value treatment or data type conversions). Develops simple formulas/queries to gather necessary data outputs. Organizes data for analysis, based on best practice for the data analysis business request. Analyzes data output/query results to begin development of the narrative. Independently accesses data set from and completes summarization and descriptive tasks. Identifies and addresses a variety of possible issues in a data set independently. For example, redundant variables or outliers. Develops complex formulas/queries with support from supervisor. Anticipates how data will need to be organized and what information will need to be displayed, based on the data analysis business request. Generates insights related to the business request, based on data output/query results.
Uses programming language (such as SQL) or Microsoft Excel program to produce data output. Understands the basic purpose and functions for accessing data. Uses a tool, such as SQL or Microsoft Excel, that helps generate the data outputs. Writes basic Microsoft Excel or SQL (or other relevant language), commands, with support from supervisor. Writes basic Microsoft Excel or SQL (or other relevant language) commands. Independently writes basic SQL (or other relevant language) statements without having to rely on a tool that generates SQL. Knows how to use different languages and tools (such as Stata, SASS, SPSS) to create outputs for certain data sets.
Translates data into basic visualizations to support in business analytics and problem solving. (Data Visualization tools may include Tableau, Power BI, Salesforce, Looker.) Understands basic visualization functions (ex. drag & drop, tables) inside a graphic user interface (such as Tableau). Explores basic visualization options to support the narrative about the data. Reviews and provides feedback of visualization tools created by team members and demonstrates an ability to apply basic principles of layout & design. Creates new visualization reports or customer self-service tools for stakeholders, with support from supervisor. Identifies best visualization to support the narrative about the data, with support from supervisor. Creates basic visualizations that implement best practices of layout & design, with support from supervisor. Preemptively determines the visualizations needed by stakeholders and proactively creates those visualizations or self-service tools. Identifies best visualization to support the narrative about the data. Creates basic visualizations that consistently implement best practices of layout & design. Creates and uses visualizations to generate new insights or hypotheses, beyond what the stakeholder requested, that drive towards current business goals or create new value propositions. Communicates how data was gathered, filtered, and displayed in the visualization. Acts as a resource for implementing best practices of layout and design.
Respond to customer requests for support (such as answering a business or technical question, or generating reports). Familiar with common questions or the types of support customers need. Generates a bank of solutions and processes for commonly asked questions or requests. Responds to customers’ low-level questions or requests for support, such as delivering a packaged analysis, with support from the supervisor. Independently responds to customers’ questions or requests for support and seeks solutions, such as creating a data visualization tool or completing new data analysis, as needed. Follows up with general respondents to clarify certain questions in the data, such as from survey results. Provides responses and/or solutions quickly and independently to customers; well-versed in customer needs. Follows up with general respondents to clarify certain questions in the data, such as from survey results, and is able to offer an explanation as to why some survey results might be different.
In a technical setting, performs problem resolution and root cause analysis and recommends and implements solutions. Identifies challenges with data and proactively reaches out for support for the specific challenge. Recognizes patterns of the challenges encountered in the data analysis process. Identifies people and resources that can help with problem resolution and can clearly communicate the challenge. Discovers basic solutions to common challenges in the data analysis process. Recognizes patterns of challenges in the data analysis process and applies learned solutions to overcome the obstacle. Acts as a resource who is called on to support others when resolving problems.
Identifies key business challenges and performs preliminary data collection and root cause analysis to recommend and implement solutions. Generates research questions that initiate the problem solving process. Develops strong inquiry skills regarding which questions to ask, who to ask, and what resources are available, with support from their supervisor. Develops simple solutions to implement and resolve problems, using information gathered in inquiry. Develops complex solutions to implement and resolve complex problems, using information gathered in inquiry.
Tells and adapts a story from the results of a model through a clear, concise explanation in a verbal or written method, that is uniquely framed to the intended audience. Elaborates on basic insights to the team in easy to read explanations. Produces a one pager that summarizes insights and results and justifies recommendations, with support from supervisor. Engages with teammates about the results and can answer questions about the results. Produces a short memo that elaborates on the insights and the results they got from a certain output and that explains their rationale for their insights. Utilizes simple data visualization tools, such as tables or graphs, within memo. Produces a research brief with clear and detailed results, insights, and recommendations, and which explains how they got the results and how the results were affected by the certain variables. Utilizes complex data visualization tools within memo.
Uses understanding of the organization’s priorities, financial model, and operations to guide daily work. Describes the general purpose and goals of the business. Discusses the crucial metrics being measured. Displays detailed understanding of the particular customer. Understands how data supports the organization in making decisions and achieving its goals. Generates data reports that support the organization in achieving their business goals, as requested by the supervisor. Anticipates what data or reports would support the organization with decision -making around priorities and goals; efficiently provides the information needed. Intuits a customer’s needs and develops an end result that is novel to what the customer requested that may more effectively support educating the customer for decision making.

Entrepreneurial Skills

Recognize that problems can be identified, and possible solutions can be generated Define the problem using a variety of strategies Make connections between information gathered and personal experiences to apply and/or test solutions
Demonstrate curiosity, imagination and eagerness to learn more Build on personal experience to specify a challenging problem to investigate Engage in novel approaches, moves, directions, ideas and/or perspectives
Recognize and describe cause-and-effect relationships and patterns in everyday experiences Investigate to form hypotheses, make observations and draw conclusions Test hypotheses/prototype with planned process for getting feedback
Demonstrate a willingness to try new things Demonstrate flexibility, imagination and inventiveness in taking on tasks and activities Innovate from failure, connect learning across domains and recognize new opportunities

Personal Skills

Accurately recognize one’s own emotions, thoughts and values and how they influence behavior Appropriately express one’s own emotions, thoughts and values and identify how they influence behavior Assess personal strengths and limitations, with a well-grounded sense of confidence, optimism and a ‘growth mindset’
Recognize personal characteristics, preferences, thoughts and strengths Pursue opportunities to engage and learn interests Apply knowledge to set goals, make informed decisions and transfer to new contexts
Recognize emotional response to ideas that differ from one’s own Regulate reactions to differing perspectives Look for and value in different perspectives expressed by others
Resist distractions, maintain attention, and continue the task at hand through frustration or challenges Set goals and develop strategies to remain focused on learning goals Focus on learning goals by employing motivation and familiar strategies for engagement and evaluate progress, making necessary changes to stay the course

Civic/Interpersonal Skills

Recognize how personal actions have had a positive or negative impact on others with feedback as needed Recognize how members of a community rely on each other, considering personal contributions as applicable Follow a process identified by others to help generate ideas, negotiate roles and responsibilities, and respects consensus in decision making
Articulate personal strengths and challenges using different forms of communication to express oneself Consider purpose, formality of context and audience, and distinct cultural norms when planning content, mode, delivery and expression Establish goals for communication and plan out steps accordingly
Compare attitudes and beliefs as an individual to others Identify and explain multiple perspectives (cultural, global) when exploring events, ideas and issues Plan and evaluate complex solutions to global challenges that are appropriate to their contexts using multiple disciplinary perspectives (such as cultural, historical and scientific)
Takes great care with organizational data Does not disclose any kind of personal or sensitive organizational information; understands that all data is confidential Demonstrates honesty and integrity in all interactions. If an error is made, prioritizes minimal impact to the organization over their own reputation

Professional Skills

Articulate task requirements and identify deadlines Develop and utilize basic task and time-management strategies effectively Demonstrate task-management attributes associated with producing high-quality products including the abilities to: 1) Work positively and ethically 2) Manage time and projects effectively 3) Multi-task 4) Clearly communicate with others
Appropriately express a range of emotions to communicate personal ideas/needs Ask questions to develop further personal understanding Demonstrate confidence in sharing ideas/feelings
Complete tasks with ongoing support Seek clarity on tasks and needs occasional support Demonstrate skill in assigned tasks and completes with little or no support

Academic Skills

Begins to use math and literacy skills to inform work Uses math and literacy skills to perform job tasks with frequent checks by supervisor Independently and consistently use math and literacy skills to perform tasks (with occasional checks for quality)

Related Instruction Outline

Data Analyst

Work Process Content

Related Instruction Content

Similar Programs