Senior BI Engineer @ System1

System1 seeks a Senior BI Data Engineer to join our Business Intelligence team. The Business Intelligence team is the horizontal layer that supports optimization and external & internal reporting. We process and report on hundreds of millions of events and user attributes daily, gathered from highly heterogeneous data streams.

System1 is growing our Business Intelligence team! As a Senior BI Data Engineer, you will work with engineering teams across System1 to ensure we have the highest data quality in and out of the platform. Within Business Intelligence, you will work closely with Reporting and Data Quality teams to help achieve team collective goals. Attention to detail and a desire to learn are critical to this position. The ideal person will be an expert in SQL and data structures and a collaborative team player with infectious energy and a desire to communicate ideas with colleagues.

Our database system is Snowflake. We also utilize various technologies, including Github, Jenkins, DBT, Airflow, Astronomer.io, Docker, Tableau.

The Role You Will Have:

Build/maintain BI datamart structure collaboratively with BI team
Design and build summary/aggregation tables for end-user and BI consumption
Ensure self-recovery/healing/notifications of datamarts as new data arrive throughout the day
Serve as a key individual contributor within the BI team
Take projects through the complete engineering lifecycle: designing, ticketing, building, testing, deploying, and debugging tools and products
Assist the BI, Data Science, and Marketing teams with data investigations

What You Will Bring:

Bachelor’s Degree (technical or science) preferred
8+ years working in SQL (Snowflake / Postgres / MySQL / MSSQL or related) in a production environment
Demonstrated advanced sql query skills (CTE’s, merge statements, stored procedures, UDF’s, query optimization, multi-table joins, views, computed columns, indexes, normalization, temp tables) with very large data sets
Experience working with DBT (getdbt.com)
Experience working with Airflow/Astronomer.io
Experience with Git and working with other developers from the same code base (reviewing other developers’ code, code pairing, GitHub)
Exposure to digital media and ad serving systems a plus
Strong attention to detail
Able to function with imperfect data (strive to do things the right way, but able to accept some compromises along the way)
Able to take business logic definitions and translate them into scalable SQL scripts and structures
Ability to learn new tools, skills and workflows quickly

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 $127,000 - $158,000 + 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.

The Role You Will Have:

What You Will Bring:

What We Have to Offer:

6 month growth

1 year growth

2 year growth

Benefits