System1
Data Engineer II
Job Description
The Data Engineering team at System1 is focused on building data assets, catalog, frameworks, and automation to ensure smooth running data pipelines and infrastructure. We process 100s of billions of records per day, to support multiple business functions like business intelligence, data analytics, data science & machine learning, traffic quality and serving optimizations.
You would be working in a fast-paced environment where data system scalability, reliability, usability, efficiency and data quality are the goals. Come join us!
The Role You Will Have:
- Gather requirements, understand the big picture, create detailed proposals in technical specification documents.
- Proof of concept evaluations of new technologies, new features, patterns, frameworks, APIs.
- Productizing data ingestion from various sources, data delivery to various destinations, and creating well-orchestrated data pipelines.
- Consolidate and modernize the codebase.
- 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 your peers.
- Perform maintenance of existing infrastructure, improving efficiency and reducing costs.
- Contribute in peer code reviews, and help the team produce high quality code.
What You Will Bring:
- Bachelors or Masters degree in Computer Science/Engineering.
- Excellent communication skills.
- Strong SQL proficiency, and preferably SQL query optimization experience.
- Programming expertise in Python, Scala, and/or Java.
- Experience in databases like Postgres, MySQL, Oracle or SQL Server.
- Familiarity with one of the Cloud data-warehouses like Snowflake, Google BigQuery, AWS Redshift, Azure Synapse, Databricks.
- Good understanding of data modeling, database design, relational/non-relational concepts.
- Good understanding of data engineering fundamentals, ELT / ETL, latency, observability, lineage, distributed storage and distributed computing.
- Familiarity with software production engineering practices, version control, code peer reviews, automated testing, and CI/CD.
- Cloud ecosystem experience within AWS, GCP, or Azure experience, is a plus.
- Experience with modern orchestration platforms, such as Airflow, is a plus.
- Familiarity with docker, kubernetes containerization strategies and optimization, is a plus.
- 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 plus.
What We Have to Offer:
- Competitive salary + bonus + equity
- Generous PTO + 11 company holidays
- Open sick time
- Medical, Dental & Vision
- RRSP w/matching
- Paid professional development
- Leadership & growth opportunities
- Virtual company and team building events
The base salary range in Canada for this full-time position is $ 94,600 – $118,300 + bonus + equity + benefits. Our salary ranges are determined by role, level, and location. The range displayed on each job posting reflects the minimum and maximum target for new hire salaries for the position across all U.S. and Canada locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training. Your recruiter can share more about the specific salary range for your preferred location during the hiring process.
Canada – System1’s headquarters is located in Marina del Rey, CA with additional offices in Bellevue, WA and Guelph, ON, Canada. Employees near office locations are returning to the office. Location-specific policies and available accommodations will be discussed during the interview process.
