Business Intelligence Analyst developing reporting and analytics solutions supporting GS1 Canada’s strategic objectives. Leading projects and mentoring within the BI team to drive continuous improvement.
Responsibilities
Confer with internal clients and stakeholders to gather and document business requirements.
Conduct root cause analysis to assess business needs, success criteria, and timelines for reporting and analytical solutions.
Design, develop, integrate, test, and implement business intelligence and reporting solutions using SQL, Excel, VBA, Power BI, Python, and other database technologies.
Refresh and enhance GS1 Canada’s TrueSource™ Dashboard, ensuring its continued accuracy, usability, and relevance to industry stakeholders.
Support the optimization of ETL processes, data models, and workflows to strengthen data quality and accessibility.
Conduct detailed system tests, validating data accuracy and functionality before deployment.
Resolve data inconsistencies and identify opportunities to improve data quality and reliability.
Produce reports, technical documentation, and Standard Operating Procedures (SOPs) to support data management and reporting standards.
Support data governance initiatives by maintaining consistent data definitions, naming conventions, and documentation practices.
Schedule and automate recurring tasks to reduce manual effort and increase departmental efficiency.
Develop KPIs, dashboards, and forecasting models that support continuous improvement and data-driven decision-making across GS1 Canada’s Industry Managed Solutions.
Lead migration efforts and support the successful transition of reporting and analytical solutions across platforms and systems.
Mentor and support new hires through onboarding, training, and knowledge-sharing initiatives.
Identify and drive new BI initiatives focused on automation, process improvement, analytics modernization, and operational efficiency.
Provide leadership and guidance to team members while supporting cross-functional collaboration and project delivery priorities.
Requirements
Bachelor’s degree in business, Computer Science, Statistics, or a related field.
3–5 years of experience in a Business Intelligence, Data Analyst, or analytics-focused role.
Prior experience leading projects, mentoring team members, or coordinating cross-functional initiatives is considered an asset.
Strong proficiency in SQL, Power BI, Excel (including Power Query and VBA), and relational databases.
Experience with Python for data manipulation and automation.
Knowledge of data modeling concepts, ETL processes, and BI best practices.
Experience validating, troubleshooting, and improving data quality.
Experience supporting enterprise reporting environments, dashboard modernization, and migration initiatives.
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.
Senior BI Data Engineer building data pipelines, warehouses, and reporting solutions for Trillium Health Partners hospitals. Leading Microsoft BI architecture, integration, and technical delivery.
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.