Data Integration Engineer

ParentSquare is a rapidly growing Santa Barbara-based company that’s changing the way schools and parents communicate every day. Sound simple? We strive to keep it that way! Our mission is to give schools the power to incredibly enhance family engagement for all students. ParentSquare and RemindHub, our flagship products, serve over 22 million students and drive our mission by providing unified communications tools -forms, sign ups, payments, RSVPs, direct messaging, language translations, chat and more. Remind Chat, our free product, reaches over 80% of K-12 students, providing a safe and easy-to-use platform for direct communication between teachers and families. And our latest innovation, SmartSites, offers state-of-the-art websites for school districts, enhancing their online presence and accessibility. 

We are not just creating a product; we are creating empowered educators and engaged parents to improve the lives of all students.  We are passionate advocates for our  customers and for our employees and we invite you to join us on this exciting journey.

We are searching for a Data Integration Engineer to play a critical role in navigating complex integration related needs, from initial client onboarding to the daily platform usage of existing clients. This role will have a direct impact on our users and our internal teams by devising and executing sophisticated technical data solutions.

As a Data Integration Engineer, you will be expected to provide technical guidance, drive process improvements, and take solve for highly complex issues and projects. Given the nature of our work, this role requires strong project management skills as well as strong development skills to help guide the team's direction and maximize our impact.

This is a high-volume, high-impact role where you will impact the event lifecycle from research to ROI analysis.

This role requires a blend of advanced technical execution, product prioritization, and team mentorship.

• Analyze, debug, and resolve tickets and data discrepancies, acting as the team's escalation point and determining root causes for systemic failures.
• Write, review, and execute detailed action plans for major data operations. You will be responsible for providing thorough code review and guidance on coding best practices for teammates, ensuring high standards for system reliability and performance.
• Develop and maintain deep expertise in the technical specifications of SISes and third-party systems. Set up and troubleshoot complex Single Sign-on (SSO) integrations.
• Lead the development of complex internal applications using Retool to streamline team workflows, and provide expert guidance to teammates on application creation and best practices.

• Support in the prioritization of the team's backlog of ad hoc work and bugs. You will work with internal stakeholders to prioritize incoming tickets and feature requests, ensuring the team is focused on the highest-value, highest-impact work.
• Lead and own the delivery of large-scale data integration projects in tools such as Retool, from end-to-end. Provide technical oversight, break down complex tasks, and manage project uncertainties.

• 2-3+ years of professional experience as a Data Engineer, Software Engineer, or similar role.
• Expert proficiency in SQL for complex querying, stored procedures, performance tuning, and deep data analysis.
• Strong hands-on experience with Ruby and Ruby-on-Rails is highly preferred for development and system analysis.
• Excellent communication skills (written, verbal, presentation, and interpersonal).
• Experience with version control using Git.
• Experience with commonly used AWS services, like S3 and RDS.
• Experience with working in the K12 Education environment and hands-on experience with Student Information systems (SISes) is highly desired. 

At ParentSquare, we believe in winning together and building a product that truly serves schools, educators, and families. We value transparency, collaboration, and an entrepreneurial spirit, and we look for team members who share these values. You’ll have the opportunity to lead design at scale, influence a fast-growing company, and make a meaningful impact on K-12 education.

The perks of working for us are great! You’ll get your foot in the door as our company continues to grow. We’re big believers in work-life balance and provide:

• Employer-paid health insurance (including dependent coverage)
• An employer-matched 401K retirement savings program from day 1 
• Paid Parental Leave
• Stock options
• Health + wellness reimbursements
• Generous PTO 
• 15 paid holidays, including your birthday! 

As a fully remote team, we’ll make sure you have all the tools and equipment you need to make your home office a place where you can thrive. 

We're an equal-opportunity employer. All applicants will be considered for employment without attention to age, race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.

The salary range for this role will be $75,000-$95,000 (DOE)