Data Integration Engineer

PRIMARY PURPOSE: The Data Integration Engineer will serve as the point-of-contact and provider of district-level technology support for data imports, management, and exports using SQL Server, MS Access, Microsoft Excel, Google Sheets, and various file transfer protocols. The Data Integration Engineer will provide database services to the district staff using student and staff databases from various applications providing the proper conversion techniques in a timely manner. The position is the Clever district administrator, providing support for the data in the Clever portal and its supported/related applications. The Data Integration Engineer is the champion of securing district data., * Create, maintain and optimize Microsoft Access databases.

• Maintain, update, and administer access for database servers, applications, and data, including imports and exports.
• Maintain, update, and administer access for Microsoft, Cerberus, WinSCP, and other FTP servers, FTP applications, and data, including data transfers in and out of the District.
• Provide timely data services to the Curriculum Department in a manner that meets all TEA and assessment deadlines with time to spare.
• Design and implement processes and procedures to reduce and eliminate database outages and downtime.
• Implement data backup and recovery procedures to prevent the loss of data from all types of failure.
• To document, plan and test disaster recovery (DR) procedures.
• Design, implement, and maintain database security strategies that provide the appropriate level of security for users and applications.
• Develop and maintain an annual calendar of submissions to facilitate advanced planning.
• Document all filters, queries, and conversions developed. Store copies of documentation and converters in multiple locations.
• Assist the district and campus assessment staff in extracting data from the district’s applications in a timely manner for adjusting instruction.
• Be on call for all district staff needing database services using the priorities given by the Director of Technology.
• Support technicians with the data components of their duties.
• Assist, monitor, and train data staff with user creation, update, deletion, and management services to the district staff.
• Monitor and maintain the district’s user databases, including integration/synchronization with active directory, google, and more in collaboration with the Server and Network team members.
• Provide support with applications in Eduphoria, including managing permissions, issues with uploads, troubleshooting, etc.
• Maintain skill and knowledge levels on the latest releases of all of the district’s databases, plus related servers, software, and applications.
• Attend and study materials and resources provided by the district in a timely manner and pass the related certification examinations to keep certifications updated to the latest versions as directed by the Technology Director.
• Create and continuously update a plan for training related to current and future data needs.
• Collaborate with vendors in a timely and transparent manner as approved by the Director of Technology.
• Document database activities, configurations, and procedures regularly with copies in multiple locations and in a manner that can be used easily by other staff.
• To organize, review and negotiate data sharing and privacy agreements (DPA/DSA’s) with partners and vendors.
• Assist other technicians as needed or when caught up on work orders, including serving as a mentor and assisting with managing the IT shop.
• Maintain confidentiality of student and staff information.
• Complete work as indicated by the Director of Technology or the ticket priority, in that order.
• Other duties as assigned.

Bachelor’s Degree or higher required

Clever Administrator Certification

Extensive training in Google Workspace and Microsoft Office with emphasis on MS Access, MS Excel, and Google Sheets.

Special Knowledge/Skills:

Experience using Microsoft Access with advanced queries required

Experience building and maintaining Microsoft Access applications with Switchboard required

Experience using Microsoft Access with online and offline ODBC database required

Experience with batch files, PowerShell, Google Meet, Jabber, and advanced data query functionality in Google Sheets preferred

Advanced knowledge of computer technology used in school settings, including data gathering, export, and analysis required

Superior organizational, communication, and interpersonal skills

EQUIPMENT USED: Personal computer equipment, service tools, technology websites, motor vehicles, and phone

WORKING CONDITIONS: Mental Demands/Physical Demands/Environmental Factors: Maintain emotional control under stress; work with frequent interruptions. Frequent standing, stooping, bending, kneeling, pushing, and pulling, carrying and running. Frequent light lifting and carrying (less than 15 pounds); occasional heavy lifting (45 pounds or over) and lifting and moving equipment. Work inside and outside (exposure to sun, heat, and inclement weather); exposure to noise; exposure to biological hazards. Frequent use of small hand tools and electronic test equipment; Frequent district-wide travel. Regular occasions of prolonged and irregular hours. Normal classroom/office environments, and work around electrical energy.