Aura is on a mission to create a safer internet.  In a world where our lives are increasingly online, Aura's category-defining suite of intelligent digital safety products help millions of customers protect themselves against digital threats, and that number is growing rapidly.  Aura is in an exciting phase of hyper-growth, and our team of close to 700 people worldwide is guided by a leadership slate that's successfully grown startups into multi-billion dollar organizations. 

Come join us for the ride!

Design, develop and maintain data warehouse and analytics architecture to meet an enterprise's business analysis and reporting needs.

Responsibilities

  • Datamart development in accordance with internal data architecture
  • Design of robust data transformation process from raw logs to aggregate tables, ready to use by analysts
  • Maintenance of Daily ETL and alerting system in order to ensure that up to date reporting is providing
  • Developing a process around the unification of different data sources (API, S3 files, Gsheet data, etc.)

Qualifications

  • Proficient in SQL with 5+ years of experience
  • Experience with at least one RDBMS (Oracle, PostgreSQL, DB2 MySQL, SQL Server)
  • Experience in ETL/ELT processes design, development, and maintenance
  • Experience with any of Big Data framework(Hadoop, Spark, EMR)
  • Experience with the most popular file formats (Parquet, Delta, Avro, ORC)
  • Experience in DWH modeling and Data Mart design
  • Knowledge of at least one of the programming languages (Python, Java, Scala, etc.)
  • Experience with at least one VCS (Git, SVN, etc.)
  • Experience working in an Agile/Scrum/Kanban development process
  • Experience transforming data in various formats, including JSON, XML, CSV
  • Upper intermediate or above level of English
  • Detailed oriented/self-motivated with the ability to learn and deploy new technology quickly.

    Would be a plus:

  • Marketing (user attribution/acquisition) or Customer Service (call-center, CRM) background
  • 2-3 years of Snowflake or Databricks experience
  • 2-3 years of Python and/or Scala experience OLAP/OLTP queries performance tuning
  • Experience with Hadoop or cloud solutions and services (AWS preferred)
  • Knowledge of workflow management tools (Airflow or similar)
  • 2-3 years of experience using Tableau Desktop / Server to aggregate and analyze data collected from various sources
  • 3-5 years of work experience in an analytical role

#LI-Remote

In keeping with our beliefs and goals, no employee or applicant will face discrimination or harassment based on race, color, ancestry, national origin, religion, age, gender, marital domestic partner status, sexual orientation, gender identity, disability status, or veteran status. Above and beyond discrimination or harassment based on “protected categories,” Aura is committed to being an inclusive community where all feel welcome. Whether blatant or hidden, barriers to success have no place at Aura.

 

Apply for this Job

* Required

  
  


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 Aura Sub, LLC’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.