InsideTrack Senior Integration Engineer

Are you ready to apply your data and engineering skills to make a positive, measurable difference in people’s lives? Do you believe in the power of education? 

InsideTrack, widely recognized as one of the most innovative and mission-driven organizations in postsecondary student success, is looking for a talented Senior Integration Engineer to join our Solutions Team.

InsideTrack is a nonprofit organization that’s passionate about helping all learners achieve their education and career goals through the transformative power of coaching. Since 2001, we’ve served more than 3.5 million students, partnering with over 380 institutions and organizations to directly improve enrollment, persistence, completion and career readiness.

Our growing organization offers a culture that promotes diversity and inclusion, job fulfillment, personal growth, and work-life balance. Join us in our mission to expand our impact as we improve lives and create social change.

The Senior Integration Engineer will work directly with InsideTrack customers to integrate customer data from various systems into the InsideTrack coaching platform. As a technical thought leader, this role will involve mentorship of less senior staff on the data integration team and partnership with the Manager of Data Integration on developing technical solutions. They will be responsible for carefully documenting and tracking requirements, managing project scope, performing QA on customer-provided data, managing misalignment between customer data and standardized formats, and ensuring solutions are delivered within expected timelines. This role will be responsible for developing integration processes using primarily off the shelf integration tools, SQL, and SOQL. Balancing speed with maintainability, this role should manage manual processes to a minimum and look for automation opportunities. This role will require cross collaboration between external and internal stakeholders and as such will require the ability to discuss complex requirements with both technical and non-technical stakeholders.

Essential Job Functions:

• 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

Education Requirements:

• Minimum Bachelor’s Degree in business, computer science, or equivalent work experience

Required Skills:

• 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
• Basic skills in a scripting language such as JavaScript or Python is a plus
• 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

TRAVEL REQUIREMENTS:

Position may require travel up to 5% of time to attend client meetings with possibility of some overnight travel.

TYPICAL PHYSICAL & MENTAL DEMANDS:

Requires prolonged sitting with some bending, stooping and stretching; eye-hand coordination and manual dexterity sufficient to operate a keyboard, telephone, photocopier, calculator, and other office equipment. Requires normal range of hearing and eyesight to record, prepare and communicate appropriate reports. Also requires moderate to intense concentration due to complexity and/or need to meet deadlines, and flexibility to readily adapt to a changing environment.