Lead Data Engineer
Apply NowCompany: Internet Brands
Location: El Segundo, CA 90245
Description:
Description
Responsibilities:
Qualifications (Must-Have):
Desired (Nice-to-Have):
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.
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 BI.
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.