Position Description & QualificationsPurpose of the Job: This position exists to drive optimization of contract performance efficiency and profitability using data performance measurement systems, specifically…Create business intelligence tools and reports, such as physical data models and dimensional analyses.Design, code, test, and aggregate results from SQL queries to provide actionable information to users.Create and modify enterprise resource planning (ERP) system of integrated applications in Service Now to manage the business and automate office functions. Drive continuous service delivery and productivity improvements.Primary Duties and Responsibilities:Data Mining: Accessing raw data sources (QMatic, Scheduler, CostPoint etc. to extract data required for analysis/ business improvement purposes.Data Formatting & Design: Translation of raw data into an intelligible format to facilitate analysis or for direct reporting. Design, build and deploy BI solutions (Automation of NIs to DT website, extended hours invoicing, KPI monitoring systems, employee performance monitoring, etc.) in Service Now or other BI tools. Create event server, custom objects, reporting,



data archive, schedule tasks, database tasks. Create tools to store data (e.G. SQL tables, OLAP cubes). Develop, implement, and optimize stored procedures, triggers and functions using T‑SQL.Data Analysis: Interpretation of formatted data to identify trends & areas requiring further investigation with a view to solutioning. Review and interpret ongoing business report requirements. Build appropriate and helpful reporting deliverables. Analyze existing SQL queries for performance improvements.General Reporting: Ensure problem‑free generation of regularly scheduled reports (various KPI reports and other internal reports) and timely generation of ad‑hoc reports. Oversight of all reports with standing objective to reduce report volumes & automate wherever possible.Business Intelligence Development & Maintenance: Ongoing development of Power BI or other DES business intelligence tool i.E. development of screens/ dashboards/ reporting as required and routine maintenance tasks (access controls,

📌 Bus Intelligence Developer-Full-Time- Term-Downsview (Toronto)
🏢 United States Digital Space
📍 Toronto