Senior Data Engineer, Analytics

Who We Are

At Apptegy, we are more than a tech company; we are partners dedicated to transforming how schools communicate and shape the future of education. Your work here will directly empower districts to share their stories, engage their communities, and celebrate student success. We're a team of thoughtful, high-performing individuals committed to making a tangible impact. If you're looking for a dynamic environment where you'll be supported with exceptional mentorship and resources to grow your career, come build with us.

The Role

As a Senior Data Engineer at Apptegy, you’ll play a key role in shaping the architecture, performance, and scalability of our platform. This role is a unique hybrid that bridges traditional application development with data engineering. You will be responsible for building and scaling our analytics and data platform.

You will own the delivery of reliable, high-performing software and data systems, working primarily with our Ruby on Rails backend services, while building efficient data pipelines to transfer and transform data from PostgreSQL to Snowflake. This role is ideal for an engineer who thrives in a fast-paced environment and enjoys building systems from the ground up that provide meaningful, real-time insights to educators and students.

What You’ll Do

Technical Execution & Strategy

• System Architecture: Take responsibility for designing system architecture and scalable data models, ensuring scalability, security, and performance across the entire platform.
• Backend Development: Implement event-capture frameworks within our Ruby on Rails services (e.g., shared gems and event schemas).
• Pipeline Engineering: Design and build event-driven data pipelines specifically engineered for in-product analytics, ensuring data is cleaned, modeled, and optimized to power user-facing insights and reporting features.
• Process Optimization: Decompose large, complex tasks into manageable units of work to ensure efficient execution.
• Problem Solving: Proactively anticipate potential technical challenges before they arise and approach challenges with a solutions-focused mindset.
• Strategic Alignment: Collaborate with product managers and engineers to align technical and data efforts with business goals and long-term strategy.

Leadership & Collaboration

• Mentorship: Actively share knowledge of software and data engineering best practices and ensure quality standards are followed throughout the development cycle.
• Data Quality: Lead the development of unit and integration tests with quality gates to ensure both code reliability and the integrity of data served within the product.
• Collaboration: Work effectively within teams, valuing diverse perspectives and improving cross-team collaboration to manage timelines and resources effectively.
• Communication: Proactively share ideas, progress, and questions with stakeholders to ensure alignment, while clearly explaining complex technical decisions and their implications.

What You’ll Bring

Experience & Technical Skills

• Experience: 5+ years of professional software development experience, with a focus on backend services and engineering data for analytics.
• Backend Proficiency: Strong experience with Ruby on Rails or similar backend frameworks, with a focus on building scalable services.
• Data Pipeline Expertise: Proven experience designing and building data pipelines that process large datasets from relational databases to cloud data warehouses (e.g., PostgreSQL to Snowflake).
• SQL & Data Modeling: Deep understanding of SQL, data modeling, and schema design for both transactional and analytical workloads.
• Event-Driven Architecture: Experience implementing event-driven systems and capturing telemetry data for product analytics.
• Testing & Quality: Strong commitment to code quality, with experience writing unit and integration tests.