IT Data Analyst Senior

State of Idaho
Boise, ID, United States
9 days ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
2 years minimum
Compensation
$70,512 - $73,840
Working hours
Regular working hours
Job source

Tech stack

Geographic Information Systems Data Analysis Business Systems Databases Learning Management Systems Data Files Extract Transform Load (ETL) Data Presentation Data Systems Data Warehousing Database Queries Decision Support Systems
+19 more
Interoperability Python (Programming Language) Metadata Power BI Software Tools Standard Sql Student Information Systems Single Sign-On SQL Databases SQL Server Integration Services Esri GIS (Software) Data Processing Scripting Data Lakes Information Technology Comptia Data+ Data Pipelines Api Management Programming Languages

Job description

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

Requirements

The selected individual will be working in a team environment under minimal supervision, with considerable latitude for the use of initiative and independent judgement., * 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

Benefits & conditions

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)
  • Paid parental leave
  • Life insurance for self, spouse, and children
  • Additional perks and discounts available through medical provider
  • Public Service Loan Forgiveness (PSLF) Eligibility
  • Employee assistance program
  • Tuition reduction benefits

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Loading talks and stories from around this role…