Data Analyst -20041948

Data Analyst

Position Number: 20041948

Vacancy ID:  NF0006057

Department: Information Technology-SOM-420401Information Technology-SOM - 420401

Classification/Appointment Type:  EHRA Non-Faculty

Full Time Equivalent (FTE):  1

Full Time/Part Time Permanent/Time Limited: 

If time-limited, estimated duration of appointment:  

Hours Per Week:  40

Work Schedule:  

Job Code ID:  IT Busn Intel & Data Analyst-2

Salary Shown to Applicants (Hiring Range):  $74,500 - $90,000

Salary Grade Equivalency:  

FLSA Designation:  Exempt

Duties Exempt:  Yes

Work Location:  

Department Description:  

The School of Medicine Information Technology (IT) Office provides centralized computer support and information system support for the School of Medicine community, from medical students to faculty to administrative staff. Services include central help desk and desktop support; administrative and clinical application support; novel application development and database hosting; research IT and data science initiatives; infrastructure services including physical, virtual, and cloud provisioning; physical networking installation and management; and web development. Additional services include managing the School of Medicine official web presence; classroom video recording and streaming systems; video production and editing; video conferencing; and digital signage.

Equal Opportunity Employer:  

The University of North Carolina at Chapel Hill is an equal opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regard to age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex, sexual orientation, or status as a protected veteran.

Position Discription:  

Flexible work arrangements, including remote/hybrid work locations, are an integral part of the School of Medicine’s Working Forward initiative. As such, this position’s work location is designated as remote. Please note that the designated work location is subject to change based on the unit’s business needs.

The primary purpose of this Data Analyst position is to support School of Medicine IT needs for data analytics, business intelligence, and related metrics to inform decision-making, planning, and continuous improvement across the School of Medicine. The incumbent:

- Perform Data Analysis to assess quality and meaning of data
- To work with data and help the organization make better business decisions.
- Creates sustainable data models using SQL and database tools.
- Develops and implements web-based interactive reporting applications using dashboard tools (e.g., Tableau, Microsoft Power BI etc.) to communicate quantitative and visually displayed information to internal UNC Chapel Hill and public constituents.
- Provides intermediate analytic programming support (e.g., R, Python, or SAS).
- Supports information requests from inception to delivery, translating client requirements into appropriate reporting objects that tell a story with data including, but not limited to analytic scorecards, dashboards, and reports.
- Develops and implements user-interactive reporting objects including filters, tool tips, and statistically based what if scenarios.
- Supports the institution’s internal and public-facing, strategic and operational reporting needs.
- Integrates information from a variety of campus operational and data warehouse systems and synthesizes it to create self-service resources that enable users to explore the data and answer questions independently.
- Builds strong consultative relationships, establishing value for the unit as a key partner for producing high-quality, actionable information that meets the needs of decision-makers at all levels of the University.
- Contributes to or develops business intelligence and data modelling standards and guidelines.
- Works with Data Manager to build out Department’s data analysis services strategy and perform those services
- Has background in data analysis in areas such as statistics, analytics, metrics, and other forms of analysis and presentation
- Provides consultancy to customers on data analysis requests, assist with data acquisition for research and other analysis, and inform continual improvement to data acquisition and collection processes to ensure data is available for analysis when needed
- Provides support in the design and launch of analysis services in coordination with the launch of our new Enterprise Data Warehouse.
- Reports to the Data Manager

Essential Skills, Knowledge and Abilities:  

- Must have strong written and verbal communication and interpersonal skills as well as analytical technical ability (relationship-building/problem-solving/research skills, etc.). Proven analytical skills
- Self-motivated, eager to contribute and learn, and brings a strong sense of initiative; has an exceptional work ethic and is energized by team success.
- In-depth understanding of database structure principles
- In-depth knowledge of Data Analysis using SQL and SQL tools
- Experience gathering and analyzing system requirements

Education Requirements:  

Master’s and 1-2 years’ experience; or Bachelors and 2-4 years’ experience; or will accept a combination of related education and experience in substitution.

Preferred Qualifications:  

Required Licenses/Certifications:  

Qualifications and Experience:  

- Master’s Degree in Computer Science, Computer Information Systems, Computer Engineering, math, or Engineering or related technical degree from an appropriately accredited institution
- Few Years of Programming/development experience preferred.
- Few Years of Data Analysis experience
- Experience using complex SQL queries to extract data from databases.
- Experience building web-based, interactive dashboards, analytics, scorecards, dynamic reports, and other business intelligence objects using commercial data visualization tools (e.g., Tableau, R, Microsoft Power BI , R or SAS Visual Analytics.).

Special Physical and Mental Requirements:  

Quick Link for Direct Access to Posting:  https://unc.peopleadmin.com/postings/233869

Department Contact Name and Title:  Matthew Tucci HR Consultant

Department Contact Telephone or Email:  matthew_tucci@med.unc.edu

Posting Open Date:  06/22/2022

Posting Close Date:  07/29/2022

Open Until Filled:  No

Office of Human Resources Contact Information:  If you experience any problems accessing the system or have questions about the application process, please contact the Office of Human Resources at (919) 843-2300 or send an email to employment@unc.edu
Please note: The Office of Human Resources will not be able to provide specific updates regarding position or application status.