About Understood

Understood is dedicated to shaping the world for difference. Our programs focus on empowering people who learn and think differently, and those who support them, by offering customized, accessible resources and a compassionate community. To learn more about Understood and our programs, please visit: www.understood.org 

About the Position

We are a growing data engineering team with a mission and a purpose. We work closely with the product, engineering, and data teams on building our next generation platform, and value thoughtful and collaborative work that has a meaningful and positive social impact. Our team is in the midst of establishing workflows, growing our data warehouse, and building out our foundational services.

What You’ll Do

  • Build out data architecture in partnership with the engineering team and in service of the data scientists, analysts, and marketing teams 
  • Build ETL for data sets with batched methodologies and  that contain slowly changing dimensions
  • Design new, update, and maintain event schemas and our data model for our site and community app data
  • Update and maintain our user-stitching and identification system
  • Create mock data and integration tests to validate ETL
  • Update and maintain monitoring and alerting to ensure our data’s quality
  • Implement and enforce best practices and standards for scalability, availability, efficiency, data life-cycle management, security, quality, fault tolerance, and disaster recovery
  • Maintain the team’s documentation, data dictionaries, and maintenance playbooks
  • Assist in database administration tasks in our data warehouse
  • Integrate third-party and open source solutions to import third-party data into the warehouse

Who You Are

  • 7+ years of experience with data-driven problem solving, data integration, data migration, and test-driven development
  • Developed, designed or managed ETL tasks containing slowly changing dimensions, batched data, and complicated transformations and aggregations
  • Advanced SQL skills like recursive SQL, CTEs/temp tables, and familiarity with query profiling for performance
  • Understanding of databases and analytics in relational databases (Postgres, SQL server, etc.), data warehouses (Snowflake), and optionally in NoSQL databases
  • Familiarity with python, typical libraries (pandas, pytest), and Docker containers
  • Capable of close collaborative work with a diverse group of technical and non-technical teammates, stakeholders, product managers, and end users
  • Familiarity with cloud architecture like AWS or GCP platforms
  • Optional: Familiarity with developing event schemas for site and app tracking, like Snowplow.

Commitment to Diversity, Equity, and Inclusion 

Understood encourages individuals of all learning styles, ethnic, racial, and socioeconomic backgrounds, including those whose life experiences may include the challenge of access due to a disability, to apply for this position. We are committed to maximizing the diversity of our organization, as we want to engage all those who can contribute to supporting this work. Understood is an equal opportunity employer and considers all applications without regard to race, color, religion, creed, sex, national origin, ancestry, age, alienage or citizenship status, marital or familial status, domestic partnership status, caregiver status, sexual orientation, gender, gender identity or expression, change of sex or transgender status, genetic information, medical condition, pregnancy, childbirth or related medical conditions, physical or mental disability (where the applicant or employee is qualified to perform the essential functions of the job with or without reasonable accommodation), any protected military or veteran status, or status as a victim of domestic or dating violence, sexual assault or offense, stalking, or any other characteristics protected by federal, state, or local law or that of persons with whom that individual associates, or any other legally protected characteristics.

For additional information on learning and thinking differences, including ADD/ADHD, dyslexia, dyscalculia, dysgraphia, dyspraxia, executive functioning issues, nonverbal learning disabilities, processing issues, and more, please visit www.understood.org

Apply for this Job

* Required
  


U.S. Equal Opportunity Employment Information (Completion is voluntary)

Individuals seeking employment at Understood are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.


Form CC-305

OMB Control Number 1250-0005

Expires 05/31/2023

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

We are a federal contractor or subcontractor required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

  • Autism
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS
  • Blind or low vision
  • Cancer
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or hard of hearing
  • Depression or anxiety
  • Diabetes
  • Epilepsy
  • Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome
  • Intellectual disability
  • Missing limbs or partially missing limbs
  • Nervous system condition for example, migraine headaches, Parkinson’s disease, or Multiple sclerosis (MS)
  • Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression

1Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.