Job Description

Senior Business Intelligence Analyst Institutional Planning Assessment Research

| |

Please see Special Instructions for more details.

East Carolina University requires applicants to submit a candidate profile online in order to be considered for the position. Candidates must also submit a cover letter, resume, and a list of three references, including contact information, online.

Applicants must be currently authorized to work in the United States on a full-time basis.

Two to three original letters of reference are required for employment. Please be aware that if selected as a candidate of choice, an automatic e-mail will be sent to the individuals entered in the References section of the PeopleAdmin applicant tracking system. Letters of reference submitted via the PeopleAdmin applicant tracking system will be verified and considered towards meeting this requirement.

Posting Details

Position Information

Job Title Senior Business Intelligence Analyst Institutional Planning Assessment Research
Position Number 900045
Vacancy Open to All Candidates
Department AAH Inst PlanningAssessmentResearch
Department Homepage
Advertising Department INSTITUTIONAL PLANNING, ASSESSMENT & RESEARCH
Division Academic Affairs
Classification Title Research Associate
Working Title Senior Business Intelligence Analyst Institutional Planning Assessment Research
Number of Vacancies 1
Full Time Equivalent (FTE) 1.0
Full Time or Part Time Full Time
Recruitment Range $64,076 - $90,000
Position Location (City) Greenville
Position Type Non-Faculty
Job Category Non-Faculty Instructional & Research
Organizational Unit Overview

The Office of Institutional Planning, Assessment, and Research [IPAR] is directed by the Associate Provost for IPAR, who reports to the Provost and Senior Vice Chancellor for Academic Affairs. IPAR collects, analyzes, warehouses, and disseminates data about East Carolina University. IPAR facilitates and enhances university-wide strategic and operational planning, assessment, evaluation, and research activities to ensure compliance with accreditation standards and support institutional decision-making and continuous improvement. IPAR is the University\'s primary contact with The University of North Carolina System Office, the Southern Association of Colleges and Schools Commission on College (SACSCOC), and other external constituencies in meeting the data, reporting, and compliance requirements established by these various agencies/bodies.
Job Duties

The Senior Business Intelligence Analyst reports primarily to the Associate Director for Institutional Research. The Senior Business Intelligence Analyst assumes responsibility for assignments that support the planning, assessment, and research functions in IPAR; the scope of the position extends from IPAR to the entire University community. The Senior Business Intelligence Analyst plays a key role in data reporting and visualization; data management and quality; and business intelligence training, education, and promotion at the University. The Senior Business Intelligence Analyst also supports UNC System data marts and serves in a leadership role on data mart cross functional teams.

Data Reporting and Visualization - 30%

• Design, develop, and deploy business intelligence reports (using Microsoft SQL Server Reporting Services) and dashboards (using Microsoft Power BI) to inform decision-makers at the University and to communicate analytical and longitudinal findings to internal and external end users effectively.
• Collaborate with cross-functional teams and clients, both internal and external to IPAR, to identify business requirements and translate them into business intelligence solutions.
• Stay updated on best practices and emerging technologies in higher education business intelligence, data visualization, and analytics.

Data Management and Quality - 30%

• Extract and analyze complex datasets from the University\'s data warehouse by writing SQL queries and developing dashboard data models.
• Collaborate with Information Technology and Computing Services (ITCS) staff to 1) create and maintain crosswalks and code descriptions needed for longitudinal and/or regulatory reporting, 2) consult on the development of new reporting views and ETL (extract, transform, load) processes in the University data warehouse, and 3) consult on the design and timing of institutional data snapshots in the University data warehouse.
• Create and maintain data quality reports for regular monitoring. Collaborate with data stewards, data custodians, and other stakeholders to resolve data quality issues and implement preventive measures.
• Conduct assessments of data quality by identifying discrepancies, errors, and inconsistencies within datasets to be used in dashboards, data models, research projects, or statistical modeling conducted by IPAR staff and/or institutional research partners.

Business Intelligence Training, Education, and Promotion - 20%

• Conduct engaging and interactive training, educational, and/or promotional sessions for end users, both in-person and virtually as appropriate, on IPAR business intelligence products.
• Provide one-on-one coaching and support on IPAR business intelligence products to end users as needed, addressing their specific questions and challenges.
• Create and maintain training materials, documentation, and user guides on IPAR business intelligence products to support ongoing learning among end users.

UNC System Office Human Resources Data Mart Leadership - 15%

• Serve as the ECU representative to the UNC System Office on the Human Resources Data Mart (HRDM).
• Provide leadership for the cross-functional team responsible for submitting accurate, complete, and timely data on ECU faculty and staff to the UNC System Office via the HRDM.
• Collaborate with Human Resources Information Systems (HRIS), ITCS, and UNC System Office staff to ensure HRDM upgrades are tested and implemented according to specified requirements.
• Collaborate with Human Resources, EHRA Personnel Administration, and other functional offices to actively monitor and correct missing or erroneous data on ECU faculty and staff prior to HRDM submission due dates.

Other - 5%

• This position will cultivate positive and productive relationships with other departments and demonstrate creativity in recommending solutions for user reporting needs. This position will represent IPAR on various campus committees or working/advisory groups aligned with areas of expertise. Working with faculty, staff, and student data necessitates the utmost care in data security and confidentiality. This position will be knowledgeable of and adhere to policies and procedures related to data security.

This position is contingent upon available funding.
Minimum Education/Experience

• Post-Baccalaureate degree required; will accept a bachelor\'s degree and two or more years of relevant experience in substitution.
• Proficiency in BI tools such as Tableau, Power BI, or equivalent.
• SQL skills and experience working with large datasets.
• Excellent communication and presentation skills.
• Experience conveying complex findings to non-technical stakeholders.

License or Certification Required by Statute or Regulation

n/a
Preferred Experience, Skills, Training/Education

• Experience working in higher education.
• Knowledge of and experience with Ellucian Banner and Operational Data Store (ODS).
• Knowledge of Microsoft SQL Server Reporting Services, and Oracle database environments.
• Strong project management skills with exceptional attention to detail and accuracy.

Special Instructions to Applicant

East Carolina University requires applicants to submit a candidate profile online in order to be considered for the position. Candidates must also submit a cover letter, resume, and a list of three references, including contact information, online.

Applicants must be currently authorized to work in the United States on a full-time basis.

Two to three original letters of reference are required for employment. Please be aware that if selected as a candidate of choice, an automatic e-mail will be sent to the individuals entered in the References section of the PeopleAdmin applicant tracking system. Letters of reference submitted via the PeopleAdmin applicant tracking system will be verified and considered towards meeting this requirement.
Additional Instructions to Applicant

In order to be considered for this position, applicants must complete a candidate profile online via the PeopleAdmin system and submit any requested documents. Additionally, applicants that possess the preferred education and experience must also possess the minimum education/experience, if applicable.
Job Open Date 12/15/2023
Open Until Filled Yes
Job Close Date - Positions will be posted until 11:59 p.m. EST on this date. If no closing date is indicated, the position may close at any time after the initial screening date.
Initial Screening Begins 01/15/2024
Rank Level
Quick Link for Direct Access to Posting
AA/EOE

East Carolina University is an equal opportunity and affirmative action employer and seeks to create an environment that fosters the recruitment and retention of a more diverse student body, faculty, staff and administration. We encourage qualified applicants from women, minorities, veterans, individuals with a disability, and historically underrepresented groups. All qualified applicants will receive consideration for employment without regard to their race/ethnicity, color, genetic information, national origin, religion, sex, sexual orientation, gender identity, age, disability, political affiliation, or veteran status.

Individuals requesting accommodation under the Americans with Disabilities Act Amendments Act (ADAAA) should contact the Department of Human Resources at (252) 737-1018 (Voice/TTY) or .
Eligibility for Employment

Final candidates are subject to criminal & sex offender background checks. Some vacancies also require credit or motor vehicle checks. ECU participates in E-Verify. Federal law requires all employers to verify the identity and employment eligibility of all persons hired to work in the United States.
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 (252) 328-9847 or toll free at 1-866-489-1740 or send an email to employment@ecu.edu. Our office is available to provide assistance Monday-Friday from 8:00-5:00 EST.

East Carolina University