Facebook pixel

Data Engineer
Data Warehouse
Confirmed live in the last 24 hours
Locations
Los Angeles, CA, USA
Experience Level
Entry
Junior
Mid
Senior
Expert
Desired Skills
Airflow
Snowflake
SQL
Requirements
  • 3+ years of working experience with large scale data warehouse systemsVery strong knowledge of SQL and data manipulation best practices
  • Experience in building efficient and fault tolerant ELT/ETL data pipelines
  • Very strong knowledge of working with large scale datasets
  • Ability to investigate data discrepancies and find the root cause
  • Ability to write test cases for data validation
  • Ability to write clear documentation
  • Very strong knowledge of data modeling and data warehouse design
  • Experience with Snowflake is preferable
  • Knowledge of DBT, Jinja scripting and Airflow is a big plus
  • Ability to translate business requirements into functional specifications
  • Ability to quickly adapt to changes in requirements and to effectively work on geographically diverse cross-functional teams
  • Excellent written and verbal communication skills
  • Experience with BI tools a plus, but not required
Responsibilities
  • Design and implement data warehouse schemas to store large data sets that can be easily and efficiently queried and joined together for reporting and analytical purposes
  • Design and develop ETL/ELT pipelines to efficiently move and aggregate data, while optimizing for maximum code and data reuse
  • Collaborate with other team members on improvements to existing systems
  • Investigate data anomalies and provide quick resolutions
  • Provide technical support to business users and analysts
System1

201-500 employees

Ad & marketing platform
Company Overview
System1's mission is to provide the most accurate and useful predictions in marketing. The company operates a Responsive Acquisition Marketing Platform to connect high intent customers with advertisers at scale.
Benefits
  • Great compensation
  • 401(k) company match
  • Excellence benefits
  • Charitable gift matching
  • Education subsidy
  • Referral bonus
  • Weekly happy hour
  • Catered lunches & free snacks
  • Weekly workouts
Company Core Values
  • System1 supports you - Whether this means providing a challenging job as part of your long-term career with us, maintaining work/life balance, or continuing your education, we want to support you and make you better.
  • Everyone is on the same team - Our co-workers are our teammates. This means respecting your teammates as much as it does enjoying working with them. We may disagree, but we do it openly and respectfully. When we win, we win together.
  • Be yourself - We believe that different backgrounds, experiences and points of view make us stronger and more innovative. We champion an environment where everyone is genuinely seen, heard and respected.
  • Own it - We don’t provide boxes for you to think in, and we encourage individual responsibility. We never blame someone else, and there is always a way to get it done. We want creative innovators who are driven to get results.
  • Make an impact - Being of service to others is in our DNA. We contribute our expertise, time and money to causes we care about in the communities in which we live and work. Giving back makes us and the world better.
  • 1% better every day - We strive to always improve every single day - our technology, our business, our community, ourselves.