Back to jobs

Business Intelligence Specialist

Pay
$75,000–90,000/year — pay source
Work Arrangement: Hybrid (1–3 days remote per week) Compensation:$75K to $90K per annum as base Job Description (English)
Read the full posting
Work setting
Not stated
Employment
Permanent — employment source
emergiTEL is hiring a Business Intelligence Specialist for our client in the Energy / Nuclear industry. This is a Permanent role. Location: Toronto, Ontario
Read the full posting

What you’ll work on

Full posting
  • Design, develop, maintain, and optimize complex Microsoft Access databases supporting various business functions.

  • Support the redesign and modernization of existing database applications and web-based user interfaces.

  • Work with cross-functional teams to understand business requirements and translate them into technical solutions.

From the employer’s posting
Microsoft Access Database Development & Maintenance Design, 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.
Application Integration & Modernization Support the redesign and modernization of existing database applications and web-based user interfaces. Integrate reporting solutions with web-based applications and existing technology platforms.
Stakeholder Collaboration & Technical Support Work with cross-functional teams to understand business requirements and translate them into technical solutions. Provide database, reporting, and application support to business users.
Education & alternatives
Qualifications & Requirements - Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related discipline. - Proven hands-on experience developing and maintaining complex Microsoft Access databases.
Apply at Conexus Nuclear

Posting record

Report an error

Actively hiringFirst seen by us today, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 2026today
Recorded sightings
2
Last seen by us
Nov 19, 2026
Employer says posted
Nov 11, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 0

Early. Similar jobs usually come down between day 5 and day 43.

From 15,339 similar postings that came down. Coming down is not always a hire.

Conexus Nuclear is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • VBA
  • Grafana
  • MySQL
  • Power BI
  • Power Query
  • SQL Server
  • SSIS
  • Tableau
Where the posting names them
- Develop 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.
- 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.
The Role We 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.
We 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.
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.
- Maintain front-end Access applications throughout the back-end database migration process. SQL Database Development & Migration - Support the migration of existing Microsoft Access back-end databases to structured SQL infrastructure, including SQL Server, MySQL, or MariaDB.
SQL Database Development & Migration - Support 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.
- 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.
ETL, Data Integration & Automation - Develop 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.
- 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.
- 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 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 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.
- 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.
- 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.
- Support 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.
- 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.
- Ensure data accuracy and consistency throughout migration activities. Power BI, Grafana & Business Intelligence Reporting - Develop and maintain interactive Power BI and Grafana dashboards and live reports.
Power BI, Grafana & Business Intelligence Reporting - Develop 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.
Preferred Skills & Experience - Experience with Grafana, Tableau, or other business intelligence platforms. - Experience with SQL Server Management Studio (SSMS), MySQL Workbench, 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.
- Experience with version control for database scripts, SQL definitions, and reporting solutions. - Microsoft Access and/or Power BI certifications are considered an asset. Work Environment

Your next step

Complete your application on emergitel.catsone.com. The employer’s form will show what is required.

Already applied? Track this application

Job description

View original posting ↗

emergiTEL is hiring a Business Intelligence Specialist for our client in the Energy / Nuclear industry. This is a Permanent role.

Location: Toronto, Ontario
Work Arrangement: Hybrid (1–3 days remote per week)
Compensation:$75K to $90K per annum as base

Job Description (English)

The Role

We 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 Responsibilities

Microsoft Access Database Development & Maintenance

  • Design, 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 & Migration

  • Support 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 Reporting

  • Develop 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.

  • Publish and maintain browser-based dashboards and reports.

  • Implement scheduled reporting, role-based access, and row-level security.

  • Optimize reporting queries and dashboards for performance and usability.

ETL, Data Integration & Automation

  • Develop 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 & Modernization

  • Support 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 Support

  • Work 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 & Requirements

  • Bachelor'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 & Experience

  • Experience 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.

Work Environment

  • 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.

Vacancy Status / Statut du poste

This is an active position currently open for hiring.

Use of Artificial Intelligence / Utilisation de l'intelligence artificielle

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.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 25% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 990, the most 1,513, and the latest week had 1,366.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Work Arrangement: Hybrid (1–3 days remote per week) Compensation:$75K to $90K per annum as base Job Description (English)
Location & working pattern

Toronto, ON

Location: Toronto, Ontario Work Arrangement: Hybrid (1–3 days remote per week) Compensation:$75K to $90K per annum as base
More source context
- 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.
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.