200+ applicants

Company

Original Job Post

System1 · 1 week ago

Senior Data Engineer

Los Angeles, CA

Full-time

Hybrid

Senior Level

$172K/yr - $257K/yr

Wonder how qualified you are to the job?

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

Designing, development and productizing of new well-orchestrated data pipelines, with data ingestion from various sources, delivering data assets at specific destinations.

Gather requirements, understand the big picture, create detailed proposals in technical specification documents.

Provide mentorship to colleagues within the team, and across the organization. Proof of concept evaluations of new technologies, new features, patterns, frameworks, API.

Influence the adoption of new or better practices, and outreach across the organization.

Continuously improve monitoring and alerting coverage.

Communicate effectively with upstream / downstream stake-holders, with clear understanding of data contracts or dependencies.

Conduct SQL data investigations, data quality analysis and optimizations.

Work in a transparent, and agile team environment, supporting the peers.

Perform maintenance of existing infrastructure, improving efficiency and costs.

Contribute in peer code reviews, and help the team produce high quality code.

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 designLinuxCommunicationCreative problem solvingMongoDBRedisDynamoDB

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

Competitive salary + bonus + equity

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)