Business Intelligence Data Engineer
Summary
Builds and maintains business intelligence solutions at OSL Retail Services: translating stakeholder needs into specs, modeling warehouse data, and creating automated data flows into Postgres. Core stack includes complex SQL, Apache Airflow, Spark, Python/R, and REST APIs.
Build business intelligence solutions with complex SQL, automated data flows, and reporting as a Data Engineer in Mississauga, Canada. Work directly with stakeholders.
Reporting to the Manager, Data Systems, this Data Engineer develops and maintains business intelligence solutions. You will translate needs into technical specifications, model warehouse data, and create analytical structures for self-service. The work includes APIs, SaaS platforms, Postgres, Airflow, Spark, and SQL.
Key Responsibilities:
- Translate business needs into technical specifications with stakeholders
- Build automated data flows into Postgres from varied sources
- Model warehouse data and create analytical structures
- Maintain reporting and existing data workflows
- Optimize SQL and troubleshoot pipeline failures through logs
Requirements:
- Experience as a Data Developer, analyst, engineer, or Data Scientist
- Background in warehouse design and dimensional modeling
- Understanding of database management systems and ETL frameworks
- Experience with Apache Airflow, Spark, and complex SQL
- Knowledge of Python or R, REST APIs, and visualization tools
Apply your SQL, data modeling, and pipeline expertise to business intelligence solutions supporting OSL Retail Services.