Job Description

System1 is looking for a Senior BI Data Engineer to join our Business Intelligence team. The Business Intelligence team is the horizontal layer that supports business intelligence, optimization and external & internal reporting. We process and report on hundreds of millions of events and user attributes daily, gathered from extremely 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 that 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 key to this position. The ideal person will not only be an expert in sql and data structures but also a collaborative team player with infectious energy and a desire to communicate ideas with colleagues.

Our database systems primarily include Snowflake, but also Postgres and MS SQL server. We also utilize various technologies, including Github, Jenkins, DBT, Airflow, , 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 full engineering lifecycle: designing, ticketing, building, testing, deploying, and debugging tools and products
• Assist the BI, Data Science, and Marketing teams with data investigations.

• 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 (

• 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 into scalable sql scripts and structures
• Ability to learn new tools, skills and workflows quickly

• Competitive salary + bonus + equity
• Generous PTO + 11 company holidays
• Untracked sick time
• 100% covered Medical, Dental and Vision top-ups for employees
• RRSP w/matching
• Paid professional development
• Leadership & growth opportunities
• Virtual company and team building events
• #BI-Remote
• #LI-Remote
• #LI-AW1