Senior Integration Engineer

Summary

Join InsideTrack, a leading nonprofit in postsecondary student success, as a Senior Integration Engineer. You will integrate customer data into our coaching platform, mentor junior staff, and collaborate with clients. This role requires expertise in data integration tools (like SnapLogic), SQL/SOQL, and ETL processes. You'll be responsible for data quality, documentation, and project management. InsideTrack offers a fulfilling work environment and a competitive salary and benefits package. The position involves working directly with clients, requiring excellent communication and problem-solving skills. Apply your skills to make a positive impact on student lives.

Requirements

• Minimum Bachelor’s Degree in business, computer science, or equivalent work experience
• 5 years of directly related work experience with demonstrated knowledge and ability to utilize the appropriate technology platform
• Exposure to one or more ETL tools and an understanding of ETL pipelines
• A working understanding of SnapLogic and other low-code/no-code integration tools and an interest in maintaining low-code/no-code tools
• Experience in the development of technology based solutions including understanding of data integrations, analytics, software services
• Excellent presentation and communication skills working with various levels of client and internal stakeholders in both technical and non-technical roles and the ability to effectively communicate to all levels adjusting communications according to the technical knowledge and skills of the audience
• Experience with SFTP tools
• Experience working with higher ed institutions through lead conversion, and student retention, and/or experience in consulting
• Proven experience in gathering requirements and thoroughly testing ETL pipelines
• Care deeply about data quality and governance
• Self-starter; demonstrated ability to meet deadlines, handle and prioritize simultaneous requests, and manage laterally and upward with a positive attitude
• Strong SQL and/or SOQL skills
• Ability to cultivate strong interpersonal customer and co-worker relationships and work effectively cross functionally
• Ability to handle ambiguity and keen problem solving skills
• Ability to read and interpret complex information, talk with customers and listen attentively
• Ability to work in a fast-paced environment
• Ability to respond well under pressure
• Ability to apply best practices for effective communication and problem solving
• Excellent written and verbal communication including the ability to write technical documentation
• Must protect the confidentiality of student personal information and comply with Family Educational Rights and Privacy Act (FERPA)
• Must comply with all company procedures and policies, including company privacy and security policies

Responsibilities

• Develop integration automation processes using SnapLogic, a low code data integration tool
• Provide mentorship and support to other engineers and analysts on the Data Integration and broader Data, Platform, and Analytics teams, including coaching/direct mentorship, pull request reviews and collaboration on technical solutions
• Act as the data liaison with our client partners; provide a clear, consultative approach when working with client partners, communicating best practices to achieve client goals
• Create and support various ETL scripts, jobs, and technologies
• Manage the design, architecture, and development of our data pipelines
• Consult with other members of the Data, Platform, and Analytics team on technical solutions to meet client data integration needs
• Gather and document customer requirements for program data integration needs
• Own and develop relationships with client partner data contacts, working with them to optimize and enhance our integration
• Provide support and triage for issues related to customer data integration
• Validate quality of client data through QA processes
• Document and maintain integration specification documentation for all clients
• Maintain code in GitHub repository
• Partner directly with customers to ensure best practices, and compliance with standardized formats are followed for program success
• Assess customer readiness for data integrations and provide guidance for program implementation and additional scope beyond standard implementation specifications
• Manage workload and raise issues around inability to meet deadlines
• Provide feedback on business processes and areas of process improvement
• Report on common sources of technical issues or questions and make recommendations to the product team
• Collaborate effectively and cooperatively with stakeholders, co-workers, vendors, and leadership to create new ideas for solutions that solve internal business challenges
• Constantly be on the lookout for ways to improve monitoring, discover issues, and deliver better value to our client partners
• Perform related duties as requested

Preferred Qualifications

Basic skills in a scripting language such as JavaScript or Python is a plus

Benefits

• $105,000 - $117,500 a year
• Comprehensive employee benefit package
• Position may require travel up to 5% of time to attend client meetings with possibility of some overnight travel