Assistant Director, Enrollment Reporting– Enrollment Management Group
Salary: Commensurate with experience
Benefits: Generous benefits include paid time off including holidays and vacation,
retirement match, and tuition remission for employee and dependents. Details at www.duq.edu/benefits
Location: Enrollment Management Group (EMG)
Position
Status: Full-time
Hours: Varied
Position
Number: 241197/10-1051
FLSA
Status: Exempt
POSITION SUMMARY:
Under the primary
direction of the Director of Enrollment Research and Effectiveness, the
Assistant Director of Enrollment Reporting serves as an integrated member of EM
Group’s Research, Analytics, and Effectiveness, Financial Aid, Admissions and
Enrollment Marketing teams in support of decision support and strategic planning
for the Office of the Senior Vice President for Enrollment Management. Manages
the survey and reporting cycle pertinent to all direct responses from EM to all
mandatory, cyclical, grant-related and ad hoc requests for data from, or being
submitted to, external sources, including but not limited to federal and state
agencies, accrediting bodies, commercial entities, and peer universities.
Responsible for the timely submission of EM-related IPEDS data; serve as the EM
content expert for the IPEDS system and common data set; assist others in
understanding the scope and type of data available, and provide data required
for institutional and programmatic accreditation, new program development,
program reviews, and annual reports.
DUTIES
AND RESPONSIBILITIES:
Survey Data,
Reporting, and Data Compilation and Deployment
Manages the survey and reporting cycle pertinent to
all direct responses from EM to all mandatory, cyclical, grant-related and ad
hoc requests for data from, or being submitted to, external sources, including
but not limited to federal and state agencies, accrediting bodies, commercial
entities, and peer universities.
Responsible for the timely submission of EM-related
IPEDS data; serve as the EM content expert for the IPEDS system and Common Data
Set; assist others in understanding the scope and type of data available, and
provide data required for institutional and programmatic accreditation, new
program development, program reviews, and annual reports.
Assists the EM Group in the administration and
compilation of institution-wide surveys being led by the Office of
Institutional Research.
Supports academic and administrative departments in
internal survey administrations and external data reporting.
Performs other duties as assigned by the Director or EM Senior Vice
President.
Assists with
collection and compilation of the 5th week enrollment statistics.
Admissions funnel statistics –
selectivity, yield
Standardized test score statistics
Lead statistics
Discount
Rate statistics
Enrollment comparisons to budget and prior
year statistics
Retention statistic
Reporting,
Analytics, and Decision Support
Produces
standard weekly reports as well as monthly, annual and ad-hoc reports.
Creates
dashboards and other reports for Enrollment Managers.
Writes,
maintains, and supports a variety of reports or queries in Cognos,
Technolutions Slate, PowerBI; assists in development of standard reports for
ongoing department and customer needs; maintains data integrity in systems by
running queries and analyzing data.
Extracts data from the
University’s systems and publicly or vendor available sources to create reports
and dashboards for campus stakeholders.
Reports and dashboards
may include tables, charts, executive summaries, and/or other items as needed.
Works with data sets,
including extracting, merging, cleaning, loading, and transforming data to meet
reporting needs from the Enterprise system (Banner) or the CRM (Slate) on
behalf of EM Group.
Collect trend data
regarding the university in relation to admissions topics among its peer and
aspirational institutions.
Responsible for providing
data required for institutional and programmatic accreditation, new program
development, program reviews, and annual reports.
Assists in fulfilling internal and external
data requests on behalf of EM.
Data Validation, Automation, and QA
Undertake
report-related process automation and workflow.
Automate
routine/annual reporting and survey tasks and output deployment activities.
Serves on Standing Committees and ad hoc
groups as requested by the Director or other EM leadership.
Participates in formal data governance
and data management practices.
Collaborate with
cross-functional teams to ensure the integrity and timely delivery of
regulatory reporting.
Develops a data discrepancy strategy in
partnership with systems and operations teams to enhance data integrity,
improve validation and reconciliation, and strengthen reporting validity.
Perform data
audits and validation, develop checks to identify data quality issues, and work
with appropriate staff to resolve issues as needed.
Communicate
with personnel division-wide with an overt focus on the needs of leadership to
identify and translate business requirements into CRM and BI reporting
solutions.
Capacity Building
& Training
Participates in the
implementation of Enrollment Management based technology projects and performs
other duties as assigned or directed.
Documents code and key
survey/reporting activities in Sharepoint.
Participates in agile
planning and project management activities.
Mentors enrollment
management staff on data extraction, query building, surveys, and reporting.
Attends and assists with Enrollment
Management events as necessary (Duq Day, Admitted Student Events, etc.)
REQUIREMENTS:
Minimum
qualifications:
Bachelor’s degree
from an accredited institution in Applied Social Sciences, Computer Science,
Information Systems, Statistics, Data Analytics, Business, or closely related
field of study and one to two years of related experience.
Three or more years of related experience.
Preferred
qualifications:
Master’s Degree
from accredited institution in Social Sciences or applied Social Sciences,
Statistics, Data Science or Analytics, Computer Science, Information Systems,
Business, Mathematics, Higher Education Administration or any related field.
Experience with
Banner student system and Cognos reporting tools is preferred.
Post-secondary education
experience preferred.
Alternately,
the successful candidate may possess any equivalent combination of experience
and training, which provides the knowledge, skills and abilities required to
perform the essential job functions. This includes, but is not limited to, the
following:
CRM experience, data mining, report and query building
experience, ETL and Data integration experience, Ellucian Banner student system
or other ERP experience, SPSS, IBM Cognos experience, Microsoft data tools (Power BI, Excel,
Access), business intelligence and visualization tools (Tableau, Power BI,
etc.), Agile Planning/Project Management Experience, Data interpretation and
presentation experience and proficiency in Microsoft Office Suite (Excel,
Access, Word, Power Point) required.
Other Knowledge, Skills and Abilities include:
Demonstrated
experience optimizing Argos or Cognos banded reporting and automation potential
for supporting EM group.
Demonstrated
ability to conduct statistical analyses using tools such as SPSS, Stata, R, Python, SAS, and
Excel.
Evidence of using creative
problem-solving, data science, and statistical analysis to develop solutions
that match unique project and reporting needs.
A clear
ability to verbally and visually present information that is easily
interpretable by technical and non-technical audiences using various formats
including visual data platforms (e.g., Tableau or Microsoft PowerBI), Microsoft
Excel, and PowerPoint.
Demonstrated
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.
Demonstrated
high level of proficiency with query languages,
use of relational databases, and enterprise data/application integration and
systems activities.
A
commitment to and understanding of agile project management practices.
Ability
to translate business needs into elegant and sustainable technical reporting
solutions.
Strong understanding of student system
database design, structures, functions, and processes.
Effective organizational and
interpersonal skills including strong written and verbal communications skills.
Possess strong customer service
skills.
Possess a proactive results-oriented
attitude.
Strong analytical and problem-solving
skills with demonstrated ability to reason logically and develop alternative
solutions for complex information system issues.
Maintain integrity and confidentiality of proprietary
information.
Ability to initiate and follow through
with work responsibilities and meet deadlines.
Ability to prioritize, track and
complete ad-hoc requests as well as major projects.
Ability to work independently on
confidential assignments.
Ability to work well with committees
and on teams.
Ability to work additional hours and
weekends during peak recruitment periods.
Knowledge of CRM (preferably
Technolutions Slate), data mining, reports and queries, and SQL coding.
Ability to work with diverse
populations and sensitivity to the need of each individual to be treated with
dignity and respect as it relates to diversity in general and the Mission of
the University specifically.
Experience managing data and database systems in client servers and
personal computer environments is essential to meeting the responsibilities of
the position.
Ability and
willingness to contribute actively to the mission of the University and to
respect the Spiritan Catholic identity of Duquesne University. The
mission is implemented through a commitment to academic excellence, a spirit of
service, moral and spiritual values, sensitivity to world concerns, and an
ecumenical campus community.
APPLICATION
INSTRUCTIONS:
Applicants are asked to submit a cover letter, resume, and contact information
for three professional references.
Duquesne University was founded in 1878 by its sponsoring religious community,
the Congregation of the Holy Spirit. Duquesne University is Catholic in
mission and ecumenical in spirit. Motivated by its Catholic identity,
Duquesne values equality of opportunity both as an educational institution and
as an employer.