Graduate Assistant, Data Management and Analysis

Description

The Graduate Assistant, Data Management and Analysis will be responsible for developing SQL Queries and conveying their results in a useful format, which is usually either a CSV File or a Tableau Report. This person will work closely with the Information Services team to retrieve information from multiple sources; and resolve data problems regarding file failure, data quality and information timing. This person will also assist staff with troubleshooting and resolving desktop support issues. This person will also collect data from multiple; makes decisions on how to complete tasks and solve problems; and will organize, plan, and prioritizes work involving multiple tasks.

Major Work Behaviors/Tasks:

The list below contains major tasks this position is responsible for:

Data Analysis:                       75%

• Analyze data and develop queries to provide data lists for OSUAA and our partner entities
• Analyze and solve problems related to constituent data
• Analyze and resolve issues with current and planned systems as they relate to the integration and management of constituent data
• Communicate effectively with both technical and non-technical colleagues
• Use deductive and inductive reasoning to solve problems and analyze systems
• Verify backups of data are regularly performed
• In collaboration with others, build reports and interpret data and develop recommendations based on findings
• Evaluate current systems to improve operations and integrity of data
• Develop reports and data integrity audits as necessary
• Consult with staff on coding problems and assist in developing means to correct the problems
• Present complex information in an understandable and compelling manner
• In collaboration with others, develop and implement data collection systems and other strategies that optimize efficiency and data quality
• Perform data entry, either manually or using scanning technology, when needed or required
• Implement data mining techniques and procedures, knowing when their use is appropriate

Administrative:                     25%

• Perform general IT tasks as needed to support staff members
• Interface with network support personnel when needed to provide for staff needs
• Understand and that ensure confidentiality law and organization/industry standards are satisfied
• Serve as an internal resource for staff training and troubleshooting on the Customer Relations Management (CRM) system.

Equipment Used:

• Multi line telephone
• Desktop computer
• Laptop computer
• Printer/Copier
• iPad

Software and Services Used:

• Microsoft Outlook
• Microsoft Office Suite
• Microsoft Teams
• Snowflake Data Warehouse
• Ascend Salesforce CRM
• Visual Studio Code IDE
• Asset Tiger

Qualifications

Knowledge

1. Experience with Structured Query Language (SQL)
2. Experience with a Programming Language (Python, C, COBOL, etc)
3. Familiarity with physical computer hardware (CPUs, GPUs, RAM, etc.), computer software, and how they operate together.
4. Familiarity with drafting technical documentation for software, including system diagrams.
5. Understanding of Data Mining, Problem Solving, and Troubleshooting processes and principles.
6. Understanding of arithmetic, algebra, geometry, statistics, and their applications.
7. Exposure to Snowflake Data Warehouse, Salesforce CRM, and Tableau

Skills

1. Understanding the implications of new information for both current and future problem-solving and decision-making.
2. Active Listening Skills. Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.
3. Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
4. Adjusting actions in relation to others' actions.
5. Performing Cost-Benefit Analysis.
   1. Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
   2. Considering the relative costs and benefits of potential actions to choose the most appropriate one.
6. Analyzing needs and product requirements to create a design.
7. Accepting feedback on an implemented design to refine the requirements and improve through further iterations.
8. Writing computer programs for various purposes.
9. Understanding written sentences and paragraphs in work related documents.
10. Determining how a system should work and how changes in conditions, operations, and the environment should affect outcomes.
11. Troubleshooting skills to assess why a system isn’t behaving as expected/desired.
12. Managing one's own time and deadlines.

Abilities

1. Ability to apply general rules to specific problems to produce explainable answers.
2. Ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
3. Ability to recursively decompose complex problems into their simpler elements until you have a set of simpler problems can be resolved, and then integrate those solutions into an effective whole.
4. Ability to choose the right mathematical methods or formulas to solve a problem.
5. Ability to see details at close range, within a few feet.
6. Ability to listen to and understand information and ideas presented through spoken words and sentences by technical and non-technical colleagues.
7. Ability to communicate information and ideas to technical and non-technical colleagues.
8. Ability to tell when something is wrong or is likely to go wrong. It does not involve solving the problem, only recognizing there is a problem and raising the concern.
9. Ability to read and understand information and ideas presented in writing.
10. Ability to communicate information and ideas in writing as is appropriate to the audience.
11. Ability to lift light objects (Desktops, Monitors, etc.).
12. Ability to learn and apply Legal, Industry, and Organizational standards/requirements in regard to privacy and security.

Salary : $12 - $14