Institutional Data Analyst or Senior Institutional Data Analyst

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

Benefits offered by this job

Health plan

Job summary

Concordia University Chicago seeks an Institutional Data Analyst to lead data extraction and transformation efforts for quality programs and effectiveness initiatives.

The role requires expertise in R, PowerBI, SQL, and large data-set handling, with emphasis on data security, surveys, and reporting for accreditation and planning teams.

Hybrid work on campus with some remote days, reporting to the Office of Institutional Planning and Effectiveness.

Qualifications

• 5 years of experience in higher education institutional research or related role.
• Bachelor's degree required; master's preferred.
• PowerBI certification preferred.
• Experience with Ellucian Banner ERP required.
• Ability to collect, clean, merge, and analyze large data sets.

Responsibilities

• Serve as technical lead on data extraction projects for the Office of Institutional Planning and Effectiveness.
• Extract, combine, and manipulate data from Ellucian Banner ERP, Blackboard, CRM and other sources for decision making.
• Author automation scripts to ensure repeatable data mining and analysis.
• Quality control reviewer for colleagues' work.
• Learn and promote tools like R, PowerBI, and GitHub within the team.
• Manage survey administration including data collection, analysis, and reporting.
• Create and maintain internal and external reports using R, Excel, or other tools.
• Conduct both quantitative and qualitative research and prepare technical reports.
• Perform statistical analysis and generate charts and visualizations.
• Develop dashboards and performance indicators for university initiatives.
• Disseminate data using web visualizations and reports; communicate methods to diverse audiences.
• Provide input on data collection improvements and software updates.

Skills

R

PowerBI

SQL

Data visualization

Data cleaning/merging

Education

Bachelor's degree

Master's degree preferred

PowerBI certification preferred

Tools

PowerBI

SQL

Ellucian Banner ERP

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.