Data Engineer II

To apply for this job please sign in or enter your email below.

Beautycounter · Santa Monica, CA

Engineering
Environment
Posted 2 months ago

EC2
AWS
Python
SQL
C#
ExpressJS
.NET
Node.js

Beautycounter is the leader in clean skin care, makeup, and personal care, with a mission to get safer products into the hands of everyone. We go above and beyond clean to set the highest bar in beauty through our safety standards—including ingredient transparency, sustainable packaging, and responsible sourcing.  Launched in 2013 as a direct-to-consumer retail beauty brand and Certified B Corporation, we develop and distribute approximately 100 products across our collections in skin care, makeup, men’s, and personal care in the U.S. and Canada. 

 Beautycounter and global investment firm The Carlyle Group have announced that Carlyle has acquired a majority stake in Beautycounter. The partnership will allow Beautycounter to accelerate its strategic initiatives, including increasing brand awareness as well as bolstering the company’s innovative, integrated, omni-channel business model. The transaction values the company at $1 billion.

We are looking for a fantastic Data Engineer II who can help support the businesses needs for analytics and data. The ideal Data Engineer has a great background of building data warehouses, data flows, Data Modelling and working hand-in-hand with analysts in the business to meet their data needs.

We are looking for someone that is passionate about the data and patient when dealing with data issues.

In this role you will:

  • Work hand-in-hand with analysts from around the company to help solve their data needs
  • Participate with architecture and Build of Data Warehouse in Snowflake
  • Support google stack for Data Warhousing (Big Query, GCS, Cloud SQL, etc)
  • Build ETL pipelines either customized or with the help of FIVERTRAN
  • Maintain the company’s legacy SQL Server 2017 analytical DataMart
  • Utilize AWS RDS, AWS EC2, AWS DMS, and SQL Server Change Data Capture
  • Write System Requirement documentation (SRD) and work with Project Manager to create Business Requirement Documents (BRD)
  • Utilize Reporting tools (Looker) to generate comprehensive dashboards and reports for departments
  • Assist with delivering the company’s Data Management Program as guided by DAMA  

 We are looking for someone who has:

  • Mid to expert level in database development in Snowflake
  • Experience with SQL Server 2017 or higher
  • Experience with SQL Server Integration Services, SQL Server Agent
  • Relational and Dimensional modeling specifically using Kimball Methodology for Star Schema
  • Experience with building ETLs using Fivetran, dbt or similar
  • Great communication and prioritization skills in order to work with the business and understand their needs
  • Proficient with SQL and Node.JS
  • Experience with Data Governance Principles and Techniques
  • Experience with delivering quality under high pressure

Optional:

  •  VB.NET/C#
  • Python for Data Engineering
  •  SQL Server Analysis Services
  •  Looker

At Beautycounter we are committed to creating a diverse environment and are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

Related Jobs

Backend Engineer - Tia
Remote (USA) - Posted 1 month ago
Engineering Manager, Patient Experience - Curative
San Dimas, CA/Remote (USA) - Posted 1 month ago
UI/Front End Engineer - Castlight Health
San Francisco, CA - Posted 1 month ago
View more open tech jobs in Santa Monica, CA
Be the first to see new Data Engineer II jobs

Save this search to get an email when new jobs match this search.

Create Email Alert