Data Engineer II

<div class="content-intro"><p><strong>About Us</strong></p> <p>InStride Health’s mission is to deliver specialty anxiety and OCD care that works for every kid, teen, young adult, and family who needs it. Through this mission, we are expanding access to insurance-based care, increasing engagement in treatment, and improving treatment outcomes. We are doing this by combining research-backed clinical care and innovative technology to eliminate the major problems with care today: difficulty finding providers, months of waiting to be seen, arduous onboarding processes, and inconsistent use of evidence-based therapies and outcomes tracking. Our vision is to become the nation’s most trusted provider of pediatric anxiety and OCD care.</p> <p><strong>Team</strong><strong> </strong><strong>InStride Health: Our Core Values</strong></p> <ul> <li><strong>Give Heart</strong>: We lead with heart, treating patients and their families the way we want our loved ones to be treated. </li> <li><strong>Work Smart</strong>: We find smarter ways to solve hard problems and fix the broken mental health system by leveraging technology, diversity of thought, and innovation.</li> <li><strong>Have Humility</strong>: We leave our egos at the door, empowering our team to collaborate, celebrate diversity, and adopt a growth mindset.</li> <li><strong>Embrace Community: </strong>We all belong. We are in this together, and we never worry alone. We believe in each other and recognize that every voice matters.</li> </ul></div><p><strong>About the Role</strong></p> <p>We are looking for a Data Engineer II to help design, build, and maintain the scalable data infrastructure that powers clinical and operational decision-making across InStride. In this role, you will develop and own reliable ETL/ELT pipelines, contribute to our data warehouse architecture, and partner closely with our analytics and business intelligence teams to ensure high-quality, trusted data reaches every corner of the business. This is a high-impact, hands-on engineering role for someone who takes pride in building systems that are not just functional, but resilient, observable, and built to scale. This role reports to the Director of Data Engineering and is a fully remote position.</p> <p><strong>Responsibilities:</strong></p> <ul> <li>Design, develop, and maintain robust, scalable ETL/ELT data pipelines using Python, SQL, and data processing frameworks including dbt, Matillion, and AWS services.</li> <li>Implement data quality checks, monitoring, and alerting across all data pipelines to ensure data integrity and reliability.</li> <li>Optimize existing pipelines for performance, cost-efficiency, and error handling.</li> <li>Contribute to the design and maintenance of InStride’s data warehouse and data lake solutions, including schema design, data modeling, and indexing strategies in Amazon Redshift.</li> <li>Ensure data security, HIPAA compliance, and proper handling of protected health information (PHI) within all data infrastructure.</li> <li>Work closely with data analysts, data scientists, and business intelligence engineers to understand their data requirements and deliver reliable, high-quality data access.</li> <li>Troubleshoot and resolve complex production data issues with urgency and root-cause rigor.</li> <li>Develop and maintain clear documentation for data models, pipelines, and data sources to enable self-service analytics.</li> <li>Participate in code reviews and contribute to technical discussions, bringing a constructive and detail-oriented perspective.</li> <li>Stay current on emerging data technologies and tools, bringing relevant insights to the team.</li> </ul> <p><strong>What You Need to Succeed in the Role</strong></p> <ul> <li>3+ years of experience designing, developing, and deploying data pipelines and data warehouse solutions in production environments.</li> <li>Strong proficiency in SQL and Python for data engineering and transformation work.</li> <li>Hands-on experience with cloud data warehouses (Amazon Redshift preferred; Snowflake or BigQuery also valued) and familiarity with ETL/ELT tools such as dbt, Matillion, or similar.</li> <li>Working knowledge of AWS services relevant to data engineering (e.g., S3, Glue, Lambda, Redshift).</li> <li>Demonstrated understanding of HIPAA compliance requirements and experience working with sensitive or regulated data.</li> <li>Ability to design and build data systems that are scalable, observable, and built to handle growth in data volume and complexity.</li> <li>Strong understanding of data integration patterns, including APIs, webhooks, and batch ingestion techniques.</li> <li>Experience giving and receiving structured feedback through pull request reviews and technical discussions.</li> <li>Strong communication skills, with the ability to translate complex technical concepts for both technical and non-technical stakeholders.</li> <li>Comfortable operating in a fast-paced startup environment, balancing competing priorities and making sound tradeoffs.</li> <li>Experience working with healthcare data is a plus.</li> </ul> <p>The expected annual salary for this role is between $110,000–$125,000. Actual starting salary will be determined on an individualized basis and will be based on several factors including but not limited to specific skill set, work experience, etc.</p><div class="content-conclusion"><p><strong>Why Join Our Team</strong></p> <ul> <li>Generous benefits package (401k with match, Flexible PTO, paid holidays, paid service days, 4 week paid sabbatical, 12 week paid parental leave, health benefits starting on your first day, and more)</li> <li>Opportunity to join a mission-driven company that is changing the landscape of pediatric mental health treatment</li> <li>Chance to make a far-reaching impact by helping children and families access desperately-needed, evidence-based care</li> <li>Opportunity to work with talented and experienced team members who have devoted their lives to solving this problem</li> <li>Fully virtual: work from the comfort of your home with periodic in-person retreats</li> </ul> <p><strong>Commitment to Diversity, Equity, Inclusion, & Belonging (DEIB)</strong></p> <p>We want to make our clinical services available for everyone, no matter where you come from, what you look like, or how you identify. To achieve this, we recognize we must continually make progress in building a more diverse, equitable, and inclusive team. Through these efforts, we support two primary objectives at InStride Health:</p> <ol> <li>Providing high quality patient care to families. We are in a privileged position to support families during a vulnerable time in their lives. We approach all families and each other with compassion and are most effective as a diverse team where all individuals feel valued, respected, and accepted.</li> <li>Building a mission-driven business that lasts. Specifically, we believe our commitment to a supportive culture improves innovation, decision-making, and efficiency.</li> </ol> <p>We invite you to share any additional information about yourself or your experiences that may not be reflected in your CV. Inclusion of this information is completely voluntary.</p> <h3 style="text-align: center;"><em><strong>Beware of fake job postings and offers. All official communications from InStride Health will come from email addresses ending in @instride.health. We will never ask for personal information such as Social Security numbers or bank details during the application process. If you receive a suspicious job offer or communication, please contact our recruitment team directly (<a href="mailto:talent@instride.health">talent@instride.health</a>) to verify its authenticity.</strong></em></h3></div>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...