Girl Scouts of the USA

  • Enterprise Data Architect

    Job Locations US-NY-New York
    Posted Date 1 month ago(11/13/2018 10:51 AM)
    Job ID
    2018-1298
    # of Openings
    1
    Category
    Information Technology
    Type
    Full-Time
  • About Us

    The Girl Scouts data engineering team is seeking a Data Architect who is a visionary in defining and managing data architecture, with expertise in data modelling (Kimball method), ETL, performance tuning, data governance and data security. 

     

    The ideal candidate is a self-motivated, results driven technologist, who is passionate about collaboration, but can work independently and lead by example. The Data Architect will work with and mentor peer data engineering teams, ETL developers, Looker BI developers and the GSUSA infrastructure team.   

     

    Core Responsibilities 

    Data Quality / Data Integrity

    Our objective is to design and code for data quality frameworks that can measure and maintain data completeness, data integrity and data validity between systems. The candidate will be responsible for maintaining data integrity across multiple data repositories with the midterm goal of building and implementing Master Data Management (MDM) strategies for our organization.

     

    Scalability

    We are an organization with 112 federated Councils and a headquartered staff and operation in NYC. The Data Architect will be responsible for building highly scalable data repositories and for performing database performance tuning. The architect will define and track the KPIs to measure performance and provide visibility to senior management. The individual will set the standards for the design and coding of highly scalable solutions and will work with ETL developers to create and maintain a centralized ETL stream which is highly scalable with low latency.

     

    Cloud based Initiatives

    GSUSA’s data engineering team has been chartered to transition to a cloud based strategy. The Architect will be part of a team that works on implementing a Snowflake data warehouse architecture (as-a-service running in the cloud). In addition, GSUSA is moving toward a centralized ETL strategy, leveraging Informatica Power Center as our engine. 

    You Will

    • Define system level architectures and conduct dimensional modelling to build integrated DW /BI systems
    • Build the overall data architecture and design
    • Document the data ecosystems, data mapping from source to data repository 
    • Create a data dictionary for all Girl Scout enterprise data
    • Work with the development of our data lake. Target source systems include Salesforce, NetSuite and our in house developed Digital Cookie database built on Hybris (to name a few)

    You Need

    • Bachelor’s degree in Computer Science, Information Systems or related technical field or equivalent relevant work experience.
    • Minimum 10 years of industry experience overall
    • 10+ years of data warehousing and data architecture
    • Demonstrated experience with Kimball Dimensional modeling
    • 5+ years of architecting end to end self-serve BI platforms
    • Knowledge and experience with the following products a plus - Looker, Snowflake, Informatica and Alooma
    • 5+ years of ETL knowledge
    • Minimum 2 years of working knowledge with cloud based solutions hosted on AWS
    • GitHub, JIRA are other tools and technologies preferred

    Girl Scouts of the USA is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed