About Entera:

We are a venture backed real estate technology company with the leading SaaS + Services platform for residential investors. Powered by machine-learning and 100% online, Entera’s end-to-end residential real estate platform modernizes the real estate buying process to help our clients access and evaluate more properties, scale their operations, make data-driven investment decisions, and win more often.

Many of the largest real estate investors in the world use Entera’s marketplace daily. Entera’s annual transaction run rate is over $3.6B across 24 markets since its launch in 2018. Entera has raised $40M of venture capital from some of the most established & trusted firms in the world.  The company is headquartered in New York City, New York and Houston, Texas.

The Role

Entera is looking for an Analytics Engineer to join our growing Data team. The primary function of this role is to work with our Data Engineering and business teams to build dimensional data models in our data warehouse using dbt, and to expose those models to end users in the form of data visualizations and reports. You will be responsible for becoming an expert in our data services and working in all parts of our data product, including dashboarding and BI tools, application databases, and our data warehouse. In this high visibility role, you will be expected to tackle complex assignments and manage priorities, playing a role as a key team member in our rapid growth company.

Successful candidates will thrive in Entera’s unique operating environment and culture: high-growth, innovative, lean, and values-driven. As such, successful candidates must be highly capable in each of the following dimensions (among others): resourcefulness, adaptability, curiosity, analytical thinking/problem solving, proactivity, collaboration, technological savvy, and operating in a dynamic environment.

What You’ll Do: 

  • Work closely with data engineering and real estate experts to synthesize data requirements into scalable data pipeline components
  • Work with data from Snowflake, MySQL, S3, and other data sources, using primarily SQL and SQL-based BI systems
  • Build dimensional data models in Snowflake using dbt
  • Expose those data models in the form of data visualizations and reports to BI tools such as Apache Superset and Redash
  • Design and implement data tests (schema tests, unit tests, etc) on data models to ensure a high level of data quality and integrity
  • Write and maintain technical documentation for the data models you produce
  • Offer your own input and expertise on data warehouse design, and suggest additional tooling we can add to our stack when applicable (tools for documentation management, testing, improved development workflows, etc)
  • Help to define and improve our internal standards for style, maintainability, and best practices for a high-scale data infrastructure
  • Generate data driven insights leveraging descriptive analytics and communicate findings to engineers, real estate analysts, and other data product stakeholders

Who You Are: 

  • Must have or be currently pursuing a Bachelor’s degree in a quantitative field or a real estate concentration, including mathematics, engineering, Computer Science, Real Estate, Economics/Finance, or related concentration from an accredited college or university
  • Experience with data warehousing and dimensional modeling, specifically using the dbt framework or a similar SQL-based transformation tool
  • Advanced knowledge of SQL for data transformations, including constructs such as:
    • Common table expressions (CTEs), subqueries, aggregation functions, window functions, stored procedures, templating
  • Strong familiarity with source control systems such as Git and other command line tools
  • Knowledge of software development best practices, including CI/CD, testing, system design, code quality
  • Experience with visualization tools (e.g. Superset, Looker, Chartio, Redash, Tableau, etc.) 
  • Fluency in English
  • Self-starter with ability to master new tasks and technologies quickly
  • Ability to prioritize tasks and work on multiple concurrent assignments
  • Nice to have:
    • Knowledge of Python
    • Experience with or knowledge of basic statistical concepts, including descriptive statistics, sample size analysis, confidence intervals, hypothesis testing, statistical inference, and linear regression

Entera is proud to be an equal opportunity employer (EEO) that celebrates difference and diversity. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. We are committed to building an inclusive work environment where all employees feel a sense of belonging and respect. If there is anything we can do to ensure you have a comfortable and positive interview experience, please let us know.

Apply for this Job

* Required

When autocomplete results are available use up and down arrows to review
+ Add Another Education

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. 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.

As set forth in Entera’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

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 the 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.