Lead Data Engineer

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