Strategic Institutional Research Data Analyst

Lake Area Technical College; Watertown (SD); On-site; USD 55,000 - 75,000; Full time

Job summary

Lake Area Technical College is seeking an Institutional Research Data & Reporting Analyst to support data-informed decision-making and regulatory compliance. The role collaborates across departments to deliver accurate, timely information for planning, accreditation, enrollment management, and student success initiatives.

Responsibilities include designing and maintaining reports, writing SQL queries, and producing dashboards for internal stakeholders and external reporting.

Qualifications

• Associate degree or higher in computer science or related field.
• Experience with relational databases and data extraction.
• Proficiency writing SQL queries for reporting and analysis.
• Experience creating reports for planning, compliance, or decision-support.
• Ability to analyze data, troubleshoot issues, and communicate findings clearly.
• Strong attention to detail, confidentiality, and documentation.

Responsibilities

• Design, develop, maintain, and document reports, queries, and data processes.
• Write, test, optimize, and troubleshoot SQL queries and related objects.
• Create standard, recurring, and ad hoc reports for stakeholders and agencies.
• Collect, validate, clean, and reconcile data from multiple sources for accurate reporting.
• Support external reporting including state, federal, and accreditation needs.
• Translate data into clear dashboards and summaries to communicate insights.
• Support strategic planning, program review, and accreditation with data analysis.
• Maintain data definitions and collaborate to align reporting standards.
• Provide training and guidance to faculty and staff on reports and BI tools.
• Stay current with reporting requirements and BI technologies in higher education.

Skills

Relational databases

SQL queries

Reporting for operations

Data analysis

Communication skills

Documentation

Education

Associate degree or higher in computer science, information systems, data analytics, statistics, or a related field

Tools

SSRS

Power BI

Tableau

Excel

Job description

Lake Area Technical College is seeking an Institutional Research Data & Reporting Analyst to support data-informed decision-making and regulatory compliance. The role collaborates across departments to deliver accurate, timely information for planning, accreditation, enrollment management, and student success initiatives.

Responsibilities include designing and maintaining reports, writing SQL queries, and producing dashboards for internal stakeholders and external reporting.