Senior IT Data Analyst: ETL, SQL & Dashboards

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

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