Data Integration Engineer

ParentSquare, Inc.; Northern (KY); Hybrid; USD 75,000 - 95,000; Full time

Benefits offered by this job

401K with company match

Stock options

Health & wellness reimbursements

Generous PTO

15 paid holidays including your生日

Job summary

ParentSquare, Inc. is seeking a Senior Data Integration Engineer to drive complex data solutions from client onboarding to daily platform usage. You will provide technical leadership, guide data operations, and own cross-team collaboration to maximize impact.

Expected to lead Retool-based internal apps, mentor teammates, and shape the integration roadmap with strong SQL, Ruby on Rails, and SSO/SIS experience.

Qualifications

• 2-3+ years of professional experience as a Data Engineer, Software Engineer, or similar role.
• Expert proficiency in SQL for complex querying and data analysis.
• Strong hands-on experience with Ruby and Ruby on Rails.
• Experience with AWS services (S3, RDS).
• Experience with K-12 education environment and SISes is highly desired.

Responsibilities

• Analyze, debug, and resolve tickets and data discrepancies; identify root causes.
• Lead code reviews and provide guidance on coding best practices.
• Develop expertise in SIS specifications and SSO integrations.
• Lead development of internal applications using Retool to streamline workflows.
• Support backlog prioritization with stakeholders and focus on high-value work.
• Lead end-to-end large-scale data integration projects using Retool.

Skills

SQL

Ruby on Rails

Data integration

Communication

Git

AWS (S3, RDS)

K-12 SIS experience

Tools

Retool

Job description

ParentSquare is a rapidly growing Santa Barbara-based company that is 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.

Who we are looking for:

We are searching for a Data I ntegration 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 Senior Integration Engineer, you will be expected to provide technical leadership , drive process improvements , and take ownership of 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 role will include:

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.

Technical Execution & Expertise

• 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.

What You Will Bring:

• 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.

Why Join Us?

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 will 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 will get your foot in the door as our company continues to grow. We are big believers in work-life balance and provide:

• An employer-matched 401K retirement savings program from day 1
• Stock options
• Health + wellness reimbursements
• Generous PTO
• 15 paid holidays, including your birthday!

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

We are 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)