Staff Data Engineer

About Apptegy: Empowering Schools Through Innovative Communication

Apptegy is a leading technology partner dedicated to revolutionizing communication for K-12 school districts across the nation. We go beyond providing tools; we offer comprehensive solutions that empower schools to build stronger brands, connect effectively with their communities, and gain valuable insights into their audiences. Our dedication to client success is unwavering, and our passion for education drives us to deliver exceptional support with rapid response times.

As an employer, Apptegy cultivates a dynamic and collaborative environment where individuals are valued for their thoughtfulness, innovation, and high performance. We invest in our employees by providing them with the tools, mentorship, and resources they need to succeed. We believe that empowering our people is key to our collective growth and positive impact on the education landscape.

Why Join Apptegy as a Staff Data Engineer?

Imagine shaping the future of data strategy and infrastructure – not just building features. As a Staff Data Engineer at Apptegy, you’ll have the unique opportunity to design and implement scalable, resilient data solutions that directly enhance user experiences across our product suite. You will be a core member in our push to build out data insights that allow schools to better communicate with their students, parents, and staff.

Collaborate with a talented and growing team of Staff+ engineers, contributing to the overall technical vision that guides our entire organization. This role is perfect for someone who thrives on tackling complex challenges at the intersection of product, engineering, and analytics.

As a senior mentor, you’ll guide fellow engineers, champion data engineering best practices, and bring your strategic vision for data architecture to life. If you’re passionate about making a lasting impact, influencing technical direction at scale, and expanding both your mentorship and technical expertise, we encourage you to apply!

Your Impact as a Staff Data Engineer at Apptegy

Key Responsibilities

• Lead the Modernization of our Data Platform: Spearhead the design, implementation, and maintenance of our data platform, architecting a robust and scalable solution that seamlessly integrates real-time and batch workloads.
• Own End-to-End Data Pipeline Architecture: Oversee the architecture and development of comprehensive data pipelines, from ingesting diverse data from various Student Information System (SIS) partners to ensuring data hygiene, performing entity resolution, and distributing processed data to downstream systems.
• Establish a Single Source of Truth: Define and maintain a single source of truth for all core data entities (e.g., Students, Staff, Guardians) and develop a synchronization strategy to ensure data integrity and consistency across all Apptegy products and services.
• Enforce Data Quality and Governance: Define and enforce data quality, security, privacy, and governance standards, implementing automated data profiling, cleansing, and validation processes to ensure the accuracy, completeness, and timeliness of our data.
• Mentor and Empower the Engineering Unit: Act as a technical mentor and a force multiplier for the engineering unit, setting best practices and technical standards for data engineering, modeling, and pipeline development.
• Collaborate with Cross-Functional Teams: Partner with product, engineering, and customer success teams to understand business requirements and translate them into scalable data solutions and accessible data assets.

What We’re Looking For in Our Ideal Candidate

Essential Skills & Experience

• Bachelor’s or Master’s degree in Computer Science, Statistics, Informatics, Information Systems, or a related quantitative field, or equivalent experience.
• 8+ years of experience in software engineering or data engineering, with at least 3 years in a senior or staff-level role.
• Proven experience at the Staff or Principal level in a data engineering or related technical role. Demonstrated success in designing and implementing complex, end-to-end data platforms.
• Expertise in Python, SQL, and other relevant languages for data manipulation and automation.
• Experience with data streaming frameworks such as Kafka and Kinesis to provide realtime data ingestion and distribution.
• Strong knowledge of data architecture, data modeling, data warehousing and entity resolution concepts.
• Extensive hands-on experience designing and building complex data pipelines and ETL/ELT processes for various data types and volumes for both analytical and operational systems.
• Expertise in designing and implementing complex data distribution and synchronization strategies across loosely coupled services or microservices architectures.
• Demonstrated ability to lead technical conversations and collaborate with various stakeholders.
• Exceptional problem-solving skills and a proactive, analytical mindset.

Bonus Points: What Makes You Stand Out

• Prior experience with K-12 district and school data systems, particularly Student Information Systems (SIS), such as PowerSchool, Infinite Campus, or Skyward.
• Experience in the B2B SaaS industry.
• Experience with AirFlow and DBT.
• Familiarity with event-driven architectures and messaging services.
• Familiarity with AWS cloud services relevant to data engineering (e.g., EC2, RDS, Aurora Serverless, SQS, Lambda).
• Familiarity with Snowflake
• Proficiency or at least exposure to Ruby on Rails
• Familiarity with data pipeline, workflow management, and ETL tools like CloverDX
• Contributions to open-source data projects or engineering communities.

Why Choose Apptegy? Benefits & Perks

At Apptegy, we’re deeply committed to creating an environment where you can thrive. We strive to make this a truly impactful and rewarding role, equipping you with experiences that propel your future success. We believe in fostering well-being both at work and at home, which is why we provide:

• Comprehensive medical, dental, vision, and life insurance coverage
• Retirement 401(k) with employer match
• Health Savings Accounts (HSA) and Flexible Spending Accounts (FSAs)
• Mental Health Reimbursement
• Unlimited paid time off
• Company-wide Winter Break
• Paid parental and medical leave

Apptegy champions the thoughtful integration of AI to empower our teams and processes. As we seek to understand your individual capabilities and how you might contribute, we ask that all responses to application questions and during interviews are genuinely your own. Please refrain from using AI generation tools, as our aim is to assess your authentic voice and expertise.

Apptegy is an equal-opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, age, protected veteran or disabled status, or genetic information.