142 applicants

Company

Original Job Post

System1 · 3 days ago

Sr. Data Engineer

Los Angeles, CA

Full-time

Hybrid

Senior Level

$172K/yr - $257K/yr

5+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

AdvertisingAdvertising Platforms

H1B Sponsorship

Comp. & Benefits

Insider Connection @System1

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Design, develop, and productize new data pipelines with data ingestion from various sources.

Gather requirements, create detailed proposals in technical specification documents.

Provide mentorship, influence adoption of new practices, and improve monitoring.

Communicate with stakeholders, conduct SQL data investigations and optimizations.

Support peers in a transparent, agile team environment.

Perform maintenance of existing infrastructure, contribute to peer code reviews.

Consolidate and modernize the codebase.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQLPythonScalaJavaAWSGCPAzureSnowflakeGoogle BigQueryAWS RedshiftAzure SynapseDatabricksAirflowPostgresMySQLOracleSQL ServerELT/ETLData modelingDatabase designLinux communicationCreative problem solvingMongoDBRedisDynamoDBCassandraHadoopDockerKubernetes

Required

Bachelor’s or Master’s degree in Computer Science/Engineering.

Very strong SQL proficiency, and SQL query optimization experience is required.

Extensive expertise in Python programming is required. Scala, Java experience is a bonus.

Excellent communication skills.

Proponent of strong software production engineering practices, version control, code peer reviews, automated testing, and CI/CD.

Experience in AWS cloud is required. GCP, Azure are preferred.

Proficiency with one of the Cloud data-warehouses / data-lakes like Snowflake, Google BigQuery, AWS Redshift, Azure Synapse, Databricks.

Hands-on experience with modern orchestration platforms, such as Airflow.

Experience in relational databases like Postgres, MySQL, Oracle or SQL Server required.

Deep understanding of data engineering fundamentals, ELT / ETL, latency, observability, lineage, distributed storage and distributed computing.

Excellent data modeling skills, database design, relational/non-relational.

Very comfortable with exploring new technologies, leveraging new patterns, designing new data architectures, and creative problem solving.

Strong Linux skills.

Preferred

Scala, Java experience is a bonus.

GCP, Azure are preferred.

Experience in non-relational technologies like MongoDB, Redis, DynamoDB or Cassandra is preferred.

Applications and data-flow development in the Hadoop ecosystem is a plus.

Familiarity with docker, kubernetes containerization strategies and optimization is preferred.

Working knowledge of dbt and jinja macros, dbt docs, dbt test is preferred, but not required.

Any experience collaborating with business intelligence, data analytics, data science stake-holders is a strong plus.

Benefits

Generous PTO + 11 company holidays

Open sick time

100% covered Medical, Dental, Vision for employees

401k with match

Health & Dependent Care Flex Spending Account

Paid professional development

Leadership & growth opportunities

Virtual company and team building events

Company

System1

Glassdoor

3.6

System1 fuses technology and science to identify & unlock consumer intent.

Founded in 2013

Venice, California, USA

201-500 employees

http://system1.com

H1B Sponsorship

System1 has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Trends of Total Sponsorships

2022 (1)

2021 (1)

2020 (4)