Full-Time

Senior BI Engineer

Posted on 5/14/2024

System1

System1

201-500 employees

AI-driven acquisition marketing at scale

Data & Analytics

Senior

Guelph, ON, Canada

Required Skills
Airflow
MySQL
Data Science
Git
SQL
Postgres
Marketing
Snowflake
Requirements
  • 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
Responsibilities
  • 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

If you are looking to work at the forefront of digital marketing technologies, this company is an excellent choice. Their Responsive Acquisition Marketing Platform (RAMP) leverages advanced AI and machine learning to effectively match high-intent customers with advertisers across various channels and verticals. With a strong focus on privacy and innovation in the ad tech industry, they provide a dynamic and forward-thinking environment that supports the development of powerful consumer brands.

Company Stage

IPO

Total Funding

$920M

Headquarters

Los Angeles, California

Founded

2013

Growth & Insights
Headcount

6 month growth

0%

1 year growth

-10%

2 year growth

-4%

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

INACTIVE