Data QA

Everlywell is a consumer-initiated at-home laboratory testing company with easy-to-read and actionable results. We are at the forefront of personalized health, transforming the $25B lab testing industry. Everlywell is growing rapidly and we are looking for exceptional talent to join our team. We move at a fast pace to solve problems quickly so that our customers have a rewarding experience. If this sounds like your type of environment, we are eager to speak to you!
ROLE SUMMARY
We are looking for a skilled and highly motivated individual to fill our Data QA Engineer role. Reporting directly to the Director of Data Architecture, you will be working on building the next generation of our data stack to support the business. This job function will require putting on many different hats and working with multiple departments to create a reliable data pipeline. You design and implement effective data validation strategies and automation. What You'll Do:

• Build/Develop/Maintain scalable and configurable Data Quality frameworks in a Big Data environment
• Work with the Data Analytics team to help them refine their data needs and ensure data quality for our visualizations
• Build efficient ETL packages to move data through our data pipeline
• Optimization of existing frameworks and performance tuning
• Help build a framework for anomaly detection and monitoring
• Develop processes to ensure data integrity across various data stores
• Help create and maintain documentation for our relational DBs and data warehouse
• Help build a dataset for controlled application testing
• Build Data Analysis/Data Validation strategies to support development of Data Warehousing & Data Analysis solutions
• Writing complex SQL statements to validate data and perform extensive data analysis to identify defects
• Ensure that PHI is restricted to only the necessary datasets

Who You Are:

• 3+ years working on ETL pipelines and data quality
• 3+ years with Data Analytics and SQL structured programming, ad-hoc queries, and data analysis development
• 3+ years with at least one RDBMS
• Experience with BI tools like Tableau, Redash, etc.
• Excellent written and verbal communication skills, with internal and external teams
• Data Management and Architecture experience
• Quick learner in a rapidly-changing technology environment
• Must be able to work independently as well as in a team environment
• Performance-tuning experience

Nice to Have:

• Expertise on PostgreSQL
• Experience with ELT tools like Stitch, Fivetran, Pentaho etc.
• Experience with Big Data solutions, e.g. Snowflake or Redshift
• Experience with PySpark
• Experience with workflow tools to build and maintain an effective data strategy

You'll Love Working Here:

• 
  Venture backed by top-tier firms
• The opportunity ahead knows no bounds
• Open vacation policy
• Employee discounts
• Paid parental leave
• Health benefits
• 401(k)

NO EXTERNAL RECRUITERS - INDIVIDUAL APPLICANTS ONLY
Everlywell is committed to providing equal employment opportunities in all employment practices. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, citizenship status, marital status, age, disability, protected veteran status, sexual orientation or any other characteristic protected by law.
HIPAA Disclaimer: This role will be in an environment that has access to protected health information (PHI) and all security standards to protect PHI must be followed.