Company Introduction WorldStrides is the global leader in educational travel and experiential learning. The company was founded in 1967 to provide middle school travel programs to Washington, D.C. and has grown to provide a wide range of programs for more than half a million students annually to over 100 countries around the world. WorldStrides offers experiential learning programs in educational travel, performing arts, language immersion, career exploration, service-learning, study abroad, and sports. Each of these experiences helps students to see beyond the classroom and to see the world – and themselves – in new ways. Job Description: The ETL Engineer develops, deploys, and maintains data stores for access by business users including marketing campaign specialists and business data analysts. The ETL Engineer is responsible for supporting and maintaining the data warehouse environment including SQL databases, scheduled jobs, and Python-based ETL processes. The ETL Engineer will be responsible for creating and maintaining data pipelines to support reporting needs and will ensure the quality and integrity of reporting data. The role requires attention to detail and quality. Key customers for the ETL Engineer will include data scientists, analysts, and marketing campaign specialists working in the domains of marketing, operations, customer insights, and finance. Responsibilities: - Manage the structuring and maintenance of data sets for production of reporting and analytics - Build and optimize data pipelines to facilitate the extraction of data from multiple sources and delivery to multiple applications and teams - Reduce waste and improve data flow. This involves continually striving to reduce wasted effort, identify gaps and correct them and improve data development and deployment processes. - Acquire and update data from internal and external data providers - Execute automated testing at every stage of a pipeline to increase productivity while reducing errors - Create queries that allow data to be extracted and to streamline the data retrieval process - Monitor processes to quickly identify and resolve or elevate issues, and identify areas for improvement - Use automation to streamline data processing, automate manual processes, such as data extraction and testing. - Adopt new solutions to produce data more efficiently and with fewer errors. This includes testing and adopting solutions and tools that adhere to the DataOps best practices. - Correspond with team members and customers to understand business concepts, data requirements, and prioritization of development tasks - Communicate, document, and collaborate with other data and BI team members to enhance the quality of data products. - Ensure data security standards are applied across the data pipelines. Qualifications: - Experience in SQL, Excel, relational databases, database concepts, and database design. - 2+ years' experience with Python - Strong interpersonal, oral and written communication and presentation skills - Ability to work on multiple projects simultaneously and to provide regular status updates proactively - 3+ years' experience in BI development, data analysis, or data engineering - BS/BA degree (preferably in a technical or research field) Work Perks: - Fun & driven environment. - Excellent medical, dental, and vision coverage, life, accidental death and dismemberment, accident, critical illness, and disability insurance, FSA healthcare, FSA dependent care, HAS with employer contribution, and generous 401k match. - 10 paid floating corporate holidays, 1 paid volunteer day & 25 PTO days to start – accrue up to 28 over 3 years, 4 mental health days, and 5 bereavement days. - Tuition reimbursement up to five thousand, two hundred fifty dollars annually or one thousand dollars towards professional certification annually. - Opportunities for paid and discounted travel. - Flexible work schedule providing on-site, remote, and virtual office opportunities. - Encouraged participation in our Employee Resource Groups and Diversity, Equity, & Inclusion council. - Fitness Center and café onsite at select locations. - Employee Assistance Program (EAP) - Paid Parental, Caregiver, and Disability leave. - Team Member Discount Program. WorldStrides, a global organization, is committed to educate and serve communities worldwide. Our commitment is fueled by the passion of our team members and partners to make experiential learning accessible, while also being socially, environmentally, and ethically responsible. Together, we accomplish this by investing in initiatives to promote inclusion, diversity, and sustainability. As an Equal Opportunity Employer, WorldStrides is committed to building a diverse workforce, supported by an environment that promotes inclusion and belonging. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. WorldStrides will only employ those who are legally authorized to work in the United States. This is not a position for which sponsorship will be provided. Individuals with temporary visas such as E, F-1, J-1, H-1, H-2, L, B, J or TN, or who need sponsorship for work authorization now or in the future, are not eligible for hire. Select seasonal roles may consider students on J-1 or F-1 visas.

**You will be responsible for:** - Collaborating with your data peers and business teams to understand their needs and build data products that surface performance insights and drive action - Modelling core data assets using SQL, DBT, Python and LookML - Supporting the development of Machine Learning models using Python and AWS SageMaker - Contributing to the strategy and design of data models and the data warehouse - Supporting the discovery and integration of new data sources (OLTP, APIs, S3) - Empowering analysts and business users through conversational analytics, self-serve tooling, education, and documentation - Defining and managing data quality, documentation, observability, and governance of core data models - Managing data exposures in Looker, ensuring smooth and reliable delivery of data to the business - Automating repetitive analyses and tasks wherever possible - Investigating and proposing solutions for data warehouse issues arising from daily query processing and end-user needs - Fostering a data-driven culture across the organisation

• You are the DRI for everything between raw ingestion and the clean data layer. • You own the modelling strategy and are trusted to push back when a request would compromise what we've built. • You'll audit what we have, cut what we don't need, and rebuild the rest into something clean, traceable, and maintainable. • You'll design and own our approach to data quality: what we test, how we test it, and what happens when something breaks. • You'll own the efficiency of our query and storage footprint, refactoring models and materialisation strategies to reduce unnecessary spend. • You'll build a robust event data model that gives us meaningful observability across our full product suite.

We're looking for a Senior Data Analytics Engineer to join our passionate and diverse Data Team. Treatwell is an organisation built on data, and we're just getting started. In this role, you'll be instrumental in shaping our future by ensuring our data models and analytical capabilities keep pace with the rapid growth of our business. As part of the Data Domain Team, you'll take end-to-end ownership of data products that empower analysts, product managers, and business stakeholders with meaningful insights. You'll work closely with teams across the business, translating their needs into reliable, well-structured data assets. You'll bring strong expertise in SQL, Python, and data model design to deliver the right data in the best format through self-serve and Machine Learning-enabled tools. We work with open-source platforms including DBT, Airbyte, Docker, GitLab, SageMaker, and Airflow. Our services run on AWS, including Redshift, ECS, Lambda, Cloudwatch, S3, EMR, and EC2, alongside third-party tools like Fivetran, Monte Carlo, Looker, JIRA, and Slack. We're also at an exciting point in our data journey with plans to modernise our data stack and transition to a Lakehouse architecture. This is a great opportunity to help shape the direction of how we store, model, and access data at Treatwell. You will be responsible for: - Collaborating with your data peers and business teams to understand their needs and build data products that surface performance insights and drive action - Modelling core data assets using SQL, DBT, Python and LookML - Supporting the development of Machine Learning models using Python and AWS SageMaker - Contributing to the strategy and design of data models and the data warehouse - Supporting the discovery and integration of new data sources (OLTP, APIs, S3) - Empowering analysts and business users through conversational analytics, self-serve tooling, education, and documentation - Defining and managing data quality, documentation, observability, and governance of core data models - Managing data exposures in Looker, ensuring smooth and reliable delivery of data to the business - Automating repetitive analyses and tasks wherever possible - Investigating and proposing solutions for data warehouse issues arising from daily query processing and end-user needs - Fostering a data-driven culture across the organisation