ETL Data Engineer – Fully Remote or Onsite

Green River

Location: Brattleboro, VT

Type: Full Time

Education: Bachelor's Degree

Experience: 3 - 5 Years

Green River is looking for an ETL (extract, transform, and load) Data Engineer to help our team of impact-driven developers acquire social determinants of health (SDOH) and other data for the ongoing development and operations of a public health website. This is a hands-on position that requires a technical and functional understanding of data warehousing and data acquisition from source systems as well as familiarity with public health and environmental science analytics. We seek candidates committed to social justice issues. As the climate changes, the population increases, and critical resource thresholds are breached, data and information systems are playing an increasingly important role in defining and delivering solutions—for both economic benefit and human and ecological health. This vision drives us at Green River.

Incorporated in 2000, Green River is a custom web application development firm with a strong engineering and data focus—and dedication to “software and analytics for a better world.” Our projects offer challenges in developing complex, scalable algorithms and well-designed responsive user interfaces. Our company enjoys a collaborative atmosphere and values a workplace where you can learn and laugh—together we shape the kind of work and lifestyle we want and foster career paths through mentorship. This has resulted in exceptionally long-term relationships with both staff and clients. Our primary offices are in scenic Brattleboro, Vermont, and we have distributed staff living and working around the country. Our current clients include Starbucks, the Commonwealth of Massachusetts, the City of Boston, the State of Delaware, World Resources Institute, Reach Out and Read, and many other domestic and international non-profit organizations. We believe in our clients’ work and are committed to being good partners in their success.

The ETL Data Engineer will interact with public health officials, researchers, systems architects, software developers, project managers, and data scientists towards analyzing business requirements and architecting, designing, developing, and unit testing ETL solutions. We look for team members who believe in working to make the world a better place, yet bring a grounded professionalism appropriate to our clients and the scale of our projects. In addition:

Work authorization:

  • For this particular position, due to security clearance requirements related to our public health work, candidates must be U.S. citizens or Green Card holders.

As a Data Engineer, you will:

  • Apply best practices and provide expertise in acquiring data from disparate source systems to build a data warehouse, including initial development of extraction/integration routines

  • Develop classification systems, maintain a comprehensive data dictionary, perform basic data analysis, write SQL queries, and performance tune existing databases

  • Support on-going production operations and maintenance of ETL processes

  • Support troubleshooting and problem resolution activities including serving as an escalation point for software engineering and devops

  • Ensure compliance with data governance and security policies

We’d love to hear from people with:

  • Bachelor’s degree in computer or information science

  • Minimum 4 years experience with relational databases, data warehouse design, data extract routines, and data analysis (including handling large datasets, e.g. 100M+ rows)

  • 2+ years of software development experience in Python, Java, Ruby, C# or equivalent programming language

  • 2+ years of related professional experience maintaining and documenting a classification scheme for health care, public health, environmental science or similar domain specific data

  • A strong desire to learn and apply the latest technologies related to data management and software development tools

You would stand out if:

  • Your data skills were honed in a health, education, environmental, homelessness, or other socioeconomic and human-welfare context

  • You have technical or non-technical working experience with—or other direct exposure to—disadvantaged populations (e.g. via community service, humanitarian aid, social entrepreneurship, personal experience, etc.)

  • You have applied your skills for monitoring & evaluation or impact measurement purposes

  • You have experience working in a software consultancy like ours

© 2022 Vermont Technology Alliance

Site by Scout Digital