IT Data Analyst Senior

State of Idaho; Boise (ID); On-site; USD 45,000 - 48,000; Full time

Benefits offered by this job

Medical, vision, and dental insurance

11 paid holidays

Paid sick and vacation

Parental leave

Life insurance

PSLF eligibility

Employee assistance program

Tuition reduction benefits

Idaho Optional Retirement Plan (ORP)

457(b) and 403(b) plans

Job summary

Senior IT Data Analyst for the Idaho Office of the State Board of Education focuses on designing and delivering SQL, ETL, integrations, and analytics to support the SLDS and enterprise systems.

Responsibilities include building data pipelines, querying data warehouses and data lakes, and creating dashboards and reports. Documentation, data catalogs, and metadata management are part of the role.

Qualifications

• Proficiency in SQL and programming languages.
• Knowledge of integration strategies and tools to improve interoperability of Education Data Systems, including SSIS, scripting languages, ETLs, and API integration.
• Knowledge of Single Sign-On (SSO) and current information technology practices and applications.
• Ability to design, test, and implement new technologies.
• Ability to streamline data collection from LEAs through more automated integrations.
• Ability to evaluate existing system processes and ETLs.
• Ability to review, analyze, and evaluate business systems with a focus on interoperability.

Responsibilities

• Catalog and document existing data pipelines.
• Create and document new data pipelines with ETL processes using internal and external data sources.
• Partner with end users to design dashboards and reports using illustrative visualizations.
• Write SQL scripts to create and populate data warehouses and data lakes.
• Complete ad hoc reporting requests.
• Provide redundancy in SSIS packages.
• Recommend analytic opportunities and best practices to management.
• Consult with users on current and future data and reporting system needs.
• Coordinate development and testing among collaborators to compile and access data across databases and applications.
• Triage data discrepancies and prepare processes to correct them.
• Develop data queries and export processes to provide information to Department staff, partner organizations, and the public for complex requests.
• Produce research and statistical reports, data sets, and data summaries using analytical techniques and tools with master-level use of database retrieval scripts.
• Document data handling and reporting issues to support consistency and validity of data between and within sites.
• Maintain and update data catalogs, data catalog directories, and metadata.
• Perform related duties and fulfill responsibilities as required.

Skills

SQL

SSIS

ETL

API integration

Single Sign-On (SSO)

Data interoperability

Education

Bachelor’s degree in information technology or computer science

CompTIA Data+ certification

Tools

SSIS

PowerBi

Job description

Senior IT Data Analyst role with the Idaho Office of the State Board of Education, focused on designing and delivering SQL, ETL, integrations, and analytics that support the Statewide Longitudinal Data System (SLDS) and related enterprise systems.

Role Overview

This position supports statewide education data initiatives by building and maintaining data pipelines, developing database queries for data warehouses and data lakes, and producing dashboards, reports, and research outputs. The work also includes documenting data handling processes and maintaining data catalogs and associated metadata.

Key Responsibilities

• Catalog and document existing data pipelines.
• Create and document new data pipelines with extract, transform, and load (ETL) processes using internal and external data sources.
• Partner with end users to design and implement dashboards and reports using illustrative visualizations.
• Write SQL scripts to create and populate data warehouses and data lakes.
• Complete ad hoc reporting requests.
• Provide redundancy in SQL Server Integration Services (SSIS) packages.
• Recommend analytic opportunities and best practices to management.
• Consult with users on current and future data and reporting system needs.
• Coordinate development and testing among collaborators to compile and access data across databases and applications.
• Triage data discrepancies and prepare processes to correct them.
• Develop data queries and export processes to provide information to Department staff, partner organizations, and the public for complex requests.
• Produce research and statistical reports, data sets, and data summaries using analytical techniques and tools with master-level use of database retrieval scripts.
• Document data handling and reporting issues to support consistency and validity of data between and within sites.
• Maintain and update data catalogs, data catalog directories, and metadata.
• Perform related duties and fulfill responsibilities as required.

Required Qualifications

• Proficiency in SQL and programming languages.
• Knowledge of integration strategies and tools to improve interoperability of Education Data Systems, including SSIS, scripting languages, ETLs, and API integration and implementation.
• Knowledge of Single Sign-On (SSO) and current information technology practices and applications.
• Ability to design, test, and implement new technologies.
• Ability to streamline data collection from LEAs through more automated integrations.
• Ability to evaluate existing system processes and ETLs.
• Ability to review, analyze, and evaluate business systems, tools, and information needs with a focus on interoperability.

Technologies

• SQL, SQL Server, SQL Server Integration Services (SSIS)
• ETLs, API integration and implementation
• Single Sign-On (SSO)
• PowerBi and DAX
• Python and R
• Data warehouses and data lakes
• Data catalogs and metadata
• Illustrative visualizations
• Student Information Systems (SIS), Learning Management Systems (LMS), Instructional Management Systems (IMS), Learning Object Repositories (LOR)
• ESRI, GIS software, and geospatial data analysis

Preferred Qualifications

• Four (4) years of related work experience, including:
  • Experience working with educational data at the LEA or SEA level
  • Experience with Education Data Systems infrastructure components such as SIS, LMS, IMS, LOR, and related areas
  • Two (2) years of experience with SSIS
• Bachelor’s degree from an accredited college or university in information technology or computer science
• CompTIA Data+ certification
• Proficiency with data analysis languages such as Python or R
• Proficiency with ESRI or other GIS software and geospatial data analysis
• Proficiency with PowerBi or DAX

Supervisory Responsibilities

No supervisory responsibilities. May provide technical guidance or mentoring to peers or junior staff.

Compensation and Location

Location: Boise, ID (onsite). Pay: USD 33 - 35 per hour.

Benefits

• Medical, vision, and dental insurance benefits effective the first of the month following hire date; contributions can be pre-tax
• 11 paid holidays
• Paid sick and vacation that begins accruing on the first day of employment and can be used immediately after accruing (no waiting time)
• Paid parental leave
• Life insurance for self, spouse, and children
• Additional perks and discounts available through the medical provider
• Public Service Loan Forgiveness (PSLF) eligibility
• Employee assistance program
• Tuition reduction benefits
• Idaho Optional Retirement Plan (ORP) participation requirement for benefited and non-classified staff without previous credited service with PERSI
• Supplemental deferred compensation (457(b)) and 403(b) plans provided by the State Board of Education

Retirement plan information is available at: https://boardofed.idaho.gov/data-research/finance-administration/retirement-plans/

Additional Information

• Exempt from the rules of classified service under the provisions of Section 67-5303, Idaho Code.
• Educational IT exempt from overtime.
• Successful applicant will be required to pass a background check.
• Equal Employment Opportunity and reasonable accommodations are available; contact [phone] (TTY/TTD: 711) or email [e-mail] for accommodations requests.
• Preference may be given to veterans who qualify under applicable state and federal laws and regulations.