Lead Data Engineer

5 Months ago • 5 Years + • Data Analysis • ~ $130,000 PA

Job Summary

Job Description

As a Lead Data Engineer, you will be responsible for designing and implementing data models, ingesting and transforming data, and developing data solutions using PostgreSQL and other RDBMS technologies. You will build and optimize ETL/ELT processes, analyze business needs, and communicate technical information. You will also lead data architecture strategy and engineering decisions, evaluate new tools, and create a Data Warehouse based on business requirements.
Must have:
  • 5+ years of experience with RDBMS databases (Oracle, MSSQL, PostgreSQL).
  • Working knowledge of MPP/distributed systems (HDFS, Vertica, Snowflake).
  • 1+ years of experience with ETL tools (Pentaho, Talend, Informatica).
  • SQL expertise—mastery in SQL.
  • Strong Linux expertise (RHEL, CentOS, or Fedora).
  • Experience in both OLAP and OLTP environments.
  • Solid on-prem experience—beyond just cloud environments.
  • Comfortable collaborating with cross-functional teams.
Good to have:
  • Hands-on expertise with Spark, including PySpark, SparkSQL, and Spark Streaming.
  • Familiarity with data federation tools like Presto or Trino.
  • Background in web analytics or Business Intelligence.
  • Experience with reporting and visualization tools like Tableau or Pentaho
Perks:
  • Comprehensive benefits package (medical, dental, vision, etc.).
  • 401(k) retirement savings plan with company match.
  • Paid time off (PTO) and paid holidays.
  • Commuter benefits.
  • Access to Employee Assistance Program (EAP) and well-being coaching.

Job Details

Internet Brands®, headquartered in El Segundo, Calif, is a fully integrated online media and software services company focused on four high-value vertical categories: Health, Automotive, Legal, and Home/Travel. The company's properties and platforms include the WebMD, Medscape, and Henry Schein ONE networks, which are the global leaders in their markets; Nolo, Avvo, and Martindale, which form the largest consumer information provider in the legal market; and CarsDirect, Fodor's Travel, and many others which are leaders in their key vertical markets. Internet Brands' award-winning consumer websites lead their categories and serve more than 250 million monthly visitors, while a full range of web presence offerings has established deep, long-term relationships with SMB and enterprise clients. The company's powerful, proprietary operating platform provides the flexibility and scalability to fuel the company's continued growth.  Internet Brands is a portfolio company of KKR and Warburg Pincus.

Internet Brands and its wholly owned affiliates are an equal opportunity employer. Internet Brands will consider qualified applicants with criminal histories in a manner consistent with the City of Los Angeles Fair Chance Initiative for Hiring Ordinance (FCIHO).

Responsibilities:

  • Designing and implementing data models for different data sources and scenarios.
  • Ingest, validate, and transform internal and external data for accuracy and reliability.
  • Design and develop data solutions using PostgreSQL and other RDBMS technologies.
  • Build and optimize ETL/ELT processes with Pentaho, Python or Java
  • Analyze business needs and design custom data models.
  • Communicate complex technical topics clearly to all audiences.
  • Lead data architecture strategy and engineering decisions.
  • Evaluate new tools, drive POCs, and continuously improve our data capabilities.
  • Create a Data Warehouse based on business requirements.

Qualifications (Must-Have):

  • BA/BS in Computer Science or a related field.
  • 5+ years of hands-on experience with RDBMS databases like Oracle, MSSQL, or PostgreSQL.
  • Working knowledge of  MPP/distributed systems like HDFS, Vertica, Snowflake, Google BQ, or Hive/Iceberg.
  • 1+ years of experience with ETL tools such as Pentaho, Talend, Informatica, DataStage, or HOP.
  • SQL expertise—not just experience, but mastery. You can do anything with SQL.
  • Strong Linux expertise—RHEL, CentOS, or Fedora.
  • Experience in both OLAP and OLTP environments.
  • Solid on-prem experience—beyond just cloud environments.
  • Comfortable collaborating with cross-functional teams (Dev, BI, Finance, Marketing, Sales).

Desired (Nice-to-Have):

  • Hands-on expertise with Spark, including PySpark, SparkSQL, and Spark Streaming.
  • Familiarity with data federation tools like Presto or Trino.
  • Background in web analytics or Business Intelligence.
  • Experience with reporting and visualization tools like Tableau or Pentaho 

We currently operate on a hybrid in-office schedule (minimum of 3 days in-office).  

Join us in this exciting environment where we’re transforming the legal landscape.

Avvo is an Internet Brands company.

At Internet Brands, we carefully consider a wide range of factors when determining compensation, including your background and experience. These considerations can cause your compensation to vary. We expect the compensation for this role to have a range that starts at $130,000 and will depend on your skills, qualifications, and experience. We encourage all interested candidates to apply.

In addition to our awesome culture, we offer a comprehensive benefits package designed to support the health and well-being of you and your family. Our benefits include health insurance options such as medical, dental, and vision coverage, flexible spending accounts (FSA) for medical and dependent care, short-term and long-term disability insurance, and life and AD&D insurance. We also provide a 401(k) retirement savings plan with a company match, paid time off (PTO), paid holidays, commuter benefits as well as access to our Employee Assistance Program (EAP) and well-being coaching services. In addition, employees can take advantage of voluntary benefits such as home, auto and pet insurance, and discounted legal and financial services. For more details, feel free to inquire during the interview process.

Internet Brands®, headquartered in El Segundo, Calif, is a fully integrated online media and software services company focused on four high-value vertical categories: Health, Automotive, Legal, and Home/Travel. The company's properties and platforms include the WebMD, Medscape, and Henry Schein ONE networks, which are the global leaders in their markets; Nolo, Avvo, and Martindale, which form the largest consumer information provider in the legal market; and CarsDirect, Fodor's Travel, and many others which are leaders in their key vertical markets. Internet Brands' award-winning consumer websites lead their categories and serve more than 250 million monthly visitors, while a full range of web presence offerings has established deep, long-term relationships with SMB and enterprise clients. The company's powerful, proprietary operating platform provides the flexibility and scalability to fuel the company's continued growth. Internet Brands is a portfolio company of KKR and Warburg Pincus.

Internet Brands and its wholly-owned affiliates are an equal opportunity employer. Internet Brands will consider qualified applicants with criminal histories in a manner consistent with the City of Los Angeles Fair Chance Initiative for Hiring Ordinance (FCIHO).

Notice to California residents: you can find information about our privacy practices, on: https://www.internetbrands.com/work-with-us/cpra 

 

Similar Jobs

Tesla - Senior Mechanical Design Engineer, Battery Module Pack

Tesla

Brandenburg, Germany (On-Site)
4 Months ago
Zones - Services Marketing Manager

Zones

Noida, Uttar Pradesh, India (On-Site)
1 Month ago
Blinkhealth - Bilingual Vietnamese - Customer Support Specialist

Blinkhealth

Chesterfield, Missouri, United States (On-Site)
1 Week ago
Capgemini - HR Operational Excellence Analyst -A

Capgemini

Noida, Uttar Pradesh, India (On-Site)
2 Months ago
Addepar - Recruitment Program Manager - University Recruiting

Addepar

Pune, Maharashtra, India (Hybrid)
1 Month ago
Casumo - Senior Business Analyst

Casumo

Zagreb, Croatia (Hybrid)
3 Months ago
OKX - Senior Internal Audit Data Analyst

OKX

New York, United States (On-Site)
14 Hours ago
PwC - Consultant expérimenté Data analyst | CDI | F/H

PwC

Neuilly-sur-Seine, Île-de-France, France (On-Site)
9 Months ago
SparkCognition - Data Scientist

SparkCognition

Bengaluru, Karnataka, India (On-Site)
9 Months ago
Playtika - Experienced Business Analyst

Playtika

Israel (On-Site)
8 Months ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

legion - Director, Quality Assurance

legion

Bengaluru, Karnataka, India (Hybrid)
13 Hours ago
Quilt - Embedded Software Lead

Quilt

Redwood City, California, United States (Hybrid)
1 Month ago
oportun - Senior Software ML Engineer

oportun

India (Remote)
2 Months ago
FalconX - FP&A Manager

FalconX

San Mateo, California, United States (Hybrid)
2 Months ago
Razer - Software Engineer Intern

Razer

Shah Alam, Selangor, Malaysia (On-Site)
3 Weeks ago
Intel  - Revenue Accounting Operations Director

Intel

Hillsboro, Oregon, United States (On-Site)
1 Month ago
Tekion Corp - Design Operation Specialist II

Tekion Corp

Bengaluru, Karnataka, India (On-Site)
3 Weeks ago
Enphase Energy - Salesforce Developer

Enphase Energy

Bengaluru, Karnataka, India (On-Site)
6 Months ago
Adobe - Principal Engineering Program Manager

Adobe

San Jose, California, United States (On-Site)
2 Months ago
PayPal - Lead Product Manager

PayPal

Austin, Texas, United States (Hybrid)
3 Weeks ago

Get notifed when new similar jobs are uploaded

Jobs in El Segundo, California, United States

Redhorse Corp - National Programs and Policy Support Subject Matter Expert

Redhorse Corp

Arlington, Virginia, United States (On-Site)
2 Weeks ago
Highspot - Senior Software Development Engineer, DevOps

Highspot

Seattle, Washington, United States (Hybrid)
3 Days ago
Expedia - Machine Learning Scientist III, Growth Marketing (Gen AI)

Expedia

Seattle, Washington, United States (On-Site)
1 Month ago
lifechruh - HRIS Specialist

lifechruh

Edmond, Oklahoma, United States (On-Site)
8 Months ago
SBM Management - Custodial Lead

SBM Management

Illinois, United States (On-Site)
3 Months ago
Apple - US Manager

Apple

Austin, Texas, United States (On-Site)
1 Month ago
luxsoft - Senior ETL Developer

luxsoft

Tampa, Florida, United States (On-Site)
2 Weeks ago
Hawkeye Innovations - NBA Technical Operations Senior Coordinator - Officiating

Hawkeye Innovations

Atlanta, Georgia, United States (Hybrid)
2 Months ago
Epic Games - UX Designer

Epic Games

Cary, North Carolina, United States (On-Site)
5 Months ago
Next Level Business Services - Mobility Lead

Next Level Business Services

Schenectady, New York, United States (On-Site)
8 Months ago

Get notifed when new similar jobs are uploaded

Data Analysis Jobs

My Fitness Pal - Staff Data Engineer

My Fitness Pal

United States (Remote)
14 Hours ago
London stock Exchange - Data Scientist

London stock Exchange

Bengaluru, Karnataka, India (On-Site)
3 Weeks ago
HYCU - Software Engineer – Cloud Data Protection

HYCU

Bengaluru, Karnataka, India (Hybrid)
1 Year ago
Penumbrainc - Business Process Analyst, CFSO

Penumbrainc

Alameda, California, United States (Hybrid)
6 Months ago
conga - Senior Staff Data Engineer

conga

India (On-Site)
1 Month ago
undefined - Lead Agile Business Analyst

Brisbane, Queensland, Australia (On-Site)
3 Weeks ago
bytedance - Research Scientist, Data Management and Security

bytedance

San Jose, California, United States (On-Site)
3 Months ago
velotio technologies  - Senior Engineer (Data Engineer)

velotio technologies

Maharashtra, India (Remote)
3 Months ago
Hitachi - Azure Data Engineer (MS)

Hitachi

Pune, Maharashtra, India (Remote)
8 Months ago

Get notifed when new similar jobs are uploaded

About The Company

El Segundo, California, United States (On-Site)

El Segundo, California, United States (On-Site)

Austin, Texas, United States (On-Site)

Minneapolis, Minnesota, United States (On-Site)

United States (On-Site)

Dallas, Texas, United States (On-Site)

Minneapolis, Minnesota, United States (On-Site)

Seattle, Washington, United States (On-Site)

Newark, New Jersey, United States (On-Site)

View All Jobs

Get notified when new jobs are added by Internet Brands

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug