Institutional Data Analyst or Senior Institutional Data Analyst

Concordia University Chicago; Oak Park (IL); Hybrid; USD 85,000 - 110,000; Full time

Benefits offered by this job

Health insurance

Disability plan

Tuition benefits

Job summary

Concordia University Chicago seeks an Institutional Data Analyst to lead data design, transformation, and visualization efforts across reporting for quality programs, student success, and effectiveness initiatives. The role emphasizes data lifecycles and collaboration with campus teams.

After onboarding, the position can work up to 2 days per week remotely, with remainder on campus, supporting strategic planning, assessment, and accreditation activities.

Qualifications

• Strong proficiency with R for statistical analysis.
• Data visualization experience, preferably PowerBI.
• Proficiency in SQL and command line.
• Experience with Ellucian Banner ERP.
• Experience with CRM data is helpful.
• Ability to clean, merge, maintain and analyze large datasets.
• Excellent written and verbal communication skills.

Responsibilities

• Lead data extraction projects and write technical requirements.
• Extract and manipulate data from Ellucian Banner ERP, Blackboard, CRM and other sources.
• Develop automation scripts for repeatable data mining and analysis.
• Quality control reviewer for work by other analysts.
• Learn and promote tools like R, PowerBI, and GitHub.
• Manage survey administration and data analysis; write reports.
• Create and maintain internal and external reports using R/Excel.
• Perform statistical analysis and visualize results; produce charts and dashboards.
• Provide dashboards and performance indicator reports for university initiatives.
• Disseminate results via websites, reports, and presentations.
• Offer best-practice guidance for data-informed institutional planning; advocate software updates.

Skills

R

Data visualization

SQL

Command line

Data cleaning

Audience communication

Ethics in data

Education

Master's degree preferred in relevant field

Bachelor's degree required

Tools

Ellucian Banner ERP

PowerBI

GitHub

Excel

CRM data tools

Job description

The Institutional Data Analyst or Senior Institutional Data Analyst is a technical lead in the Office of Institutional Planning and Effectiveness. The position is responsible for the design, creation, and maintenance of institutional data to support quality programs, student success and institutional effectiveness initiatives. This position has a special emphasis on data transformation, data lifecycles, and visualization. The position will receive projects with greater complexity and larger stakeholder groups. The position documents code, mining procedures, data quality, and visualization templates. The position will manage data inquiries from the University constituents, design surveys, and provide support for strategic planning, assessment, accreditation, and program review. After onboarding, this position can work up to 2 days a week from home with the rest on campus and will work in collaboration with the team members from the Office of Institutional Planning and Effectiveness and other university offices on assigned projects. The position is responsible for data security and data accuracy in reporting.

Responsibilities/Duties:

1. Technical lead on data extraction projects tied to requests going to the Office of Institutional Planning and Effectiveness. Responsible for writing technical requirements as needed. Positively interact with requestors as required to clarify or gather requirements.
2. Extract, combine, and manipulate data sets from Ellucian Banner ERP, Blackboard, CRM and other external data sources to drive effective strategic and programmatic decision-making, research, compliance, assessment, university accreditation and institutional improvement.
3. Author automation scripts to make data mining and analysis replicable on all regular work, using AI responsibly as needed.
4. Quality Control reviewer for work performed by other analysts in the Office of Institutional Planning and Effectiveness.
5. Learn new analytical tools, or updated features of existing tools, especially R, PowerBI and GitHub, and serve as a change agent for the Office of Institutional Planning and Effectiveness for these innovation initiatives.
6. Manage aspects of survey administration, including data collection, data analysis, report writing, and presentations as needed.
7. Create, edit, and maintain internal and external reports using R, Excel, or other data analytic tools.
8. Conduct quantitative and qualitative research; prepare technical reports and other publications for the university and accrediting bodies.
9. Perform statistical analysis; interpret statistical outputs for faculty and other administrators for programmatic and business decisions; generate charts, tables, and other visualizations.
10. Provide templates for and collaborate with others to create and maintain effective, valid, and reliable performance indicator dashboards and report cards for University initiatives.
11. Analyze, translate, and disseminate data in user-friendly manner, using data visualization on the web, visual documents (e.g., tables, charts, graphs, etc.) and disseminate results via appropriate electronic media, such as web sites, written reports, and in-person presentations.
12. Provide regular feedback on best practices in data-driven institutional planning and research and develop innovative systems to improve data collection, database content, streamline data analysis and reporting for greater efficiency. Make cases for software updates or changes as needed.
13. Perform other duties as assigned, such as serving on committees, being an institutional contact, etc.

Skill Sets:

• Highly proficient in the use of statistical analysis software such as R.
• Data visualization experience required, preferably in PowerBI
• Proficient in command line programming and SQL
• Ellucian Banner ERP experience required
• Previous experience working with CRM data helpful, but not required
• Strong ability to clean, merge, maintain and analyze large data sets
• Ability to prioritize and handle multiple tasks and projects simultaneously and meet project deadlines
• Ability to work independently, take initiative, and work with teams
• Maintain confidentiality, demonstrate knowledge and understanding of ethics in data collection and analysis
• Outstanding written and verbal communication skills to prepare statistical reports for internal and external stakeholders and ability to explain methods and analysis of data to audience with varying levels of expertise
• Strong analytical skills and strong attention to detail
• Familiarity with survey tools such as Qualtrics helpful
• Excellent written and verbal communication skills are required.

Minimum Experience Required:

5 years of experience working in a computer, strategic planning and/or institutional research support role in higher education. Candidate needs to demonstrate technical expertise working with a large database including Ellucian Banner ERP and building documentation.

Education Requirements:

Master's Degree preferred in educational research, data science, business analytics, social/behavioral sciences or related field. Bachelor's degree required. PowerBI certification preferred.

Compensation and Benefits:

Starting range is dependent upon individual qualifications and experience.

• Concordia health, disability and retirement plan enrollment is available to full-time employees and their eligible dependents.
• Tuition benefits are also available for employees and their qualified dependents.

About Concordia University Chicago:

Concordia University Chicago is a liberal arts-based Christian university founded in the Lutheran tradition. Through its College of Arts and Sciences, College of Business, College of Education, College of Graduate Studies, and College of Innovative and Professional Programs, Concordia-Chicago offers more than 160 areas of study in small classes taught by professors who are passionate about teaching and student success. All undergraduate and graduate degrees are fully accredited by the Higher Learning Commission of the North Central Association of Colleges and Schools.

Concordia University Chicago has been recognized as a College of Distinction since 2010, and in 2013 was named to the U.S. President's Higher Education Community Service Honor Roll for the fifth time. For the sixth consecutive year, combined undergraduate and graduate enrollment has exceeded more than 5,000 students. Concordia University Chicago is located in River Forest, 10 miles west of downtown Chicago. Learn more at CUChicago.edu.

Concordia does not discriminate in the employment of individuals on the basis of race, color, national or ethnic origin, disability, sex or age. As an institution of The Lutheran Church-Missouri Synod, however, and to the extent allowed by law, Concordia University reserves the right to give preference in employment based upon religious affiliation.

Concordia University Chicago does not generally sponsor for employment visas except for positions that oversee, teach or support our international programs.

Steadfast in Jesus Christ as revealed in the Holy Scriptures, Concordia University Chicago promotes academic rigor in its liberal arts and professional programs; grounds students in objective truth, integrity, and excellence; and practices faithfulness to the Confessional teachings of the Lutheran Church – Missouri Synod, as it forms students for vocations in church, family, and the world.