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.
Similar Jobs
What you need to know about the Colorado Tech Scene
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
