Data Analyst Job Lewiston area,Idaho USA,IT/Tech

LC State invites applications for the position of Data Analyst.

Salary and rank based on experience and qualifications: $49,754 - $60,000

Degree

Required:

Bachelor's degree in a relevant discipline from an accredited institution. Relevant disciplines may include social science, data science, statistics, computer science, information systems, mathematics, business analytics, or related field.

Required Qualifications:

Demonstrated willingness and ability to learn technical skills through training and mentorship.
One (1) to three (3) years of related experience and/or training; or equivalent combination of education and experience. Specifically, experience with:
SQL querying and database management
Operational reporting - creating reports that support business functions and decision-making
Data visualization tools, particularly Power BI or Tableau - creating dashboards and visual reports
Advanced Excel software skill
Data validation and quality control
Working as part of a collaborative team

Preferred Qualifications:

Master's degree from an accredited institution in social science, data science, statistics, information systems, institutional research, education, computer science, or related field
Experience with or strong interest in any or all of the following:
Programming or scripting languages, particularly for automation and data workflows - ability to automate repetitive tasks and streamline data processes
Student information systems (Banner, Colleague, People Soft) or other ERP systems
Data governance - understanding of data management principles, data quality frameworks, and data stewardship
Predictive modeling - interest or experience in statistical modeling, forecasting, or machine learning applications
Higher education data - familiarity with higher education metrics, terminology, or data structures
Statistical software (SPSS, SAS, R)
Survey tools (Qualtrics or similar)
IPEDS or other higher education reporting
Understanding of FERPA and data privacy
Advanced SQL techniques (CTEs, window functions, query optimization)
ETL processes and data integration

Responsibilities:

Write and optimize SQL queries to extract, validate, and report institutional data from databases; manage data quality and database integrity.

Develop operational reports and dashboards to support daily institutional functions, decision-making, and strategic planning across departments.

Create interactive data visualizations and dashboards using Power BI or Tableau to communicate findings effectively to diverse stakeholders.

Curate institutional datasets by performing data quality checks, data cleansing, and validation; document data sources and processes.

Extract and integrate data from multiple sources including student information systems, financial systems, and HR databases.

Assist in creating automated reporting processes and data workflows; document queries and procedures for consistency and continuity.

Conduct data analyses using SQL and statistical methods; implement validation routines to ensure accuracy.

Prepare federal and state compliance reports including IPEDS with support and mentorship from team members experienced in regulatory reporting.

Coordinate data requests from internal users; translate information needs into technical solutions including queries, reports, and visualizations.

Collaborate with team members on survey design and administration using Qualtrics; analyze and report on survey response data.

Test and validate data for accuracy; identify and resolve data quality issues.

Collaborate with IT staff to maintain data security and integrity per FERPA requirements.

Learn and apply research methods and institutional research best practices through training and mentorship from experienced team members.

Stay current on data analysis tools, SQL, data visualization platforms, and emerging technologies through training and professional development.

Manage multiple projects with competing priorities while maintaining attention to detail and documentation standards.

Other duties as assigned, including enrollment support and recruitment/retention activities.

Application Procedure:

Cover Letter/Letter of Interest
Resume/Curriculum Vitae
Contact Information or Letter for three (3) Professional References
Unofficial Transcripts (Official Transcripts requested upon hire)

This position is open until filled. Posting will remain open until a suitable pool of candidates is identified.

This position is subject to the successful completion of a criminal background check and may also be subject to an education verification. LC State is an EEO/VETS employer.

#J-18808-Ljbffr