*Data Analyst
Sooner Launch Pad Accelerator
Job Number:
252138Organization
: Aerospace & Mechanical Engin.Job Location
: Oklahoma-Norman-Norman CampusSchedule
: Part-timeJob Description
--- This position will receive information and work on given data and develop applications that will automate tasks and calculations. A successful applicant will have data analytics skills along with knowledge of VBA.
Essential Duties:
- Responsible for managing master data sets, developing reporting tools, and troubleshooting data issues.
- Manages and interprets master data, including creation, updates, and deletion. Uses statistical tools, paying particular attention to trends and patterns that could be valuable for diagnostic and predictive analytics efforts.
- Mines data from primary and secondary sources, reorganizing said data in various formats.
- Manages users and user roles.
- Provides quality assurance of imported data.
- May work with a quality assurance analyst.
- Commissions and decommissions data sets.
- Processes confidential data and information according to guidelines.
- Manages and designs the reporting environment, including data sources, security, and metadata.
- Supports the data warehouse in identifying and revising reporting requirements.
- Supports initiatives for data integrity and normalization.
- Assesses tests and implements new or upgraded software.
- Assists with strategic decisions on new systems.
- Generates reports from single or multiple systems, training end users on new reports and dashboards.
- Troubleshoots the reporting database environment and reports.
- Evaluates changes and updates to source production systems.
- Provides technical expertise on data storage structures, data mining, and data cleansing. Identifies opportunities for process improvements.
- Creates appropriate documentation of the data analysis process.
- Performs various duties as needed to successfully fulfill the function of the position.
Job Requirements
--- Required Education: Bachelor's degree, AND:
- 24 months experience in computing programming and analysis or in related field.
Equivalency Substitution: Will accept 48 months related experience in lieu of the Bachelor's degree for a total of 72 months experience.
Skills:
- Ability to analyze existing tools and databases and provide software solution recommendations
- Ability to translate business requirements into non-technical, lay terms
- High-level experience in methodologies and processes for managing large scale databases
- Demonstrated experience in handling large data sets and relational databases
- Knowledge of addressing and metadata standards
- Ability to communication verbally and in writing
- Detail oriented for accuracy of data and information
- Able to produce reports and complete work within deadlines
- Able to work well with interdepartmental teams and initiatives
Certifications:
- None
Advertised Physical Requirements:
- Physical: Must be able to engage in repetitive motions. Manual dexterity. Ability to sit for short or extended periods of time.
- Environment: Standard office work environment.
Departmental Preferences:
- Strong structured programming
- Extensive experience w/VBA
Supervision: None
Special Instructions: If you are selected as a final candidate for this position, you will be subject to The University of Oklahoma Norman Campus Tuberculosis Testing policy. To view the policy, visit https://hr.ou.edu/Policies-Handbooks/TB-Testing.
Why You Belong at the University of Oklahoma: The University of Oklahoma values our community's unique talents, perspectives, and experiences. At OU, we aspire to harness our innovation, creativity, and collaboration for the advancement of people everywhere. You Belong Here!
Equal Employment Opportunity Statement: The University, in compliance with all applicable federal and state laws and regulations, does not discriminate on the basis of race, color, national origin, sex, sexual orientation, marital status, genetic information, gender identity/expression (consistent with applicable law), age (40 or older), religion, disability, political beliefs, or status as a veteran in any of its policies, practices, or procedures. This includes but is not limited to admissions, employment, housing, financial aid, and educational services.