Sr. Data Engineer

| Orange County
iHerb’s data and analytics team is on a mission to re-architect and re-engineer company’s data platform by bringing the agility and scalability of the cloud. We are looking for an experienced Senior Data Engineer who is passionate about all things data and has prior hands on experience of loading large datasets utilizing the latest cloud technology to do so. The Senior Data Engineer will be intimately familiar with Amazon Web Services, Google Cloud Platform as well as other global cloud service providers. This candidate should have strong experience with large ETL projects, evidence of experience with cloud/modern ELT architecture, Data Lake and more.
 
Job Expectations:
  • Build robust, scalable real time and batch data pipelines using services like AWS Glue, Amazon EMR, SSIS, Python, PySpark, many others.
  • Provide inputs in choosing and implementing cost effective, scalable and fault tolerant solutions
  • Well versed with modern data platforms and stay up to date with emerging trends in data engineering field.
  • Work directly with business teams to extract, transform, and load data from a wide variety of data sources using SQL and other technology
  • Familiar with Data Virtualization Technology
  • Knowledge of Master Data Management specific to ETL processes.
  • Improve ongoing reporting and analysis processes through automation, scale and best practice
  • Implement data structures using best practices in data modeling, ETL/ELT processes, and SQL, as well as other technology
  • Passion for data in all shapes and forms

 
Knowledge, Skills and Abilities:
Required:
  • At least 7 years of experience with building data pipelines on cloud platforms like AWS and/or GCP
  • Hands on experience with Python, Spark and Kafka to build our next gen streaming data platform, ingesting TB of data monthly. 
  • Knowledge of Snowflake, Redshift, Athena, batch and Streaming data, Timeseries, Kubernetes
  • Experience building large data lakes in the cloud.
  • Understanding of ETL and ELT, Informatica, AWS Glue, Google Cloud Dataprep, Amazon EMR and be able to choose the right tool for the job.
  • Attending daily sprint meetings
  • Working closely with PM and other upstream source system teams to address production issues.
  • SQL server and SSIS

Equipment Knowledge: 
Understanding of eCommerce, global scale networks and cloud architecture, other big data technologies
Experience Requirements:
  • 7-10+ years of Data Platform expertise
  • Some form of formal education (boot camp) in Computer Science, Software Development, Database or related technologies 
 
Education Requirements: 
  • Bachelor's Degree in Computer Science is highly preferred.
#LI-DL1
Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • JavascriptLanguages
    • SqlLanguages
    • jQueryLibraries
    • jQuery UILibraries
    • ReactLibraries
    • ReduxLibraries
    • Twitter BootstrapLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • SparkFrameworks
    • CassandraDatabases
    • Maria DBDatabases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • RedisDatabases
    • Google AnalyticsAnalytics
    • OptimizelyAnalytics
    • BalsamiqDesign
    • IllustratorDesign
    • InVisionDesign
    • PhotoshopDesign
    • SketchDesign
    • UXPinDesign
    • AsanaManagement
    • ConfluenceManagement
    • JIRAManagement
    • Microsoft ProjectManagement
    • SmartsheetManagement
    • ZendeskCRM
    • IterableCRM
    • IterableEmail
    • Google AnalyticsLead Gen
    • Google Data StudioLead Gen
    • TableauLead Gen

Location

Pasadena is known for it's charm and sophistication with the best night life, restaurants and bars this side of L.A! - Technology roles in Irvine, CA

An Insider's view of iHerb LLC.

What's something quirky about your company?

“Everyone is really different, nice and cool to be around. People are comfortable to be themselves, which is not common.”

Christopher

Junior Software Developer I

What's the biggest problem your team is solving?

“Most of the challenges stem from the extreme growth of the company in addition to keeping up with the technological advances in the market. We migrate and change quickly to adapt, which is the fun part because we are continuously learning.”

Alina

Senior Software Developer I

How does the company support your career growth?

"Everyone here is so brilliant. The teams are open and receptive to questions and work with you by providing constructive feedback, in addition to the camaraderie that supports consistent learning and development."

Kristine

Junior Software Developer I

How do you empower your team to be more creative?

"More so than empowering individuals, you have to hire the right people, trust them and let them do what they are good at.”

Alireza

Director of Software Development & Platform

What's the biggest problem your team is solving?

"The problem my team is currently solving is how to integrate robots into the warehouse. iHerb recently brought on a new team of engineers to design the robots and my team will be interfacing with them. This will involve a range of sub-problems from path finding for robot navigation to dynamic location management."

Ian

Software Developer II

What are iHerb LLC. Perks + Benefits

iHerb LLC. Benefits Overview

Perks include snack and beverage stations, on-site gym's, video arcade rooms, sand volleyball court, team happy hour and networking events and etc...iHerb is dedicated to providing comprehensive medical, dental and vision plans by contributing 75% or more of the monthly costs associated, regardless of one's level of coverage.

Culture
Volunteer in local community
iHerb is committed to helping great causes here at home and around the world. We partners with organizations like the Boys and Girls Club, Susan G Komen, Ronald McDonald House, Exceed, etc...
Partners with Nonprofits
Worldwide, we’ve donated over $5 million. iHerb facilitates two schools in Cambodia in addition to supporting the Cambodian Children's Fund and New Hope Cambodia in support of children's education.
Friends outside of work
Eat lunch together
Intracompany committees
iHerb's iFit and iFocus teams are dedicated to organizing company events in addition to creating wellness programs and initiatives. The overall health and wellness of our team members is priority!
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
iHerb Team Members can contribute up to $2700 annually to their FSA.
Disability Insurance
iHerb provides both short and long term disability coverage for it's Team Members.
Dental Benefits
iHerb provides both a DHMO and PPO thru Cigna Dental
Vision Benefits
Health Insurance Benefits
iHerb contributes 75% or more to the monthly costs associated with health plans ranging from Blue Shield's HMO, HMO+, PPO and HDHP.
Life Insurance
iHerb provides all full-time Team Members with a 100% company-paid $50,000.00 life/AD&D policy. In addition, Team Members have the option to elect additional life/AD&D coverage plans.
Pet Insurance
Wellness Programs
Onsite Gym
Team workouts
Retirement & Stock Options Benefits
401(K)
401(K) Matching
iHerb contributes a 100% match up to 4% of the Team Member's election. This is a "Safe Harbor" plan, absent from a vesting period , therefore the money that iHerb contributes is yours from day one.
Company Equity
iHerb provides a generous Profit Sharing and Phantom Unit Plan that provides equity to employees based on a minimal vesting period.
Performance Bonus
iHerb's annual discretionary bonus program is generous to say to say the least! Bonus plans are aligned with the individual and overall success of the company and Team Member.
Child Care & Parental Leave Benefits
Child Care Benefits
Generous Parental Leave
Family Medical Leave
Vacation & Time Off Benefits
Generous PTO
Acme Co. employees receive between 15 and 20 days per year of paid time off based on years of service.
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Game Room
Stocked Kitchen
Happy Hours
Happy hours are hosted On occasion .
Relocation Assistance
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Our tuition reimbursement plan offers an annual max of $5250 with a maximum total match of $5250.
Lunch and learns
Cross functional training encouraged
Promote from within
Continuing Education stipend
More Jobs at iHerb LLC.45 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Marketing
Operations
Product
Project Mgmt
Content
Project Mgmt
new
Pasadena
Developer
new
Orange County
Developer
new
Orange County
Marketing
new
Pasadena
Marketing
new
Orange County
Data + Analytics
new
Orange County
Product
new
Pasadena
Operations
new
Orange County
Developer
new
Orange County
HR
new
Pasadena
HR
new
Pasadena
Developer
new
Orange County
Developer
new
Orange County
Data + Analytics
new
Orange County
Developer
new
Orange County
Developer
new
Orange County
Product
new
Orange County
Developer
new
Orange County
Data + Analytics
new
Orange County
Content
new
Orange County
Project Mgmt
new
Pasadena
Design + UX
new
Orange County
Marketing
new
Pasadena
Operations
new
Pasadena
Operations
new
Pasadena
Developer
new
Orange County
Developer
new
Orange County
Developer
new
Orange County
Finance
new
Orange County