Data and Business Intelligence Analyst Job at University of North Carolina in Wi

Posting Information Posting Information Department Inst Research and Assessment-505000 Career Area Research Professionals Posting Open Date 11/13/2024 Application Deadline 12/02/2024 Open Until Filled No Position Type Permanent Staff (EHRA NF) Working Title Data and Business Intelligence Analyst Appointment Type EHRA Non-Faculty Position Number 20067852 & 20067853 Vacancy ID NF0008662 Full Time/Part Time Full-Time Permanent FTE 1 Hours per week 40 Position Location North Carolina, US Hiring Range Proposed Start Date 01/06/2025 Position Information Be a Tar Heel A global higher education leader in innovative teaching, research and public service, the University of North Carolina at Chapel Hill consistently ranks as one of the nation's top public universities . Known for its beautiful campus, world-class medical care, commitment to the arts and top athletic programs, Carolina is an ideal place to teach, work and learn. One of the best college towns and best places to live in the United States, Chapel Hill has diverse social, cultural, recreation and professional opportunities that span the campus and community. University employees can choose from a wide range of professional training opportunities for career growth, skill development and lifelong learning and enjoy exclusive perks for numerous retail, restaurant and performing arts discounts, savings on local child care centers and special rates on select campus events. UNC-Chapel Hill offers full-time employees a comprehensive benefits package , paid leave, and a variety of health, life and retirement plans and additional programs that support a healthy work/life balance. Primary Purpose of Organizational Unit The mission of the Office of Institutional Research and Assessment is to support the University of North Carolina at Chapel Hill's teaching, research, and public service mission by conducting research and analysis that informs institutional planning, policy formation, decision-making, and evaluation of effectiveness, and by responding to external accountability mandates and a wide range of internal and external requests for information about the campus. Position Summary This position may be eligible for a hybrid work arrangement that may include a partially remote work location, consistent with System Office policy. UNC Chapel Hill employees are generally required to reside within a reasonable commuting distance of their assigned duty station. The primary purpose of this position is to support University needs for statistical analysis, data analytics, and business intelligence to inform decision-making, planning, and continuous improvement across the University, and to provide evidence of compliance with external accreditation standards. The incumbent: -Supports the institution's internal and public-facing, strategic and operational reporting needs. -Supports information requests from inception to delivery, translating requirements into analyses and appropriate reporting objects that tell a story with data including, but not limited to: statistical reports, narrative summaries, dashboards, and analytic scorecards. -Provides analytic programming support (e.g., R, Python, or SAS). -Integrates information from a variety of campus operational and data warehouse systems, synthesizes and analyzes data in preparing reports that respond to specific questions, and also to build self-service resources that enable users to explore the data and answer questions independently. -Develops and implements web-based interactive reporting applications using dashboard tools (e.g., Tableau, R, SAS Visual Analytics, Microsoft Power BI) to communicate quantitative and visually-displayed information to internal UNC-Chapel Hill and external constituents such as accreditors, governance bodies, and others. -Develops and implements user-interactive reporting objects including filters, tool tips, and statistically-based 'what if' scenarios. -Creates sustainable data models using SQL and database tools. -Helps build strong collaborative, consultative relationships between OIRA and other campus organizations, establishing the Office of the Provost as a key partner and leader in 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. -May lead or coordinate small, informal team(s) of developers to expedite completion of various assignments and/or projects. Minimum Education and Experience 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. Required Qualifications, Competencies, and Experience -Demonstrate strong analytic and problem-solving skills with great attention to detail and accuracy while working with large, disparate data sets and performing mining, validation, and information interpretation. -Demonstrated experience using complex SQL queries to extract data from databases. -Demonstrated ability to conduct basic statistical analyses using tools such as SPSS, Stata, SAS, Excel. -Evidence of ability to present information that is easily interpretable by technical and non-technical audiences using various formats including Excel and PowerPoint. Preferred Qualifications, Competencies, and Experience -Four or more years of analytic programming using tools like R, Python, and SAS. -Four or more years of progressively more responsible experience building web-based, interactive dashboards, analytics, scorecards, dynamic reports, and other business intelligence objects using commercial data visualization tools (e.g., Tableau, R, SAS Visual Analytics, Microsoft Power BI). -Demonstrated experience creating database objects including views, tables, and indexes in an enterprise quality relational database system (e.g., SQL Server, Oracle, MySQL). -Demonstrate time management skills including clearly defining and planning activities and setting personal and working team priorities, juggling competing priorities in a fast-paced, complex environment. Special Physical/Mental Requirements Campus Security Authority Responsibilities Not Applicable. Special Instructions Quick Link https://unc.peopleadmin.com/postings/291302 Posting Contact Information Department Contact Name and Title Garrett Hirth, Business Manager Department Contact Telephone or Email gmhemail.unc.edu 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 employmentunc.edu Please note: The Office of Human Resources will not be able to provide specific updates regarding position or application status. Equal Opportunity Employer Statement 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.