Business Intelligence Specialist

Full Time
  • Full Time
  • Toronto

Teacup Tech Systems

Please apply ONLY if you have Public Service Experience in Canada

Experience and Skill Set Requirements:


  • Experience of 7+ years of working with SQL Server, ADF and T-SQL Development
  • Experience working with building Databases, Data Warehouse and Data Mart and working with delta / incremental and full loads
  • Experience with any ETL tools such as SQL Server, ADF, Cloud tools
  • Experience working with MSSQL Sever on premise and within Azure Environment
  • Experience on Data modeling, and tools – e.g. SAP Power Designer,
  • Experience with snowflake and star schema model. Experience in designing data warehouse solutions using slowly changing dimensions.
  • Experience working with SQL Server SSIS and other ETL tools, solid knowledge and experience with SQL, other RDBMS (SQL Server, SSIS)
  • Understanding data warehouse architecture with a data vault, dimensional data and fact model.
  • Analyze, design, develop, test and document ETL programs from detailed and high-level specifications, and assist in troubleshooting.
  • Utilize SQL to perform tasks other than data transformation (DDL, complex queries)
  • Good knowledge of database performance optimization techniques
  • Ability to assist in the requirements analysis and subsequent developments
  • Ability to conduct unit tests and assist in test preparations to ensure data integrity
  • Work closely with Designers, Business Analysts and other Developers
  • Liaise with Project Managers, Quality Assurance Analysts and Business Intelligence Consultants
  • Design and implement technical enhancements of Data Warehouse as required.


  • 7+ years in ETL tools such as Microsoft SSIS, stored procedures
  • 2+ Azure Data Lake and Data Warehouse, and building Azure Data Factory pipelines
  • 2+ years Python
  • Databricks
  • Synapse (nice to have)
  • SQL Server
  • Oracle
  • Ability to present technical requirements to the business


To apply, please visit the following URL: