Business Intelligence Specialist
$75k - $90k per yearemergiTEL Inc.
EmergiTEL
is hiring a
Business Intelligence Specialist
for our client in the
Energy / Nuclear industry. This is a
Permanent
role.
Location:
Toronto, OntarioWork Arrangement:
Hybrid (1–3 days remote per week)Compensation: $75K to $90K per annum as base
Job Description (English)The RoleWe are seeking a highly skilled and detail-oriented Business Intelligence Specialist with strong expertise in Microsoft Access, SQL database development, and Power BI reporting.
This role will be responsible for developing, maintaining, and modernizing complex Microsoft Access databases while supporting the migration of back-end data to structured SQL infrastructure. The successful candidate will also design and maintain interactive Power BI and Grafana dashboards, develop automated data pipelines, and ensure data integrity across the organization.
This is a hands‑on technical role requiring a combination of legacy database management, SQL development, data migration, business intelligence, and application modernization experience.
The ideal candidate will be comfortable working with existing, potentially undocumented database environments while driving improvements in data architecture, reporting, automation, and system reliability.
Key ResponsibilitiesMicrosoft Access Database Development & MaintenanceDesign, develop, maintain, and optimize complex Microsoft Access databases supporting various business functions.
Maintain existing file-level database environments, including front‑end, back‑end, and global code bases.
Develop and optimize Access tables, queries, forms, reports, macros, and VBA components.
Troubleshoot database issues and ensure application reliability and data integrity.
Maintain front‑end Access applications throughout the back‑end database migration process.
SQL Database Development & MigrationSupport the migration of existing Microsoft Access back‑end databases to structured SQL infrastructure, including SQL Server, MySQL, or MariaDB.
Perform database assessments and inventory existing tables, queries, forms, reports, macros, and VBA dependencies.
Design and implement normalized relational database schemas, including keys, constraints, relationships, and data types.
Develop and optimize advanced SQL queries, joins, CTEs, stored procedures, functions, and views.
Apply indexing strategies and query optimization techniques to improve database performance.
Plan and execute database migration activities, including data mapping, validation, parallel testing, cutover, and rollback.
Ensure data accuracy and consistency throughout migration activities.
Power BI, Grafana & Business Intelligence ReportingDevelop and maintain interactive Power BI and Grafana dashboards and live reports.
Create business intelligence reports covering operational metrics, KPIs, project performance, and other business requirements.
Develop Project Cost Performance Index (CPI) and Schedule Performance Index (SPI) reporting.
Connect Power BI to multiple data sources, including Microsoft Access and SQL databases.
Design data models and reporting structures that provide meaningful insights to business stakeholders.
Implement scheduled reporting, role‑based access, and row‑level security.
Optimize reporting queries and dashboards for performance and usability.
ETL, Data Integration & AutomationDevelop automated data transfer and ETL pipelines between Access, Excel, flat files, and SQL platforms.
Use tools such as Navicat, SSIS, Power Query, Python, and PowerShell to automate data movement and validation.
Implement full and incremental data loading processes.
Establish error handling, logging, monitoring, and repeatable execution procedures.
Perform data profiling, cleansing, and reconciliation to identify duplicates, missing records, inconsistent codes, and data conversion issues.
Maintain accurate validation records, control totals, and reconciliation reports.
Application Integration & ModernizationSupport the redesign and modernization of existing database applications and web‑based user interfaces.
Integrate reporting solutions with web‑based applications and existing technology platforms.
Work with ODBC/OLE DB connections, REST/JSON data access, and database connectivity configurations.
Collaborate with infrastructure and application development teams on deployment and environment promotion from development to testing and production.
Support ongoing improvements to custom‑built business applications and internal IT tools.
Stakeholder Collaboration & Technical SupportWork with cross‑functional teams to understand business requirements and translate them into technical solutions.
Provide database, reporting, and application support to business users.
Troubleshoot technical issues and investigate data discrepancies to identify root causes.
Explain technical limitations, risks, and recommended solutions to non‑technical stakeholders.
Prepare technical documentation, database mappings, migration plans, and operational procedures.
Provide training and knowledge transfer to end users and internal teams.
Manage multiple priorities, project deliverables, and support requests while ensuring timely completion.
Qualifications & RequirementsBachelor's degree in Computer Science, Information Technology, Software Engineering, or a related discipline.
Proven hands‑on experience developing and maintaining complex Microsoft Access databases.
Strong experience with Access tables, queries, forms, reports, macros, and VBA.
Demonstrated experience migrating Microsoft Access databases to SQL Server, MySQL, or MariaDB.
Strong proficiency in SQL, including advanced queries, joins, CTEs, stored procedures, indexing, and performance optimization.
Hands‑on experience with Power BI dashboard and report development.
Experience with relational database design, data modelling, and data warehousing principles.
Strong understanding of ETL processes, data migration, data validation, and reconciliation.
Experience integrating multiple data sources and automating data pipelines.
Excellent analytical, troubleshooting, and problem‑solving skills.
Strong communication skills with the ability to work effectively with technical and non‑technical stakeholders.
Ability to manage multiple projects and work independently in a fast‑paced environment.
Preferred Skills & ExperienceExperience with Grafana, Tableau, or other business intelligence platforms.
Experience with SQL Server Management Studio (SSMS), MySQL Workbench, or MariaDB.
Familiarity with Navicat, SSIS, SQL Server Migration Assistant (SSMA), and Power Query.
Experience with Python, PowerShell, SQL Agent, or Windows Task Scheduler.
Experience with web‑based reporting, report embedding, and scheduled distribution.
Knowledge of role‑based security, row‑level security, and single sign‑on.
Experience with version control for database scripts, SQL definitions, and reporting solutions.
Microsoft Access and/or Power BI certifications are considered an asset.
Based in Toronto, Ontario.
Hybrid work arrangement with the opportunity to work remotely 1–3 days per week.
Collaborative IT environment involving database development, application modernization, business intelligence, and technology transformation.
Opportunity to contribute to the modernization of legacy database infrastructure and the development of scalable reporting solutions.
This is an active position currently open for hiring.
emergiTEL uses artificial intelligence to help identify and source candidates for this role. All assessment and selection decisions are made by our recruiters, a human is always involved, and no applicant is evaluated or rejected by automated means alone.
#J-18808-Ljbffr
is hiring a
Business Intelligence Specialist
for our client in the
Energy / Nuclear industry. This is a
Permanent
role.
Location:
Toronto, OntarioWork Arrangement:
Hybrid (1–3 days remote per week)Compensation: $75K to $90K per annum as base
Job Description (English)The RoleWe are seeking a highly skilled and detail-oriented Business Intelligence Specialist with strong expertise in Microsoft Access, SQL database development, and Power BI reporting.
This role will be responsible for developing, maintaining, and modernizing complex Microsoft Access databases while supporting the migration of back-end data to structured SQL infrastructure. The successful candidate will also design and maintain interactive Power BI and Grafana dashboards, develop automated data pipelines, and ensure data integrity across the organization.
This is a hands‑on technical role requiring a combination of legacy database management, SQL development, data migration, business intelligence, and application modernization experience.
The ideal candidate will be comfortable working with existing, potentially undocumented database environments while driving improvements in data architecture, reporting, automation, and system reliability.
Key ResponsibilitiesMicrosoft Access Database Development & MaintenanceDesign, develop, maintain, and optimize complex Microsoft Access databases supporting various business functions.
Maintain existing file-level database environments, including front‑end, back‑end, and global code bases.
Develop and optimize Access tables, queries, forms, reports, macros, and VBA components.
Troubleshoot database issues and ensure application reliability and data integrity.
Maintain front‑end Access applications throughout the back‑end database migration process.
SQL Database Development & MigrationSupport the migration of existing Microsoft Access back‑end databases to structured SQL infrastructure, including SQL Server, MySQL, or MariaDB.
Perform database assessments and inventory existing tables, queries, forms, reports, macros, and VBA dependencies.
Design and implement normalized relational database schemas, including keys, constraints, relationships, and data types.
Develop and optimize advanced SQL queries, joins, CTEs, stored procedures, functions, and views.
Apply indexing strategies and query optimization techniques to improve database performance.
Plan and execute database migration activities, including data mapping, validation, parallel testing, cutover, and rollback.
Ensure data accuracy and consistency throughout migration activities.
Power BI, Grafana & Business Intelligence ReportingDevelop and maintain interactive Power BI and Grafana dashboards and live reports.
Create business intelligence reports covering operational metrics, KPIs, project performance, and other business requirements.
Develop Project Cost Performance Index (CPI) and Schedule Performance Index (SPI) reporting.
Connect Power BI to multiple data sources, including Microsoft Access and SQL databases.
Design data models and reporting structures that provide meaningful insights to business stakeholders.
Implement scheduled reporting, role‑based access, and row‑level security.
Optimize reporting queries and dashboards for performance and usability.
ETL, Data Integration & AutomationDevelop automated data transfer and ETL pipelines between Access, Excel, flat files, and SQL platforms.
Use tools such as Navicat, SSIS, Power Query, Python, and PowerShell to automate data movement and validation.
Implement full and incremental data loading processes.
Establish error handling, logging, monitoring, and repeatable execution procedures.
Perform data profiling, cleansing, and reconciliation to identify duplicates, missing records, inconsistent codes, and data conversion issues.
Maintain accurate validation records, control totals, and reconciliation reports.
Application Integration & ModernizationSupport the redesign and modernization of existing database applications and web‑based user interfaces.
Integrate reporting solutions with web‑based applications and existing technology platforms.
Work with ODBC/OLE DB connections, REST/JSON data access, and database connectivity configurations.
Collaborate with infrastructure and application development teams on deployment and environment promotion from development to testing and production.
Support ongoing improvements to custom‑built business applications and internal IT tools.
Stakeholder Collaboration & Technical SupportWork with cross‑functional teams to understand business requirements and translate them into technical solutions.
Provide database, reporting, and application support to business users.
Troubleshoot technical issues and investigate data discrepancies to identify root causes.
Explain technical limitations, risks, and recommended solutions to non‑technical stakeholders.
Prepare technical documentation, database mappings, migration plans, and operational procedures.
Provide training and knowledge transfer to end users and internal teams.
Manage multiple priorities, project deliverables, and support requests while ensuring timely completion.
Qualifications & RequirementsBachelor's degree in Computer Science, Information Technology, Software Engineering, or a related discipline.
Proven hands‑on experience developing and maintaining complex Microsoft Access databases.
Strong experience with Access tables, queries, forms, reports, macros, and VBA.
Demonstrated experience migrating Microsoft Access databases to SQL Server, MySQL, or MariaDB.
Strong proficiency in SQL, including advanced queries, joins, CTEs, stored procedures, indexing, and performance optimization.
Hands‑on experience with Power BI dashboard and report development.
Experience with relational database design, data modelling, and data warehousing principles.
Strong understanding of ETL processes, data migration, data validation, and reconciliation.
Experience integrating multiple data sources and automating data pipelines.
Excellent analytical, troubleshooting, and problem‑solving skills.
Strong communication skills with the ability to work effectively with technical and non‑technical stakeholders.
Ability to manage multiple projects and work independently in a fast‑paced environment.
Preferred Skills & ExperienceExperience with Grafana, Tableau, or other business intelligence platforms.
Experience with SQL Server Management Studio (SSMS), MySQL Workbench, or MariaDB.
Familiarity with Navicat, SSIS, SQL Server Migration Assistant (SSMA), and Power Query.
Experience with Python, PowerShell, SQL Agent, or Windows Task Scheduler.
Experience with web‑based reporting, report embedding, and scheduled distribution.
Knowledge of role‑based security, row‑level security, and single sign‑on.
Experience with version control for database scripts, SQL definitions, and reporting solutions.
Microsoft Access and/or Power BI certifications are considered an asset.
Based in Toronto, Ontario.
Hybrid work arrangement with the opportunity to work remotely 1–3 days per week.
Collaborative IT environment involving database development, application modernization, business intelligence, and technology transformation.
Opportunity to contribute to the modernization of legacy database infrastructure and the development of scalable reporting solutions.
This is an active position currently open for hiring.
emergiTEL uses artificial intelligence to help identify and source candidates for this role. All assessment and selection decisions are made by our recruiters, a human is always involved, and no applicant is evaluated or rejected by automated means alone.
#J-18808-Ljbffr
Vacancy posted 1 hour ago
Similar jobs that could be interesting for youBased on the Business Intelligence Specialist in Winnipeg, MB vacancy
- ...Business Intelligence Analyst Location: Winnipeg, MB (Onsite) Turning Information into Business Intelligence. Driving Better Decisions. ODRA is a fast-growing North American manufacturer on a strong upward trajectory Internationally. Demand for our premium street...SuggestedFull timeFor contractors
$96.9k - $136.8k per year
...Location:Toronto, Ontario, Canada Hours:37.5 Line of Business:Analytics, Insights, & Artificial Intelligence Pay Details:$96,900 - $136,800 CAD TD is... ...Description :Ready to be TD's top business intelligence specialist and to champion a significant and diverse set of...SuggestedWork from home$95 - $100 per hour
Job Role: Business Intelligence Specialist – Senior (OBIEE experience)Location: Toronto, ON/OnsitePosition Type: Contract RoleStart Date2026-02-09End Date2026-12-31The candidate is required to work onsite 5 days a weekIdeal Rate: CAD 95-100/Hr (Depend upon experience)Must Have...SuggestedDaily paidContract work- RQ09327 - Business Intelligence SpecialistAbout the job RQ09327 - Business Intelligenceh3 Responsibilities Supports Clients wide-ranging business information requirements, implementing and supporting business intelligence software solutions. Develops and supports customized...SuggestedManual laborWork at office
- Position Summary The Senior Business Intelligence Specialist plays a critical role in transforming data into actionable business insights that support strategic decision-making across SSRU and Ryan Specialty Canada. This role serves as a key partner to business leaders, leveraging...Suggested
- Apply OBIEE, Oracle Analytics Cloud, and SQL expertise as a Senior Business Intelligence Specialist supporting the IFIS in Cloud Project. This assignment focuses on Oracle analytics solutions.The senior specialist validates requirements, updates designs, and develops customer...
- RQ08930 - Business Intelligence Specialist - SeniorAbout the jobNote: Candidate needs to be "Onsite" -3 days in a week As part of the modernization of Social Assistance (SA) reporting platform (Legacy Cognos system), conduct a review of existing data model(s), report model...Contract workInternshipFlexible hours3 days per week
- RQ09097 - Business Intelligence Specialist - SeniorHybrid Work Environment: The successful candidate is expected to work onsite at 222 Jarvis St 3 days per week, and may work remotely up to 2 days per week. Responsibilities Lead the report conversion activities from BOEXI...Manual laborRemote work2 days per week3 days per week
- RQ07952 - Sr. Business Intelligence SpecialistMust Haves: Demonstrates experience working and communicating directly with stakeholders Managing... ...Understanding ministry data challenges and issues BI Specialist mix of Dev and BA – 7+ years Must Haves: Demonstrated...Weekend work
- RQ07951 - Sr. Business Intelligence SpecialistPosition responsible for delivering and supporting advanced business intelligence (BI) solutions to a broad client portfolio. The role requires deep expertise in data management, analytics, and stakeholder engagement across diverse...
- RQ08214 - Sr. Business Intelligence Specialist About the job RQ08214 - Sr. Business Intelligence Specialist A Senior Business Intelligence Specialist FFS resource is needed for the IFIS in Cloud Project for the below deliverables:Validate business requirements and update...
- RQ06224 - Business Intelligence Specialist - Senior Toronto, ON, CanadaJob Openings RQ06224 - Business Intelligence Specialist - SeniorAbout the job RQ06224 - Business Intelligence Specialist - Senior Experience in business intelligence software development and a number...
- RQ08739 - Business Intelligence Specialist - SeniorJob Openings RQ08739 - Business Intelligence Specialist - Senior About the job RQ08739 - Business Intelligence Specialist - SeniorResponsibilities: Document the new requirements and complete analysis and design document...Flexible hours
- ...boldly embrace innovation in all areas as we continue to grow our business into the future. Working with us means you’ll be part of a... ...As a Senior Technical Analyst, Data Engineering and Business Intelligence, at Fidelity Investments Canada, you will focus on building, automating...Work at officeFlexible hours
$135.2k - $202.8k per year
...obligations to merchants, customers, and authorities worldwide. Reconciliation and financial reporting are essential to running a payments business, and given our transaction volume, this role has direct, measurable impact on financial accuracy and trust.As a Senior Analyst on the...Work at officeRemote workWorldwideFlexible hours$90.3k - $112.9k per year
...Atlantic, your ideas matter, your growth is supported and your work makes a real impact. The Opportunity The Developer, Business Intelligence plays a vital role in Atlantic's Technical Services Group, bringing expertise in the Power platform (Power Bi, Power Automate,...Work at officeLocal areaShift work- ...Consulting Inc.Responsibilities Responsibilities are but not limited to: Communicating and Presenting Effectively: The Business Intelligence Analyst must be an expert communicator, capable of presenting complex information in a clear and tailored manner to various audiences...Contract work
$70k - $80k per year
...ambition has a home here. About The RoleAre you ready to lead the analytics function that shapes how our business makes decisions? We’re seeking a Business Intelligence Partner to join our Operations & Business Intelligence team — setting the analytics and reporting...InternshipLocal areaFlexible hours- ...solutions, while focusing on the front-end interface in Power BI.Participate in the stakeholder requirement workshops/meetings and ensure business requirements are adequately captured in SOW.In collaboration with BI Developer, support development of data solutions, including data...Work at officeWork from home
$140k - $160k per year
...only as great as our people. Strong performance leads to high expectations, and we must keep raising the bar! The Director, Business Intelligence will lead enterprise-wide analytics strategy and will be responsible for building and leading a high-performing team of analysts...- ...OVERVIEW Are you passionate about artificial intelligence and, more importantly, about the tangible value it can create for businesses? Do you enjoy turning complex topics into... ...methodologies.Collaborate with internal specialists, delivery consultants and external partners...Long term contractFlexible hours
- 4 days ago Be among the first 25 applicants Get AI-powered advice on this job and more exclusive features. Business Intelligence Lead – Symbio (Government of New Brunswick)Location: Remote (Monthly travel to New Brunswick, Canada) Duration: 2 Years + Renewals Start...Remote work
- Business Intelligence Lead - Montreal, CanadaOur client, a leading organization in the healthcare and pharmaceutical space! They are seeking a Business Intelligence Lead to play a pivotal role in shaping the organization’s commercial strategy by using data to generate...Work at officeWork from homeHome office
- The Business Intelligence Analyst is a role within the Analytics and Optimization team reporting to the Manager, BI Analytics. The individual will be responsible for managing and delivering reporting and analytics solutions, working closely with other teams to support all...Internship
- ...join Kobo and come help us on our mission of making reading lives better.The Role Rakuten Kobo Inc. is seeking an experienced Business Intelligence Developer to evolve our reporting suite using Google BigQuery and visualization tools such as Tableau, Domo, or Looker. The...Casual workWork at officeRemote workWorldwideFlexible hoursWeekend work
$100k - $300k per year
...Partners has partnered with an established Western Canadian civil construction and industrial services organization to recruit a Manager, Business Development - Mining. This position can be based inVancouver, Kamloops or Prince George, British Columbia. CA$100,000.00–CA$300,...Long term contractFull timeContract workFor contractorsRemote work$76.8k - $115.2k per year
Work Location: Montréal, Quebec, CanadaHours: 37.5Line of Business: Analytics, Insights, & Artificial IntelligencePay Details: $76,800... ...campaigns using HTML and AMPscript.Provide guidance and train specialists on basic SFMC capabilities and deployment best practices.Bring...Work from home- ...celebrate Great People who inspire meaningful connections while Leading the Way to Better Living™. We are searching for a Business Intelligence Analyst to join our Analytics and Innovation Team in Halifax, Nova Scotia . Meaningful BenefitsYou will be...Immediate start
- ...policies. At Bombardier, we design, build and maintain the world’s peak-performing aircraft for the world’s most discerning people and businesses, governments and militaries. We have been successful in setting the highest standards by putting our people at the heart of it all,...Flexible hours
$88k per year
...drives operational performance, quality improvement, and automation support. They provide operational analysis to allow for optimal business decisions in Distribution Centers. In a fast-paced environment, they find data-driven solutions under tight deadlines while collaborating...Permanent employmentWork at officeRemote workMonday to friday
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Business Intelligence Specialist. Be the first to apply!
Related searches
- business intelligence manager Winnipeg, MB
- business intelligence Winnipeg, MB
- spécialiste bi Winnipeg, MB
- business services work from home Winnipeg, MB
- business process analyst Winnipeg, MB
- business summer student Winnipeg, MB
- business finance Winnipeg, MB
- entry level business Winnipeg, MB
- summer business internship Winnipeg, MB
- international business Winnipeg, MB

