Data Engineer

For over 35 years, Youth Villages has transformed the lives of children and families nationwide through innovative, research-based programs focused on preserving and restoring families. As a national leader in children’s mental and behavioral health, we serve more than 47,000 youth, young people, and their families annually across 29 states and Washington, D.C. Our proven treatment models drive long-term success in child welfare, juvenile justice, and mental health systems. At Youth Villages, we do what works — partnering with others to expand our impact and advocate for meaningful, lasting change. We're seeking purpose-driven individuals who are passionate about making a difference. With a dedicated team of more than 5,000 staff, Youth Villages is committed to investing in and supporting our employees by offering opportunities to build a fulfilling career through professional growth, personal development, and a mission that matters— helping children and families live successfully. For more information, please visit www.youthvillages.org Position Overview: The goal of this position is to design, build, and maintain scalable cloud-based data solutions that support enterprise reporting, analytics, and operational decision-making. This role focuses on building scalable cloud-based data solutions by integrating enterprise source systems into Snowflake using Fivetran and Coalesce, and delivering curated, trusted datasets that support Tableau reporting, analytics, and operational decision-making. Additionally, this position will support enterprise data governance, data quality initiatives, cloud data warehouse development, and modernization of legacy reporting solutions. The Data Engineer will collaborate closely with business stakeholders, analysts, architects, and developers to deliver scalable and trusted data solutions across the organization. Essential Duties and Responsibilities: The Data Engineer: Builds scalable and robust cloud-based data solutions that can adapt over time to changing business and source system requirements Designs, develops, and maintains ELT/ETL pipelines using modern cloud technologies and data integration platforms Develops and optimizes data ingestion and transformation processes using tools such as Snowflake, SQL Server, MySQL, Fivetran, Coalesce and Github Maintains and improves enterprise data warehouse structures, curated datasets, and transformation logic for reporting and analytics Optimizes SQL queries and warehouse performance for accuracy, scalability, and efficiency Collaborates with business and technical teams to gather requirements and translate them into technical solutions Monitors, troubleshoots, and improves data workflows and production data processes Supports data governance initiatives including metadata management, lineage tracking, documentation, and data quality validation Diagrams and documents data flows, integrations, schemas, and transformation logic across enterprise systems Supports Tableau reporting initiatives by delivering validated and high-quality datasets for dashboards and analytics Participates in Agile development processes including sprint planning, estimation, backlog grooming, and release activities Ensures secure and compliant handling of sensitive organizational PHI data Performs other duties as assigned Qualifications: Bachelor’s degree in Computer Science, Information Systems, Engineering, Business Analytics, or related field (preferred) Experience developing and implementing ETL/ELT processes and enterprise data solutions (required) Experience with Snowflake, SQL Server, MySQL, Fivetran, Coalesce, and Github (preferred) Experience with JIRA or similar tools (preferred) Strong SQL development and query optimization experience Experience working in Agile development environments Knowledge of data warehousing concepts and data governance best practices Strong organizational skills and attention to detail Excellent written, verbal, and oral skills Ability to manage multiple priorities simultaneously Ability to maintain a flexible schedule Youth Villages Benefits Medical, Dental, Prescription Drug Coverage and Vision 401(k) Time off: 2 week paid vacation (full-time) / 1 week paid vacation (part-time) 12 paid sick days per year 11 paid holidays Paid Parental Leave Mileage & Cell Phone Reimbursement (when applicable) Tuition reimbursement and licensure supervision Growth & development through continuous training Clinical and administrative advancement opportunities *Benefits are excluded for variable status employees. Youth Villages is an equal opportunity employer and provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type 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. Youth Villages is committed to not only advancing diversity, equity, and inclusion in the workplace but also in our work with children and young adults. We know that children, families and young people of color can face inequity in child welfare and justice systems, and we train our employees to build the skills they need to work with the communities that we serve, as well as, other employees from different cultures and backgrounds. Youth Villages is opposed to racism in any of its forms and is committed to inclusion, equity, and diversity. We believe that respect for each other is crucial in the work that we do each day.