Girl Scouts Of The USA-posted 8 months ago
$140,000 - $185,000/Yr
Full-time • Senior
Hybrid • New York, NY
Religious, Grantmaking, Civic, Professional, and Similar Organizations

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.

  • Provide strategic direction to design & implement innovative solutions and strategies on modernizing enterprise data architecture technologies.
  • Build enterprise data models which incorporate data from disparate enterprise platforms and third-party data enrichment services.
  • Work with Technology to develop enterprise data connectivity to drive business goals leveraging API as a Service.
  • Collaborate with and provide backup for Sr Data Architect to support and maintain the Enterprise Data Warehouse.
  • Work with other team members to define the best solution, estimate development efforts and ensure accurate requirements fulfillment.
  • Participate in design and code reviews.
  • Design, build, and implement scalable data pipelines to efficiently extract and transform high volumes of data.
  • Work closely with data architects to integrate data models into data integration processes.
  • Balance multiple projects of varying difficulty in an Agile framework.
  • Adhere to standards and processes to ensure successful operational support required to ensure successful completion of ETL/ELT process.
  • Assist with configuration of application software.
  • Manage change control process.
  • Document technical requirements and solutions.
  • Performance tune ETL/ELT applications to manage high volume data transfer.
  • Manage and schedule Driver Upgrades in the Dev and Prod environments.
  • Provide documentation and knowledge transfer to Data Engineering team members.
  • Support and monitor existing ETL/ELT processes.
  • Troubleshoot ETL/ELT issues, recommend, test, and implement solutions.
  • Fifteen plus (15+) years of experience in a data integration/transformation driven role.
  • Ten plus (10+) years of experience in data warehousing and data architecture.
  • Demonstrated experience with data fabric, Large Language Models (LLMs), and Artificial Intelligence.
  • Demonstrated ETL experience with enterprise platforms such as Salesforce, SAP Commerce Cloud, NetSuite, OpSuite, Qualtrics.
  • Extensive experience using ETL tools and techniques in large-scale implementation.
  • Deep understanding of ETL industry standards and best practices.
  • Significant experience with cloud data warehouses, Snowflake required.
  • Demonstrated ability to architect and build complex enterprise data models.
  • Knowledge of data security, and data privacy.
  • Excellent communication, analytical, and development skills.
  • Master's degree in related field is a plus.
  • Certifications: Snowflake SnowPro Core and SnowPro Data Engineer.
  • 20+ days of paid time off, 2 floating holidays, and 9 workplace holidays per year.
  • Paid holiday year-end office closure between Christmas and New Year's.
  • Medical and Behavioral Health Coverage Plan options with individual and family coverage.
  • Dental and vision coverage.
  • Health Savings Accounts (HSAs) and Flexible Spending Accounts (FSAs).
  • 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.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service