Senior BI Engineer
Guelph, CAN
Business Intelligence /
Full-time /
Hybrid
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.
