Contract ETL Developer
New York, NY

Job Description

About Us

GSUSA is searching for a highly skilled Contract ETL Developer to join our data engineering team. You will transform and translate data into a form that is ready for use to solve the tough challenges of our business.You are a contemporary Data Engineer with data integration expertise and a passion for changing the data landscape.

The Contract ETL Developer will make data useful by moving it, transforming it, distilling it, combining it with other data, addressing data quality issues and delivering it to a repository or consuming system in a performant manner. You will work with various forms of data (xml, json, text, csv) and data sources (APIs, server logs, external data, no-sql, etc.). Ultimately, it will be you that manages Girl Scouts complex data landscape in today's world.

Here are a few exciting projects you will work on:

* Snowflake integration
* AWS cloud migration
* Centralized ETL
* MDM strategy and execution
* Building new data domain

You Will

* Design, develop, automate, monitor and maintain Extract Transform Load (ETL) data movement applications using our preferred ETL tools and techniques.
* Performance tune ETL applications to manage high volume batch data transfer to and from internal and external system locations
* Troubleshoot data issues, recommend, test and implement solutions
* Develop and document technical requirements and solutions
* Participate in design and code reviews
* Troubleshoot issues, making recommendations and delivering on those recommendations
* Engage in project planning and delivering to commitments
* Interact with Project Manager Lead and agile team to estimate development efforts and ensure accurate requirements fulfillment
* Participate in daily stand-up meetings, planning meetings and review sessions (using Scrum / Agile methodology)
* Interact with cross-functional teams to ensure complete delivery of solutions
* Assist with configuration of applications software

Please note: this position is a temporary, full-time position

You Need

* Bachelor's degree in Computer Sciences, Database Management or equivalent relevant work experience
* 5+ years of experience in an analytically driven role
* Extensive experience with delivery using ETL tools and techniques (i.e., Informatica, SSIS, Alooma)
* SQL or PL/SQL Programming skills
* Understanding of data warehouse and master data management approaches, ETL industry standards and best practices
* Experience with Cloud migration and cloud-hosted ETL environments
* Expert SQL and database tuning skills for relational platforms
* Familiarity with Revision Control - Git
* Demonstrated experience with Kimball ETL architecture techniques
* Demonstrated working knowledge of Unix/Linux operating systems and related data integration tools such as Secure FTP servers
* Experience with AWS technologies and/or Snowflake integrations a plus
* Experience with Apache a plus
* Working knowledge of an Operating System scripting language, ex. bash (using awk and sed), Python, and/or Perl
* Excellent communication, analytical, and development skills

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.