Data Analyst Python Sql Jobs in Idaho (NOW HIRING)

LC State invites applications for the position of Data Analyst. This position is located in Lewiston, Idaho. Remote work is not available.

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:
  
  1. SQL querying and database management
  2. Operational reporting - creating reports that support business functions and decision-making
  3. Data visualization tools, particularly Power BI or Tableau - creating dashboards and visual reports
  4. Advanced Excel software skill
  5. Data validation and quality control
  6. 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:
  1. Programming or scripting languages, particularly for automation and data workflows - ability to automate repetitive tasks and streamline data processes
  2. Student information systems (Banner, Colleague, PeopleSoft) or other ERP systems
  3. Data governance - understanding of data management principles, data quality frameworks, and data stewardship
  4. Predictive modeling - interest or experience in statistical modeling, forecasting, or machine learning applications
  5. Higher education data - familiarity with higher education metrics, terminology, or data structures
  6. Statistical software (SPSS, SAS, R)
  7. Survey tools (Qualtrics or similar)
  8. IPEDS or other higher education reporting
  9. Understanding of FERPA and data privacy
  10. Advanced SQL techniques (CTEs, window functions, query optimization)
  11. ETL processes and data integration

Responsibilities:

1. Write and optimize SQL queries to extract, validate, and report institutional data from databases; manage data quality and database integrity.
2. Develop operational reports and dashboards to support daily institutional functions, decision-making, and strategic planning across departments.
3. Create interactive data visualizations and dashboards using Power BI or Tableau to communicate findings effectively to diverse stakeholders.
4. Curate institutional datasets by performing data quality checks, data cleansing, and validation; document data sources and processes.
5. Extract and integrate data from multiple sources including student information systems, financial systems, and HR databases.
6. Assist in creating automated reporting processes and data workflows; document queries and procedures for consistency and continuity.
7. Conduct data analyses using SQL and statistical methods; implement validation routines to ensure accuracy.
8. Prepare federal and state compliance reports including IPEDS with support and mentorship from team members experienced in regulatory reporting.
9. Coordinate data requests from internal users; translate information needs into technical solutions including queries, reports, and visualizations.
10. Collaborate with team members on survey design and administration using Qualtrics; analyze and report on survey response data.
11. Test and validate data for accuracy; identify and resolve data quality issues.
12. Collaborate with IT staff to maintain data security and integrity per FERPA requirements.
13. Learn and apply research methods and institutional research best practices through training and mentorship from experienced team members.
14. Stay current on data analysis tools, SQL, data visualization platforms, and emerging technologies through training and professional development.
15. Manage multiple projects with competing priorities while maintaining attention to detail and documentation standards.
16. Other duties as assigned, including enrollment support and recruitment/retention activities.

Application Procedure: Please upload all of the following documents or your application may not be considered for review.

• 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.