Senior Data Engineer, Analytics at Apptegy

<div class="content-intro"><h3 class="paragraph heading3 ng-star-inserted" data-start-index="32"><strong><span class="ng-star-inserted" data-start-index="32">Who We Are</span></strong></h3> <div class="paragraph normal ng-star-inserted" data-start-index="43"><span class="ng-star-inserted" data-start-index="43">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.</span></div></div><h3><strong>The Role</strong></h3> <p>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.</p> <p>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.</p> <h3><strong>What You’ll Do</strong></h3> <h4><strong>Technical Execution &amp; Strategy</strong></h4> <ul> <li><strong>System Architecture:</strong> Take responsibility for designing system architecture and scalable data models, ensuring scalability, security, and performance across the entire platform.</li> <li><strong>Backend Development:</strong> Implement event-capture frameworks within our Ruby on Rails services (e.g., shared gems and event schemas).</li> <li><strong>Pipeline Engineering:</strong> 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.</li> <li><strong>Process Optimization:</strong> Decompose large, complex tasks into manageable units of work to ensure efficient execution.</li> <li><strong>Problem Solving:</strong> Proactively anticipate potential technical challenges before they arise and approach challenges with a solutions-focused mindset.</li> <li><strong>Strategic Alignment:</strong> Collaborate with product managers and engineers to align technical and data efforts with business goals and long-term strategy.</li> </ul> <h4><strong>Leadership &amp; Collaboration</strong></h4> <ul> <li><strong>Mentorship:</strong> Actively share knowledge of software and data engineering best practices and ensure quality standards are followed throughout the development cycle.</li> <li><strong>Data Quality:</strong> 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.</li> <li><strong>Collaboration:</strong> Work effectively within teams, valuing diverse perspectives and improving cross-team collaboration to manage timelines and resources effectively.</li> <li><strong>Communication:</strong> Proactively share ideas, progress, and questions with stakeholders to ensure alignment, while clearly explaining complex technical decisions and their implications.</li> </ul> <h3><strong>What You’ll Bring</strong></h3> <h4><strong>Experience &amp; Technical Skills</strong></h4> <ul> <li><strong>Experience:</strong> 5+ years of professional software development experience, with a focus on backend services and engineering data for analytics.</li> <li><strong>Backend Proficiency:</strong> Strong experience building backend systems (Ruby on Rails, Python, or similar).</li> <li><strong>Data Engineering:</strong> Deep experience with SQL, data modeling, and building scalable, reliable event-driven data pipelines using a medallion architecture (bronze/silver/gold layers).&nbsp;</li> <li><strong>System Design:</strong> Experience designing and building scalable, high-performance systems.</li> <li><strong>Process:</strong> Mastery with Scrum processes and a track record of effectively prioritizing tasks to meet deadlines and project goals.</li> </ul> <p>&nbsp;</p> <h4><strong>Behavioral Competencies</strong></h4> <ul> <li><strong>Ownership:</strong> Demonstrates accountability by taking full responsibility for systems and proactively addressing obstacles.</li> <li><strong>Adaptability &amp; Curiosity:</strong> Adjusts smoothly to new tools and evolving requirements while seeking to learn new technologies.</li> <li><strong>Analytical Problem Solving:</strong> Approaches complex data and software needs with a solutions-focused mindset and possesses excellent debugging skills.</li> </ul> <h3><strong>What Makes You Stand Out</strong></h3> <ul> <li><strong>Cloud Platforms:</strong> Experience with AWS; relevant certifications (AWS Certified Solutions Architect Associate, AWS Certified Data Engineer) are a plus</li> <li><strong>Database Technologies:</strong> Experience with database technologies (e.g., RDS/Aurora PostgreSQL, Snowflake).&nbsp; Experience replicating data via Change Data Capture (CDC) from PostgreSQL to Snowflake.</li> <li><strong>Semantic Layers:</strong> Familiarity with Semantic reporting layers and headless BI frameworks (e.g., Cube.dev) to support consistent, scalable in-product analytics.</li> <li><strong>DevOps &amp; Infrastructure:</strong> Knowledge of DevOps practices and tools (e.g., Terraform, CI/CD, Docker, Kubernetes).</li> <li><strong>AI-Enhanced Development &amp; Testing:</strong> Proficiency in leveraging AI coding assistants (e.g., Cursor, Claude Code) to accelerate code generation, refactoring, and the development of robust unit and integration tests across the full stack (Vue.js, Ruby on Rails).</li> <li><strong>Industry Experience:</strong> Experience in the education technology sector.</li> </ul><div class="content-conclusion"><h3 class="paragraph heading3 ng-star-inserted" data-start-index="1841"><strong><span class="ng-star-inserted" data-start-index="1841">Why Apptegy</span></strong></h3> <div class="paragraph normal ng-star-inserted" data-start-index="2151"><span class="ng-star-inserted" data-start-index="2151">Join a team that’s committed to your success. At Apptegy, we’re passionate about creating an environment where you can do your best work and find true fulfillment. We believe in investing in our people—both professionally and personally—because your well-being drives our collective impact.</span></div> <div class="paragraph normal ng-star-inserted" data-start-index="2151">&nbsp;</div> <div class="paragraph normal ng-star-inserted" data-start-index="2151">US Employee Benefits:&nbsp;</div> <div class="paragraph normal ng-star-inserted" data-start-index="2442"><span class="ng-star-inserted" data-start-index="2442">Comprehensive medical, dental, vision, and life insurance coverage</span></div> <div class="paragraph normal ng-star-inserted" data-start-index="2510"><span class="ng-star-inserted" data-start-index="2510">Retirement 401(k) with employer match</span></div> <div class="paragraph normal ng-star-inserted" data-start-index="2549"><span class="ng-star-inserted" data-start-index="2549">Health Savings Accounts (HSA) and Flexible Spending Accounts (FSAs)</span></div> <div class="paragraph normal ng-star-inserted" data-start-index="2618"><span class="ng-star-inserted" data-start-index="2618">Mental Health Reimbursement</span></div> <div class="paragraph normal ng-star-inserted" data-start-index="2647"><span class="ng-star-inserted" data-start-index="2647">Unlimited paid time off, including seasonal (December) company-wide time off</span></div> <div class="paragraph normal ng-star-inserted" data-start-index="2725"><span class="ng-star-inserted" data-start-index="2725">Paid parental and medical leave</span></div> <div class="paragraph normal ng-star-inserted" data-start-index="2758">&nbsp;</div> <div class="paragraph normal ng-star-inserted" data-start-index="2758">MX Employee Benefits:</div> <div class="paragraph normal ng-star-inserted" data-start-index="2758">Private medical insurance for you and your dependents<br>Life insurance<br>15 days Aguinaldo<br>Vales de Despensa<br>Fondo de Ahorro<br>Caja de Ahorro<br>Flexible paid time off policy<br>Paid travel to/from Little Rock, Arkansas for Onboarding.</div> <div class="paragraph heading3 ng-star-inserted" data-start-index="2759">&nbsp;</div> <div class="paragraph normal ng-star-inserted" data-start-index="2760"><span class="ng-star-inserted" data-start-index="2760">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.</span></div> <div class="paragraph normal ng-star-inserted" data-start-index="3135">&nbsp;</div> <div class="paragraph heading3 ng-star-inserted" data-start-index="3136"><span class="ng-star-inserted" data-start-index="3136">Equal Opportunity Employer</span></div> <div class="paragraph normal ng-star-inserted" data-start-index="3163"><span class="ng-star-inserted" data-start-index="3163">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.</span></div></div>