IT Data Analyst Senior

IdahoPTV; Boise (ID); On-site; USD 75,000 - 110,000; Full time

Benefits offered by this job

Medical, vision, and dental insurance

11 paid holidays

Paid sick and vacation

Life insurance

Job summary

State of Idaho—Office of the State Board of Education in Boise seeks a data professional with strong SQL skills to design queries, develop scalable ETL pipelines, build API integrations, and automate workflows across enterprise systems. You will produce diverse reports and dashboards, supporting data-driven decision making for Idaho’s public education system.

Under general direction, you will work in a team with minimal supervision, ensuring data accuracy and sharing insights with stakeholders

Qualifications

• Proficient in SQL and data querying.
• Knowledge of SSIS, ETL processes, and API integration.
• Understanding of data interoperability and tools for data exchange.

Responsibilities

• Catalog and document existing data pipelines.
• Create and document ETL pipelines using internal and external data sources.
• Design dashboards and reports with visualizations for end users.
• Write SQL scripts to populate data warehouses or data lakes.
• Fulfill ad hoc reporting requests.
• Provide redundancy in SSIS packages and processes.
• Collaborate with stakeholders to identify analytic opportunities.
• Coordinate development and testing of databases and applications.

Skills

SQL proficiency

SSIS knowledge

APIs integration

ETL design

SSO knowledge

Education

Bachelor's degree in IT or CS

CompTIA Data+ certification

Tools

SSIS

Power BI

ESRI GIS

Python or R

Job description

Posted 2 days ago | Apply before November 30, 2026

Description

State of Idaho

Office of the State Board of Education

Applications will be accepted through 11:59 PM MST on the posting end date.

STATE OF IDAHO EMPLOYEES: If you are a current or temporary State of Idaho employee you MUST apply through Luma Opportunities. Applying through the State of Idaho’s external career website will cause duplicate profiles and will slow the processing of your application for a new position.

About the Agency: The Idaho State Board of Education (Board) is established in the Idaho Constitution for the “general supervision of the state educational institutions and public school system.” State law charges the Board with the general supervision, governance and control of public schools and postsecondary institutions, including community colleges. The Board is comprised of eight members: seven appointed by the Governor, as well as the statewide elected superintendent of public instruction. The Office of the State Board of Education (OSBE) is charged with providing professional staff support to the Board and implementing the Board’s policies, programs, and initiatives.

Summary: The State Board of Education maintains a comprehensive Statewide Longitudinal Data System (SLDS) containing information on all of Idaho’s students, educators, and Local Education Agencies (LEAs). This data is used to meet federal and state reporting requirements, inform data-driven decision making, and to fund Idaho’s public schools which account for approximately 50% of Idaho’s annual general fund expenditures. In addition, the Information Technology department maintains dozens of applications and associated systems that interact with the SLDS and with systems maintained and operated by LEAs.

We are seeking a data professional with strong SQL skills to design queries, develop and maintain scalable ETL pipelines, build API integrations across enterprise systems, and automate workflows. Under general direction, incumbent is responsible for performing a variety of technical tasks identifying, capturing, analyzing, managing, and presenting data. Produces a variety of reports using database retrieval scripts. Contributes to decision-making and planning to include conceptualization and modeling of data of high complexity. Responds to requests for data from a variety of stakeholders, as requested. Performs related work.

The selected individual will be working in a team environment under minimal supervision, with considerable latitude for the use of initiative and independent judgement.

Responsibilities:

• Catalog and document existing data pipelines.
• Create and document new data pipelines including extract, transform, and load (ETL) processes incorporating both internal and external data sources.
• Work with end users to design and implement dashboards and reports using illustrative visualizations.
• Write SQL scripts to create and populate data warehouses, data lakes, etc.
• Fulfill ad hoc reporting requests.
• Provide redundancy in SQL Server Integration Services (SSIS) packages
• Recommends analytic opportunities and best practices to management.
• Consult with users on current and future use of data and reporting systems.
• Coordinate development and testing among collaborators of databases and applications to compile and access data.
• Triage data discrepancies and prepares processes to correct.
• Develop data queries and export processes to provide information to Department staff, partner organizations and the public for complex requests.
• Produces research and statistical reports, data sets, and data summaries using a variety of analytical techniques and software tools involving master-level use of database retrieval scripts.
• Documents data handling and reporting issues to ensure consistency and validity of data between and within sites.
• Maintains and updates data catalogs, data catalog directories, and metadata.
• Performs related duties and fulfills responsibilities as required.

Supervisory Responsibilities:

• None; may provide technical guidance or mentoring to peers or junior staff.

Minimum Qualifications:

• Proficient in programming languages, specifically SQL
• Knowledge of:
• Integration strategies and tools to improve interoperability of Education Data Systems such as SQL Server Integration Services (SSIS), scripting languages, ETLs, API integration and implementation, Single Sign-On (SSO), etc.
• Current information technology practices and applications
• Ability to:
• Design, test, and implement new technologies
• Drive effort to streamline data collection from LEAs through more automated integrations
• Evaluate existing system processes and ETLs
• Review, analyze and evaluate business systems, tools and information needs with a focus on interoperability

Preferred Qualifications:

• Four (4) years of related work experience, such as:
• Prior experience working with educational data at the LEA or SEA level
• Prior experience working with various Education Data Systems infrastructure components such as Student Information Systems (SIS), Learning Management Systems (LMS), Instructional Management Systems (IMS), Learning Object Repositories (LOR), etc.
• 2 years’ experience with SQL Server Integration Services (SSIS)
• Bachelor's degree from an accredited college or university in information technology or computer science
• CompTIA Data+ certification
• Proficient in data analysis languages such as Python or R
• Proficient with ESRI or other GIS software and geospatial data analysis
• Proficient with PowerBi or DAX

Special Notification: This position is exempt from the rules of classified service under the provisions of Section 67-5303, Idaho Code. This position is educational IT exempt from overtime. The successful applicant will be required to pass a background check.

In addition to salary, the State of Idaho contributes an average of nearly 40% of an employee’s annual salary toward comprehensive benefits, creating a competitive total compensation package! This robust total compensation and benefits package includes, but is not limited to:

• Medical, vision, and dental insurance benefits that become effective first of the month following your hire date. All contributions can be pre-tax
• 11 paid holidays
• Paid sick and vacation that begins accruing on your first day of employment; can be used immediately after accruing (no waiting time)
• Life insurance for self, spouse, and children

The State Board of Education requires participation in the Idaho Optional Retirement Plan (ORP)for benefited and non-classified staff who do not have previous credited service with PERSI. The Idaho ORP is a defined contribution plan (401(a)) where both the employer and employee make contributions to the individual employee's account. Employees are immediately vested when enrolled in the ORP. Therecord keeper for the ORP is Fidelity Investments, and the ORP plan is administered by the State Board of Education. The State Board of Education also provides supplemental deferred compensation (457(b)) and 403(b) plans. More information can be found here : https://boardofed.idaho.gov/data-research/finance-administration/retirement-plans/

The State of Idaho is committed to providing equal employment opportunities and prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities and prohibit discrimination against all individuals based on their race, color, religion, political affiliation or belief, sex, national origin, genetics, or any other status protected under applicable federal, state, or local laws.

The State of Idaho is committed to access and reasonable accommodations for individuals with disabilities, auxiliary aids and services are available upon request. If you require an accommodation at any step in our recruitment process, you are encouraged to contact [phone] (TTY/TTD: 711), or email [e-mail] . (If you have a contact for applicant accommodations at your agency, please replace the contact information).

Preference may be given to veterans who qualify under state and federal laws and regulations.