Data Integration Specialist- Information Services

ReNEW Schools; Nampa (ID); Hybrid; USD 60,000 - 90,000; Full time

Job summary

ReNEW Schools in Idaho seeks an Information Services Data Integration Specialist to roster district apps, maintain queries, reports, and data extracts, and support state and federal reporting.

You will work with SQL and Microsoft applications, collaborate with stakeholders, train others, and uphold data integrity across platforms.

Qualifications

• High School Diploma required.
• One to two years of related data quality experience or equivalent combination of education and experience required.
• Experience with Microsoft Applications required.
• Knowledge and experience of SQL(intermediate level) required.
• Experience with R, SQL, Python preferred.

Responsibilities

• Roster all district apps using SQL and perform IT admin tasks for systems such as PowerSchool, Traversa, ParentSquare, Mosaic, and Classlink.
• Create and maintain SQL queries to build reports upon request.
• Create and maintain data extracts to feed data to other education systems.
• Develop, maintain, and update scripts for vendor systems and staff requests.
• Review and request copies of vendor documentation to ensure data security.
• Collaborate with stakeholders and provide excellent customer service.

Skills

SQL

R

Python

Microsoft Applications

Data quality

Data reporting

Education

High School Diploma

1–2 years data quality experience

Microsoft Applications experience

SQL (intermediate)

Experience with R, SQL, Python preferred

Tools

PowerSchool

Traversa

ParentSquare

Mosaic

Classlink

Job description

Position: Information Services Data Integration Specialist

Category: Classified Exempt

Location: Technology Center

Reports to: Educational Systems Supervisor

SUMMARY:

This position primarily rosters all district apps, supports district-wide data systems by maintaining queries, reports, and data extracts, while serving as the primary point of contact for multiple educational applications and assisting with state and federal reporting. Strong technical skills in SQL and Microsoft applications, experience with data systems, and the ability to collaborate, train others, and uphold data integrity across platforms are essential.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Responsible for rostering of all apps using SQL as well-being as being an IT admin in systems including PowerSchool, Traversa, ParentSquare, Mosaic, and Classlink
• Responsible for creation and maintenance of SQL queries created to build reports when requested
• Responsible for creation and maintenance of extracts to feed data to other education systems
• Responsible for creation, maintenance and updating scripts for vendors systems and staff requests
• Responsible for reviewing and requesting copies of vendor documentation to ensure data security
• Working, understanding, and seeking clarification of appropriate data sharing
• Collaborate and provide excellent customer service while meeting with all stakeholders
• Perform light server maintenance tasks relative to the role, including basic troubleshooting and routine updates
• Assist with state and federal reporting
• Assist with support and training on Business Intelligence toolset(s)
• Serve as the primary point of contact for applicable NSD applications/systems and is responsible for the upkeep of those applications/systems
• Collaborate with the Microsoft Specialist for Teams and group hygiene management
• Assist with Data Retention in applicable systems
• Responsible for processing the Monthly Enrollment Report for Board Meetings
• Representative/advocate of data team
• Assume responsibility for his or her continuing professional growth and development by attendance at professional meetings, membership in professional organizations, enrollment in advanced courses, and by reading professional journals and other publications
• Seek assistance should emergencies arise
• Represent the school district in a positive manner
• Know and follow school district policy and chain of command
• Perform other duties as assigned

SUPERVISORY RESPONSIBILITIES:

None.

QUALIFICATION REQUIREMENTS:

To perform the job successfully, an individual must be able to perform each essential duty listed above, satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the job.

EDUCATION AND/OR EXPERIENCE:

• High School Diploma required
• One to two years of related data quality experience or equivalent combination of education and experience required
• Experience with Microsoft Applications required
• Knowledge and experience of SQL(intermediate level) required
• Experience with R, SQL, Python preferred

KNOWLEDGE, SKILLS, & ABILITIES

• Experience with SQL for creating queries
• Ability to maintain and create automation using R or Python
• Strong positive customer service experience
• Ability to create process documentation and maintain change log
• Collaborate and seek understanding of existing scripts, processes and procedures
• Proficiency in system analysis to become familiar with systems and applications for generating reports upon request
• Ability to process help tickets in a timely manner
• Excellent organizational and interpersonal skills
• Excellent verbal and written communication skills
• Able to maintain a positive environment and high standards of conduct with stakeholders and peers
• Able to work under pressure and meet deadlines
• Maintain confidentiality of staff and students
• Ability to work effectively as a team member
• Skilled in the use of internet, email, Microsoft Suite
• Capable of interpreting policy, procedures, and data
• Ability to listen to others and remain receptive to new ideas
• Willingness and ability to create a team-oriented atmosphere within the workplace

COMMUNICATION SKILLS:

Ability to write routine reports and correspondence. Ability to read and interpret documents such as safety rules, operations and maintenance instructions, and procedure manuals. Ability to speak effectively before groups of employees of the district.

PROBLEM SOLVING SKILLS:

Demonstrates ability to diagnose and resolve data quality issues.

PRODUCTIVITY/EFFICIENCY SKILLS:

Consistently demonstrate ability to respond to changing situations in a flexible manner in order to meet current needs, such as reprioritizing work as necessary,organize job functions and work area to be able to effectively complete varied assignments within established time frame.

MATHEMATICAL SKILLS:

Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Able to conduct basic math functions and manipulate formulas in spreadsheets as needed.

REASONING ABILITY:

Ability to apply common sense understanding to carry out instructions furnished in written, oral and diagram form. Ability to identify problems, collect data, define end user needs and determine if information can be provided and notify of intent.Provide appropriate data upon request.

PHYSICAL DEMANDS:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is continuously required to sit, walk, stand and reach with hands and arms, occasionally lift and carry up to 20 pounds. Specific vision abilities required by this job includes close vision, very good depth perception, and the ability to communicate through speech.

WORK ENVIRONMENT:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.Reasonable accommodations may be made to enable individual’s disabilities to perform the essential functions.

While performing the duties of this job, the employee regularly works inside and occasionally meets deadlines with severe time constraints which may include time outside of scheduled office hours.

TERMS OF EMPLOYMENT

248 day calendar assignment.

I hereby understand and acknowledge that any employment relationship with the District is of an “at-will” nature, which means that the Employee may resign at any time and the Employer may discharge the Employee at any time with or without cause.It is further understood that the nature of this “at-will” employment relationship may not be changed by an act unless such change is specifically acknowledged in writing by the Board of Trustees.

Nampa School District #131 is an equal opportunity employer/educator with an alcohol, drug and tobacco free environment, and does not unlawfully discriminate in employment.Equal access to employment, services, and programs is available to all persons.Those applicants requiring reasonable accommodations to the application and/or interview process should notify a representative of the organization.The information contained in this job posting is for compliance with the Americans with Disabilities Act (A.D.A.) and is not an exhaustive list of the duties performed for this position. Additional duties are performed by the individuals currently holding this position and additional duties may be assigned. The employment relationship with the District is of an “at will” nature, which means that the Employee may resign at any time and the Employer may discharge the Employee at any time with or without cause.