Data Integration Engineer

Summary

ParentSquare is a company providing communication and engagement tools for schools, educators, and families. The Data Integration Engineer will develop and manage complex data integrations, resolve technical issues, provide coding guidance, and lead large-scale integration projects while supporting backlog prioritization and team mentorship.

Responsibilities

• 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

Skills

• 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
• 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
• Strong hands-on experience with Ruby and Ruby-on-Rails is highly preferred for development and system analysis

Qualifications

Must Haves

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

Nice to Haves

• Strong hands-on experience with Ruby and Ruby-on-Rails is highly preferred for development and system analysis

Benefits

• 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!
• Fully remote work arrangement
• All the tools and equipment you need to make your home office a place where you can thrive