Institutional Data Analyst or Senior Institutional Data Analyst

Concordia University Chicago; River Forest (IL); Hybrid; USD 65,000 - 75,000; Full time

Benefits offered by this job

Health benefits

Tuition benefits

Retirement plan

Job summary

Concordia University Chicago is seeking an Institutional Data Analyst or Senior Institutional Data Analyst to lead data extraction, transformation, and visualization efforts across programs and accreditation activities. You will design data pipelines, maintain data quality, and collaborate with multiple university offices on strategic initiatives.

The role emphasizes data transformation, lifecycle management, and visualization, with responsibilities extending to surveys, dashboards, and

Qualifications

• 5 years of experience in higher education data/IR role.
• Experience with Ellucian Banner ERP and data governance.
• Ability to document processes and data pipelines.

Responsibilities

• Lead data extraction projects tied to Office of Institutional Planning and Effectiveness requests.
• Extract and combine data from Ellucian Banner ERP, Blackboard, CRM and external sources to support strategic decisions.
• Author automation scripts to ensure reproducible data mining and analysis.
• Quality control reviewer for peers' work in the office.
• Learn and promote R, PowerBI, and GitHub as innovation tools.
• Manage survey administration including data collection and analysis.
• Create and maintain internal/external reports using R, Excel, and analytics tools.
• Conduct quantitative/qualitative research and prepare technical reports for the university and accreditation bodies.
• Perform statistical analysis and generate charts and visualizations for stakeholders.
• Develop dashboards and KPI reports for university initiatives.
• Disseminate data via web, documents, and presentations in user-friendly formats.
• Provide best-practice feedback and advocate for data collection/system improvements.
• Serve on committees or act as institutional contact as assigned.

Skills

R

PowerBI

SQL

Ellucian Banner ERP

CRM data

Data cleaning

Data analysis

Statistical analysis

Command line

Education

Bachelor's degree required

Master's degree preferred

PowerBI certification preferred

Tools

GitHub

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

• 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.
• 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.
• Author automation scripts to make data mining and analysis replicable on all regular work, using AI responsibly as needed.
• Quality Control reviewer for work performed by other analysts in the Office of Institutional Planning and Effectiveness.
• 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.
• Manage aspects of survey administration, including data collection, data analysis, report writing, and presentations as needed.
• Create, edit, and maintain internal and external reports using R, Excel, or other data analytic tools.
• Conduct quantitative and qualitative research; prepare technical reports and other publications for the university and accrediting bodies.
• Perform statistical analysis; interpret statistical outputs for faculty and other administrators for programmatic and business decisions; generate charts, tables, and other visualizations.
• Provide templates for and collaborate with others to create and maintain effective, valid, and reliable performance indicator dashboards and report cards for University initiatives.
• 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.
• 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.
• 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.

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.

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.

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.

Salary: $65000 - $75000 per year