System1 is looking for an engineer with production data experience to join our Data Engineering team. This team is the horizontal layer that supports business intelligence, optimization, machine learning, and external & internal reporting. We process and report on hundreds of millions of events and user attributes per day, gathered from an extremely heterogeneous set of data streams.

Our bread and butter are Python and SQL. Our SQL systems include Postgres, Redshift, and SQL server. We also utilize a range of technologies including AWS Lambda, SNS, SQS, Kinesis, Spark, and Redis.

The Role You Will Have

• Architect, build, and maintain a coherent and performant data architecture
• Prototype, develop, deploy, and debug data ingestions and data management services
• Maintain database performance by monitoring production databases and identifying and fixing production issues
• Perform database system upgrades
• Evaluate, recommend, and perform proof-of-concepts for new database toolsets and systems
• Design databases and construct queries and reports to guide architectural design, business decisions, and optimization algorithms
• Take projects through the full engineering lifecycle: architecting, building, testing, and deploying
• Participate in peer code reviews and produce high quality documentation
• Help grow a team and work with a tight knit group of engineers and data stakeholders

What You Will Bring

• Bachelor’s in Computer Science or equivalent
• 6+ years of experience working with large SQL datastores (PostgreSQL, Redshift, and Snowflake preferred)
• 6+ years of experience with Python development or an equivalent programming language, with a strong desire to learn Python
• 3+ years of experience in a database team lead or architect role
• Experience with Linux and the AWS ecosystem

What We Have to Offer

• Free Uber/Lyft to and from work every day!
• Collegial and collaborative team with highly intelligent and motivated coworkers
• Cross-team lunches and demos to foster learning
• Unlimited Paid Sick Time, Competitive PTO and Benefits package
• Daily catered meals and fully stocked kitchen
• Bi-weekly happy hour at various bars, restaurants, and venues across Los Angeles
• Bi-weekly onsite happy hour
• Catered dinner on Tuesdays and Thursdays
• Weekly fitness class with private trainer: high intensity training, yoga, beach volleyball, beach soccer, ultimate frisbee
• Company parties and outings: Skyzone indoor skydiving, Medieval Times, Karaoke, etc.