Data Management Analyst I

University of Florida•Gainesville, FL

3d•Onsite

About The Position

The candidate will work with an analytics team to help manage research related data and reporting systems from multiple research metadata providers that include information using a variety of database and statistical software tools (e.g., SQL, R). The candidate will assist in the design, development, testing and documentation of data file systems to ensure reproducibility and continuity of service. The candidate will contribute to software code (e..g, C#, Python) to aid in the extraction, transformation, and loading of data between systems. The candidate will help conduct data analyses, write statistical programming code for software such as R, Python Pandas, or SPSS, and participate in the interpretation of results to be presented to management. The candidate will work under department guidelines for analysis to develop manuals and procedures to conduct analysis of various data systems. The candidate will provide data summaries and reporting using various software tools including Figma, Adobe XD, Sketch, and SQL. The candidate will utilize data visualization tools such as PowerBI or Tableau to generate output for reporting of research metadata. The candidate will work with team members to create presentations in PowerPoint, web portals, dashboards, or similar visualization system. The candidate will perform other duties as assigned.

Requirements

Bachelor’s degree in an appropriate area.
Experience using statistical and database software such as R, SQL, SAS, and/or SPSS.
Experience with Microsoft Excel and PowerPoint.
Programming experience.
Ability to construct and analyze queries.
Ability to merge datasets.
Maintains knowledge of structure and location of various available data sources to assist in the creation of metrics and Key Performance Indicators (KPIs).
Ability to perform analysis of disparate datasets and generate reports to UF Research leadership and relevant customers for various projects in research.

Nice To Haves

Bachelor's or Master's degree in Data Science, Computer Science, Information Technology, Economics, Statistics, Information Systems, Applied Math, Business Administration, Journalism, or Educational Technology.
Advanced Microsoft Excel experience such as pivot tables and charting.
Knowledge of data visualization and framework tools such as PowerBI, Redash, Tableau, Cognos Analytics, Adobe XD, Visio, and Figma.

Responsibilities

Manage research related data and reporting systems from multiple research metadata providers.
Assist in the design, development, testing and documentation of data file systems.
Contribute to software code (e.g., C#, Python) for data extraction, transformation, and loading.
Conduct data analyses and write statistical programming code (R, Python Pandas, SPSS).
Participate in the interpretation of results for management presentation.
Develop manuals and procedures for data analysis under department guidelines.
Provide data summaries and reporting using tools like Figma, Adobe XD, Sketch, and SQL.
Utilize data visualization tools (PowerBI, Tableau) for research metadata reporting.
Create presentations in PowerPoint, web portals, dashboards, or similar visualization systems.
Perform other duties as assigned.