ETL Software Engineer

Engineering

Full-time
Job Location: Venice, CA

Apply Now

Description

System1 is looking for an experienced software developer to join the engineering team in our Venice, CA, office. This role will work closely with our ETL and data science teams to build out robust data warehouse schemas to support our overall data-driven business goals. 

The Role You Will Have

  • Be responsible for designing and creating data warehouse schemas related to the extraction, transformation, and loading of data functions
  • Be responsible for the whole testing/deploying process to make sure other services are not disrupted
  • Be able to read, analyze, and digest data in the sense of business accomplishment, and design the optimal ETL process around those goals
  • Sanitize and transform data if necessary
  • Be responsible for generating business reports and ensure data validity; maintain all reporting processes company-wide to meet business requirements
  • Work closely with other developers to provide any DB administration support; take responsibility of database instances management and scheduled jobs maintenance
  • Develop internal tools that enhance development and testing efficiency, especially in terms of data validation/integration
  • Monitor and tune database instances to ensure peak performance; design and implement backup and recovery solutions
  • Respond to questions of data integrity and provide explanations of all data elements and calculations presented in the reporting tools
  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
  • Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS "big data" technologies
  • Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics
  • Build internal and external reporting infrastructure that can automate Excel reports or an API endpoint
  • Create data tools and database tables for analytics and data science team members that assist them in building and optimizing our product into an innovative industry leader
  • Write programs to automate various internal billing/accounting infrastructures

What You Will Bring

  • Master's degree in Computer Science or a closely related field (or equal experience)
  • At least one year of development experience in processing large amounts of data using a scripting language
  • Technical capability in coding

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 hours at various bars, restaurants, and venues across Los Angeles
  • Bi-weekly on-site happy hours
  • 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.
Apply Now