Associate Data Engineer - National Core Indictors

Associate Data Engineer

We are looking for a data engineer to join our growing software and analytics team. This position is an exciting opportunity to get in on the ground floor of a technology transformation effort and create data pipelines and analytics tools from scratch, with the support of an experienced and passionate team that develops technical solutions to support data-driven policymaking and quality improvement in the human services sector.

Who We Are

HSRI is a nonprofit that has been researching, evaluating, and improving the quality and capacity of public health and social services for 45 years. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. The more inclusive we are, the better our work will be, and we encourage people from all backgrounds to apply.

This is a remote position but with the eventual option of working from our Cambridge, Massachusetts office, which is accessible by public transportation.

What We’re Looking For

This position will help expand and optimize our data flows and data collection tools for cross-functional teams. The ideal candidate has experience building data acquisition and transformation pipelines and wrangling data to support multiple data initiatives. The data engineer will support other engineering staff, software developers, data analysts, and data scientists and will ensure that optimal data delivery architecture is consistent throughout ongoing projects.

Initially, this role will lead the translation of survey definitions for a key project at HSRI supporting quality services for people with disabilities, the National Core Indicators, into an XML format that can be read and displayed by our proprietary survey software. You’ll be working side-by-side with software developers, data analysts, and policy content experts to ensure that survey data is well-represented and appropriately captured. You will also have the opportunity to work with data analysts and content experts to turn this data into actionable insights to inform developmental disability policy across the nation.

Responsibilities:

• Turn survey data capture tools into XML formats
• Maintain optimal data pipeline architecture
• Assist with creating and maintaining infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Microsoft Azure data technologies
• Integrate external or new datasets into existing pipelines
• Continuously monitor and test data systems to ensure optimized performance
• Work with data and analytics experts to improve data system functionality

• Bachelor’s degree in computer science, information systems, or a related field, or a bachelor’s degree in an unrelated field and at least two years of direct data engineering experience
• Experience in software engineering, data science, data pipeline design or related field
• Working knowledge of XML
• Working knowledge of SQL and experience working with relational databases, query authoring (SQL), as well as working familiarity with a variety of databases
• Experience building and optimizing data pipelines, architectures, and datasets
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
• A successful history of manipulating, processing, and extracting value from disconnected datasets
• Experience supporting and working with cross-functional teams in a dynamic environment
• Good attention to detail
• Awareness of DevOps and Agile principles

Full Time – 40 hours

How to Apply:

Interested candidates are encouraged to submit a Cover Letter and Resume/CV through HSRI’s Career Center.

You can also cut/paste the URL into your browser: https://workforcenow.adp.com/jobs/apply/posting.html?client=hsri&ccId=19000101_000001&type=MP&lang=en_US

Materials can also be mailed to:

Attention: Human Resources

Human Services Research Institute

2336 Massachusetts Ave.

Cambridge, MA 02140