Senior BI Data Engineer building data pipelines, warehouses, and reporting solutions for Trillium Health Partners hospitals. Leading Microsoft BI architecture, integration, and technical delivery.
Responsibilities
Provide technical direction, standards, quality control oversight, and expertise across BI projects
Manage data integration from multiple sources, including data transformation and cleansing
Define data models and schemas for efficient storage and retrieval
Design and build data pipelines for extracting, transforming, cleaning, and loading data
Optimize data processing using indexing, partitioning, and clustering
Design, develop, and deploy BI infrastructure and tools for data analysis and reporting
Design and maintain logical and physical architecture for organizational data systems
Design, develop, deploy, monitor, and maintain integrated databases according to industry standards
Troubleshoot technical issues and provide technical support to BI teams and stakeholders
Write functional and technical specifications and user documentation
Consult internal and external stakeholders to collect requirements and design integrated BI solutions
Ensure data is accurate, accessible, secure, and useful for data-driven decisions
Facilitate collaboration, share best practices, promote innovation, coach team members, and communicate issues promptly
Report jointly to the Director of Business Intelligence and Data Governance and the Manager of Cogito and Business Intelligence
Requirements
University degree with related experience in Computer Science, Management or related field
More than 5 years of Business Intelligence work experience in the Microsoft BI stack
Expert knowledge of data modeling, SSRS, SSAS, Tabular Models/Cubes, SQL Server (2016–2023), PowerPivot, PowerView, and advanced SQL scripting
Strong proficiency in Python, Java, Scala, C#, or PowerShell
Experience managing or leading large BI projects or processes with limited oversight
Experience coaching, reviewing, and delegating work to Junior BI professionals
Experience with data warehousing solutions and BI tools, including Amazon QuickSight, Azure Synapse Analytics, and Power BI
Experience reporting KPIs and other performance metrics
Experience delivering SSRS reports using relational, dimensional, or OLAP cube data sources
Experience upgrading Business Intelligence solutions for recent Microsoft product releases
Experience administering, upgrading, and migrating Visual Studio 2022+ and TFS
Experience translating business requirements into effective BI solutions
Knowledge of SharePoint and experience developing web forms in .NET
Knowledge of SQL Server database performance tuning, optimization, and security
Strong oral and written presentation and communication skills
Ability to work on difficult and complex problems under pressure and tight timelines
Applicants must be eligible to work in Canada
Benefits
Equal opportunity employer
Accommodation throughout the recruitment and selection process for applicants with disabilities
Meaningful human involvement and final review in hiring decisions involving automated tools
Senior BI Engineer building data models, semantic layers, and dashboards for Jobber’s small - business service platform. Driving governed self - service analytics and trusted business metrics.
Business intelligence consultant building Sage Intacct and Sage 300 CRE financial reports. Supporting accounting and operations teams with SQL - integrated, multi - entity reporting solutions.
Senior BI Developer designing SAP Datasphere data solutions for Aecon, an infrastructure construction company. Enabling SAP analytics, integration, governance, and secure enterprise data products.
Senior BI Analyst building Power BI dashboards and data solutions for TD, a global financial institution. Delivering actionable insights through SQL, Databricks, DAX, and Power Query.
Senior Data and BI Engineer building enterprise data lakes, pipelines, and real - time analytics platforms. Supporting utility software provider Systems & Software’s trusted customer insights and operations.
Data Analytics & BI Analyst building dashboards, models, and reporting for CoVet’s AI tools supporting veterinary professionals. Partnering across teams to improve business decisions and data quality.
Business Intelligence Analyst developing data products, dashboards and insights for the Government of Alberta. Supporting data strategy, governance and evidence - based decisions across departments.
Développeur BI chez BEEM, transformant les données d’entreprises en dashboards Power BI et solutions IA. Conception de semantic layers, SQL avancé et livraison de solutions data auprès des clients.
Business Intelligence Analyst developing Power BI dashboards and KPI scorecards. Analyzing retail data to deliver actionable insights for clients and strategic decisions.