Senior Director Data Architect / ETL Architect

Girl Scouts of the USA

Founded in 1912, Girl Scouts of the USA (GSUSA) is the preeminent leadership development organization for girls and the leading authority on their healthy development. Millions of Girl Scout alums across the country and the world have gone on to achieve incredible things and make a tremendous impact in fields ranging from public policy, medicine, journalism, and athletics to international relations, science, technology, art, and entertainment. 

As a mission-driven organization, Girl Scouts of the USA champions girls as they explore their worlds, try new things, and develop the courage, confidence, and character to make the world a better place. From stargazing during a first overnight camping trip to building robots, navigating a rocky hiking trail, working together on a community project, and learning about the importance of environmental stewardship, Girl Scouts of all backgrounds and abilities can unapologetically be themselves as they rise to meet new challenges and discover the issues that matter most to them. Along the way they learn the power of friendship, connection, and teamwork. 

Girl Scouts are doers, innovators, problem-solvers, creators, and dreamers, and the GSUSA team is here to center, support, and inspire them, working with 111 local councils across the country and USA Girl Scouts Overseas to deliver our life-changing Girl Scout Leadership Experience.

This is a hybrid position with 2 days in the New York City GSUSA office.

The Analytics & Insights team is part of the larger Strategy and Planning team and is charged with producing data-driven insights to improve and inform decision making and strategic development and identify areas of opportunity across the organization and movement. The team serves all GSUSA departments and leverages internal and 3rd party data and research to inform these insights and will commission and execute new research to fill any gaps.

The team is also responsible for producing on-going and ad-hoc analyses and dashboards to ensure movement stakeholders have the information necessary to make informed decisions. They also help inform the creation of and tracking of KPIs and metrics to measure performance of strategies and initiatives. This team is also responsible for Enterprise Data Management, required to enable data-driven decisions. This includes data management, privacy, governance, reporting and analytics.

POSITION SUMMARY

The Senior Director, Data / ETL Architect has advanced technical knowledge and state of the art enterprise data architecture expertise and can effectively articulate/evangelize data integration and access solutions across the Movement. This innovative individual is an integral member of the Data Engineering team, providing strategic direction on modernizing data architecture and innovative solutions (data fabric, Large Language Models (LLMs), and Artificial Intelligence) to meet the needs of the organization.

This position also has an operational responsibility for 15+ data pipelines and integrations serving several mission critical applications including the Enterprise Data Warehouse. The complexity and uniqueness of the Girl Scout technology stack requires a diverse range of Extract, Transform, Load (ETL/ELT) development and data architecture experience across multiple platforms, formats, and extraction methods.

This requires expertise on a variety of platforms and projects such as: Snowflake integration; AWS cloud migration; centralized ETL; data warehouse modeling, building new data pipelines; and broadening existing data integration services to support our data domains. As the Girl Scout technology ecosystem grows, the individual is responsible for designing and building the processes necessary to make the data consumable and ready for use to solve the tough challenges of our business.

The GSUSA Enterprise Data Warehouse serves the entire organization as well as our 112 Councils. The scale and complexity of the implementation consists of over 2 million active members; over 18 years of history from three generations of operational systems; and fact tables with hundreds of millions of records. The Senior Director, Data / ETL Architect works with Technology and Analytics & Insights Leadership to understand the organization and community objectives and provide strategic and innovative solutions that leverage data to grow our membership and increase revenue.

They will make data useful by designing, developing and maintaining scalable data pipelines from multiple sources; building out new API integrations to support continuing increases in data sources, volume and complexity; addressing data quality issues; modeling, transforming, distilling, combining and delivering it to a repository or consuming system in a performant manner. This position will work with various forms of data (xml, json, text, csv, etc,) and data sources (APIs, server logs, external data, no-sql, etc). Ultimately, it will be the Data/ETL Architect that manages Girl Scouts’ complex data landscape in today's world.

ESSENTIAL RESPONSIBILITIES - Primary duties of the position

Reasonable accommodation may be made to enable individual

s with disabilities to perform the essential functions.

Other Duties: Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job.

SALARY RANGE: $140,000 - $185,000

This represents the present low and high end of the pay range for this position. Actual pay will vary based on various factors, including but not limited to experience.

What We Offer: 

Girl Scouts is powered by people, and we encourage our team members to be their best selves in and out of the office. We place a high priority on flexibility and offer a competitive employee salary and benefits package that includes: 

Paid Time Off:  

GSUSA offers 20+ days of paid time off, 2 floating holidays, as well as 9 workplace holidays per year. GSUSA staff also enjoy a paid holiday year-end office closure between Christmas and New Year's.

Other Benefits: 

• Medical and Behavioral Health Coverage 
• Plan options with individual and family coverage which includes wellness, hospitalization, and fertility assistance. 
• Both plans include GSUSA partial subsidy of premium costs
• Dental and vision coverage

• Health Savings Accounts (HSAs) and Flexible Spending Accounts (FSAs) including Health, Dependent Care, and Limited FSA for those with Health Savings Accounts 
• Company-paid life insurance 
• Flexible work arrangements 
• 12 weeks of paid parental leave 
• 401(K) with company match 
• Sick leave 
• Short- and Long-Term Disability for salary continuation 
• Health and Wellness Classes and Activities throughout the year 
• Access to Employee Engagement Groups 

PHYSICAL DEMANDS: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

POSITION TYPE / EXPECTED HOURS OF WORK: This is a full-time position. Days and hours of work are Monday through Friday. Occasional evening and weekend work may be required as job duties demand.

AAP/EEO Statement: GSUSA is an equal employment opportunity employer.