Senior IT Data Analyst: ETL, SQL & Dashboards (Boise)

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