INFORMATION TECHNOLOGY – DATA INTEGRATION SPECIALIST
QUALIFICATIONS:
- Multiple years of direct experience in enterprise-level data integrations.
- Proven experience in overseeing the linking of cross-functional databases between disparate business or educational units and systems.
- Strong experience writing SQL queries, stored procedures and triggers.
- Strong experience with database platforms, including Microsoft SQL, Oracle, MySQL, and Postgres.
- Maintain high standards of data quality through the introduction and enforcement of information handling processes and organization of the data integration processes.
- Hands on experience with technical requirements analysis, process modeling/mapping and methodology development, and data mapping.
- Strong knowledge of system and software quality assurance best practices methodology.
- Experience with data processing flowcharting techniques.
- Working technical experience with developing, installing, configuring and supporting database environments.
REPORTS TO: Executive Director of Technology
JOB GOAL: The Data Integration Specialist’s role is to model/map and execute all activities related to the integration of data across various sources into an organized and unified view. This individual is also responsible for the monitoring of data flow between databases, servers and Cloud services to identify and implement the most suitable DI architecture for the organization’s needs. Proven communication skills, problem-solving skills, and knowledge of integration best practices are critical to successful performance in this role. This is a highly technical position. A person with high attention to detail and a logical mindset with strong motivation and passion for technology would be a great candidate.
Employee must be able to relate to other people beyond giving and receiving instructions: (a) can get along with other co-workers or peers without exhibiting behavioral extremes; (b) respond appropriately to criticism.
All job requirements are subject to possible modifications. This job description in no way states or implies that these are the only duties to be performed by the employee occupying these positions. Employees will be required to follow any other job-related instructions and perform other job-related duties requested by their supervisor in compliance with Board Policies. Requirements are representative of minimum levels of knowledge, skills, and/or abilities to perform this job successfully; the employee must possess the abilities or aptitudes to perform each duty proficiently.
ESSENTIAL DUTIES AND RESPONSIBILITIES:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skills and abilities required. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.
- Work with leadership and developers to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion.
- Lead in data integrations with various systems that are utilized.
- Identify data entry, retrieval, change, and delete issues, and work to ensure a high level of data availability.
- Coordinate and work with other technical staff to develop relational databases and secondary databases.
- Identify inefficiencies in current data processes and leverage solutions.
- Install and configure relevant components to ensure secure and successful data integrations.
- Analyze user requirements and, based on findings, help design functional specifications for client/server databases and database applications.
- Other duties as required or assigned.
PHYSICAL DEMANDS: The individual who holds this position must be physically capable of lifting and carrying up to 50 pounds, bending, pushing, pulling, and reaching.
CONDITIONS AND ENVIRONMENT: The work environment is consistent with typical office/school environment.
TERMS OF EMPLOYMENT: Salary and work calendar to be established by the Board Of Education. Benefits according to Board policies.
FLSA: Exempt
RETIREMENT: Public Education Employee Retirement Systems (PEERS)
CLEARANCES: Criminal Justice Fingerprint/Background Clearance
EVALUATION: Performance of this job will be evaluated in accordance with provisions of the Board’s policy on evaluations utilizing the Performance Based Support Staff Evaluation process.