Data Engineer

Data Engineer
  DEPARTMENT DIRECT REPORT(S) IT n/a TRAVEL REQUIRED LOCATION n/a Hybrid – DC Area TERM SALARY Full-Time, Permanent $85,000 – 100,000

ABOUT SHATTERPROOF
Shatterproof was founded in 2013 to fill the gap for a well-funded, national, coordinated effort to reverse the course of the addiction health crisis, with the singular goal of ending the devastation addiction is causing our families. We know there are science-based solutions that can prevent and treat this disease, and we are committed to what research has proven to be effective. We have identified three priority pillars: transforming addiction treatment, ending addiction stigma, and educating and empowering communities.

Transforming Addiction Treatment: Shatterproof is transforming the U.S. healthcare system for the more than 49 million Americans living with a substance use disorder (SUD). Like anyone suffering from a disease, those with this disease deserve access to treatment that is based on science, complemented by a supportive recovery community, both free of shame and stigma. Removing barriers to lifesaving treatment is a core mission focus of Shatterproof.
Ending Addiction Stigma: Shatterproof’s National Stigma Initiative replicates the success of other transformational social movements—such as HIV/AIDS activism, cancer awareness, and marriage equality—in catalyzing the change needed to create a more tolerant, more compassionate, and healthier future. We are committed to creating solutions that are adept at changing attitudes and behaviors and ultimately closing SUD treatment gaps and health inequities for historically disadvantaged populations who experience compounded discrimination and bias.
Supporting and Empowering Communities: Shatterproof is committed to educating and empowering our families and communities nationwide by providing supportive and evidence-based resources related to prevention, treatment, and recovery from addiction.
You can learn more in our 2022/2023 Return on Investment Report here. ABOUT THE PLATFORM ATLAS® is the first and only web-based platform that allows the public searching for high-quality addiction treatment to locate and compare facilities, including trustworthy, standardized quality data on the services available, and feedback on the services reported by other patients. ATLAS helps the public navigate to better quality care and supports providers in quality improvement.

The core mission of Shatterproof is to reverse the addiction crisis in the United States and to serve patients and families. ATLAS fulfills Shatterproof’s goal of leveraging quality measures to increase transparency in and encourage improvements to addiction treatment. It is based upon Shatterproof’s National Principles of Care©.

ATLAS collects facility-level data from multiple, validated sources. Data from these sources is displayed in publicly facing dashboards that allow for easy comparison between facilities. Moreover, ATLAS promotes quality improvement by offering password-protected portals for facilities, payers, and states to view and use the data to drive quality improvement and innovation.

ATLAS is currently live in fourteen (14) states (DE, LA, MA, NC, NY, WV, FL, NJ, OK, PA, CA, WI, IN, CT). These 14 states represent close to 50% of the population in the United States, and ATLAS is in conversations with additional states as well. Shatterproof works closely with many addiction treatment stakeholders, including states health departments, provider and medical organizations, payers, and recovery advocates, to ensure successful and collaborative implementation.

ATLAS is an initiative overseen by a cross-functional group, composed of operational, research, and stakeholder engagement staff, who work remotely. Preference will be given to candidates in a major metropolitan area with access to a major airport.

THE ROLE
Shatterproof seeks a self-motivated and detail-oriented Data Engineer. We are seeking an individual passionate about contributing to the operation, support, and enhancement of our mission-driven data operations platform. This key role will support, monitor, and develop core database tables, processes, pipelines and interfaces responsible for the storage, collection, processing, and analysis of data gathered across the Shatterproof organization.   This encompasses the development, management, testing and operation of our facility and patient data hubs, including data intake, data quality assessment/testing, data curation and enrichment processes on cloud-based data architecture and modern system integration with various software and web applications.
This position will work collaboratively with Shatterproof Information Technology team as well as external data vendors and will be supervised by the Vice President, IT. 

This person will be an individual contributor, with no direct reports.

DUTIES AND RESPONSIBILITIES

• Develop, implement, and support scalable data integration (ETL/ELT) processes, covering storage, ingestion, cleansing, curation, unification, presentation, using new or current technologies (Azure SQL Server, Data Factory, Salesforce, Qualtrics, Drupal, Python, Power BI, Power Apps)
• Develop and enhance data architecture to directly improve operational efficiency for the business, continuing to build out an enterprise-level data ecosystem.
• Manage and ensure the success of repeatable reliable daily data pipeline routines using continuous delivery (CD) and Software Development Life Cycle (SDLC) best practices.
• Develop and update dynamic documentation for data pipelines, environments, releases, operational processes, and system support for applications and integration layers.
• Other tasks assigned by the Vice President, IT.

EDUCATION AND EXPERIENCE

• Bachelor’s degree in Computer Science, Engineering, Information Systems, Data Analytics or applicable experience.
• Expertise with SQL, database design, data manipulation methodologies, and data integration via batch file exchange and/or REST API.
• Experience with ETL/ELT and the development of automated validation, data pipelines, Python/Power Shell scripting.
• Experience and comfort using Microsoft Azure/Data Factory.
• Excellent verbal and written communication/
• Self-motivated, strong critical thinking skills, with the ability to quickly problem solve and adopt new strategies/technologies as needed.
• Passionate about learning and innovating.
• Ability and authorization to work in the US required.
• Ability to work Central/Eastern Time Zone hours.