Business Intelligence Specialist
$75k - $90k per yearConexus Nuclear Inc.
Salary Range: $75,000.00 To $90,000.00 AnnuallyRole
Business Intelligence SpecialistAssignment
IT DevelopmentLine of Business
Information TechnologyDirector, Information TechnologyPresident & CEOScope (Purpose)
The Microsoft Access & Power BI Specialist will be responsible for designing, developing, enhancing, and maintaining complex Microsoft Access databases, including integrating and migrating back-end data to SQL-based platforms. This role will involve performing a range of database programming and development activities, optimizing data structures and processes, and ensuring data accuracy, consistency, and integrity across the organization. The specialist will also design, develop, and maintain interactive Power BI reports and dashboards, transforming complex data into meaningful insights that support business intelligence, operational efficiency, and informed decision-making.Key Accountabilities
Maintain COG’s file-level database environments including back-end, front-end, and global code baseAid in the back-end data migration to structured SQL infrastructure and in the re-design of new web-based user interfaces. Ensure front-end access databases are maintained throughout the processBuild and maintain Power BI / Grafana based dashboards & live reports for various line of business activities including Metrics, KPIs & Project CPI/SPI and other reporting as required.General Responsibilities
Design, develop, and maintain
Microsoft Access databases
to support business functions.Collaborate with cross-functional teams to gather requirements and translate business needs into technical specifications.Develop and optimize queries, forms, and reports in Access for data analysis and reporting.Create compelling and interactive
Power BI reports and dashboards
that provide actionable insights.Connect Power BI to various data sources, including Access databases, ensuring seamless data integration.Implement data security measures to protect sensitive information within Access and Power BI environments.Provide training and support to end-users on Access database management and Power BI reporting.Stay current with the latest trends and updates in Microsoft Access and Power BI technologies.Requirements
Education & Experience
Bachelor’s degree in computer science, Information Technology, or related field.Proven experience with Microsoft Access database development, including tables, queries, forms, and reports.Strong proficiency in Power BI, Grafana, Tableau (or competing product) for creating reports, dashboards, and data visualizations.Proven experience with SQL and experience administrating MS SQL/MySQL/Maria Servers is a plus.Excellent problem-solving skills and attention to detail.Strong communication and interpersonal skills to interact with team members and stakeholders.Ability to work independently and manage multiple projects simultaneously.Experience with data modeling and data warehousing principles.Familiarity with other BI tools and data analytics software.Certification in Microsoft Access and/or Power BI is highly desirable.Relational database design and data modellingDesigns normalized schemas (keys, constraints, referential integrity, data types) and produces logical/physical models that stand up to multi-user access. Evidence: has modeled a relational database from a flat or file-level source and defended the design choices.Advanced SQL (T-SQL and/or MySQL dialects)Writes and optimizes joins, subqueries, CTEs, window functions, views, stored procedures, functions and triggers;
reads and improves execution plans and applies indexing strategy. Evidence: has tuned a slow report query and quantified the improvement.Legacy database migration (Microsoft Access to SQL Server / MySQL)Hands-on upsizing of .Mdb/.Accdb databases: inventorying tables, queries, forms, reports, macros and VBA dependencies;
mapping Access data types and Jet/ACE behaviours to the target platform;
rebuilding or retiring query and report logic;
planning parallel run, cutover and rollback. Evidence: has personally completed at least one Access-to-SQL migration used in production.ETL / data pipeline developmentBuilds repeatable, scheduled export/import pipelines between Access, Excel, flat files and SQL platforms using tools such as
Navicat
(Data Transfer, Import/Export, Automation) and is willing to work with adjacent tooling (SSMA for Access, SSIS, MySQL Workbench Migration, Power Query, Python) where the task calls for it. Understands full vs. incremental loads, idempotency/re-run safety, dependencies, error handling, logging and alerting.Data quality, profiling and reconciliation controlProfiles and cleanses legacy data before it is trusted: duplicates, orphaned records, inconsistent codes, null and date/number format drift, precision loss on data-type conversion. Establishes control totals (row counts, checksums, amount totals) between source and target and reports exceptionsAutomation and scripting for repeatable operationsAutomates repetitive data movement and validation with PowerShell, Python, SQL Agent/Windows scheduled tasks or Navicat Automation, and uses version control for scripts, DDL and report definitions. Builds for someone else to run it at 2 a.M.Testing, technical documentation and knowledge transferWrites test cases and retains data-validation evidence;
documents schemas, mappings, pipeline designs, and standard operating procedures;
trains lines-of-business users on self-service reporting and hands over supportable solutions rather than dependencies on themselves.Explaining technical constraints and trade-offs to non-technical partnersFrames barriers (data not captured at source, concurrency limits of a file-based database, licence or hardware cost, integration risk) in terms of cost, schedule, risk and options — and brings a recommended option rather than only the problem. Says "here's what we can do instead" credibly.Analytical thinking and problem investigationInvestigates discrepancies to root cause rather than patching a number;
comfortable working with incomplete or undocumented legacy artefacts and reverse-engineering intent from existing Access queries, Excel formulas and user behaviour.Managing concurrent demands and owning deliveryHandles a queue of requests from several lines of business plus multi-week project work;
triages, scopes, estimates and communicates status;
raises issues early;
works within IT service, change and request-management practices.Success Indicators/KPI’s
Timely and efficient completion of software bug resolution for identified issues with custom applications.Timely and efficient completion of project commitments (on time, in scope, on budget).High system/software reliability contributing to efficient ongoing operation, including maintenance & feature improvements of custom-built web applications including (WPS, WPT, CAP DB, IT Datacentre, DMS, FCLMdb & related tooling)New tools implemented with open, honest communications with project teams to identify requirements, build proofs-of-concept for development environments & testing, and deployment into production, for new tools and feature improvements to existing ones.Acceptance and approvals of project scope and cost proposalsEmerging technology/upgrades presented to the team because of staying current on the latest approaches.Delivery of reports and analysis related to security issues so that appropriate measures are taken, and risk minimized.This role is based at the Conexus office in Toronto with the opportunity to work remotely 1-3 days per week.Conexus employees are expected to consistently demonstrate our core values of Integrity, Collaboration, Innovation, Sustainability and Agility, specifically:Acting with respect, transparency and commitment in all relationships and decisionsFostering connection, trust and shared success by bringing the industry together across borders, disciplines, and perspectivesDriving forward-thinking solutions and accelerating advancements that shape the future of nuclear energyDelivering exceptional results and value to advance a clean energy future that supports people, the planet, and progress.Adapting and evolving to meet challenges and realize opportunities in an ever-changing global landscapeAt Conexus, we recognize that supporting our valued employees' wellbeing extends beyond compensation. We offer a total rewards program that includes a pension plan, an annual health spending account, a fitness subsidy as well as life, health, dental and disability benefits, complemented by a truly flexible, hybrid work arrangement.Pay Transparency
Starting salary will be aligned with a candidate's demonstrated qualifications, experience, skills, and internal pay parity.Diversity & Inclusion
Conexus has earned recognition as a diversity leader in the nuclear industry, particularly for our work advancing women in engineering. We are committed to employment equity and diversity in the workplace, and we welcome applications from women, members of racialized groups/visible minorities, Indigenous persons, persons with disabilities, persons of any sexual orientation, and persons of any gender identity or gender expression. Accommodations are available on request throughout the selection process.A N ote on AI in Conexus' Hiring Process
Conexus may use artificial intelligence (AI) or other technology-assisted tools as part of the recruitment and selection process. These tools are intended to support and never replace human decision-making.If you have questions about this job posting, including accessibility needs, please reach out to Human Resources on View email address on ca.hrm.tc
#J-18808-Ljbffr
Business Intelligence SpecialistAssignment
IT DevelopmentLine of Business
Information TechnologyDirector, Information TechnologyPresident & CEOScope (Purpose)
The Microsoft Access & Power BI Specialist will be responsible for designing, developing, enhancing, and maintaining complex Microsoft Access databases, including integrating and migrating back-end data to SQL-based platforms. This role will involve performing a range of database programming and development activities, optimizing data structures and processes, and ensuring data accuracy, consistency, and integrity across the organization. The specialist will also design, develop, and maintain interactive Power BI reports and dashboards, transforming complex data into meaningful insights that support business intelligence, operational efficiency, and informed decision-making.Key Accountabilities
Maintain COG’s file-level database environments including back-end, front-end, and global code baseAid in the back-end data migration to structured SQL infrastructure and in the re-design of new web-based user interfaces. Ensure front-end access databases are maintained throughout the processBuild and maintain Power BI / Grafana based dashboards & live reports for various line of business activities including Metrics, KPIs & Project CPI/SPI and other reporting as required.General Responsibilities
Design, develop, and maintain
Microsoft Access databases
to support business functions.Collaborate with cross-functional teams to gather requirements and translate business needs into technical specifications.Develop and optimize queries, forms, and reports in Access for data analysis and reporting.Create compelling and interactive
Power BI reports and dashboards
that provide actionable insights.Connect Power BI to various data sources, including Access databases, ensuring seamless data integration.Implement data security measures to protect sensitive information within Access and Power BI environments.Provide training and support to end-users on Access database management and Power BI reporting.Stay current with the latest trends and updates in Microsoft Access and Power BI technologies.Requirements
Education & Experience
Bachelor’s degree in computer science, Information Technology, or related field.Proven experience with Microsoft Access database development, including tables, queries, forms, and reports.Strong proficiency in Power BI, Grafana, Tableau (or competing product) for creating reports, dashboards, and data visualizations.Proven experience with SQL and experience administrating MS SQL/MySQL/Maria Servers is a plus.Excellent problem-solving skills and attention to detail.Strong communication and interpersonal skills to interact with team members and stakeholders.Ability to work independently and manage multiple projects simultaneously.Experience with data modeling and data warehousing principles.Familiarity with other BI tools and data analytics software.Certification in Microsoft Access and/or Power BI is highly desirable.Relational database design and data modellingDesigns normalized schemas (keys, constraints, referential integrity, data types) and produces logical/physical models that stand up to multi-user access. Evidence: has modeled a relational database from a flat or file-level source and defended the design choices.Advanced SQL (T-SQL and/or MySQL dialects)Writes and optimizes joins, subqueries, CTEs, window functions, views, stored procedures, functions and triggers;
reads and improves execution plans and applies indexing strategy. Evidence: has tuned a slow report query and quantified the improvement.Legacy database migration (Microsoft Access to SQL Server / MySQL)Hands-on upsizing of .Mdb/.Accdb databases: inventorying tables, queries, forms, reports, macros and VBA dependencies;
mapping Access data types and Jet/ACE behaviours to the target platform;
rebuilding or retiring query and report logic;
planning parallel run, cutover and rollback. Evidence: has personally completed at least one Access-to-SQL migration used in production.ETL / data pipeline developmentBuilds repeatable, scheduled export/import pipelines between Access, Excel, flat files and SQL platforms using tools such as
Navicat
(Data Transfer, Import/Export, Automation) and is willing to work with adjacent tooling (SSMA for Access, SSIS, MySQL Workbench Migration, Power Query, Python) where the task calls for it. Understands full vs. incremental loads, idempotency/re-run safety, dependencies, error handling, logging and alerting.Data quality, profiling and reconciliation controlProfiles and cleanses legacy data before it is trusted: duplicates, orphaned records, inconsistent codes, null and date/number format drift, precision loss on data-type conversion. Establishes control totals (row counts, checksums, amount totals) between source and target and reports exceptionsAutomation and scripting for repeatable operationsAutomates repetitive data movement and validation with PowerShell, Python, SQL Agent/Windows scheduled tasks or Navicat Automation, and uses version control for scripts, DDL and report definitions. Builds for someone else to run it at 2 a.M.Testing, technical documentation and knowledge transferWrites test cases and retains data-validation evidence;
documents schemas, mappings, pipeline designs, and standard operating procedures;
trains lines-of-business users on self-service reporting and hands over supportable solutions rather than dependencies on themselves.Explaining technical constraints and trade-offs to non-technical partnersFrames barriers (data not captured at source, concurrency limits of a file-based database, licence or hardware cost, integration risk) in terms of cost, schedule, risk and options — and brings a recommended option rather than only the problem. Says "here's what we can do instead" credibly.Analytical thinking and problem investigationInvestigates discrepancies to root cause rather than patching a number;
comfortable working with incomplete or undocumented legacy artefacts and reverse-engineering intent from existing Access queries, Excel formulas and user behaviour.Managing concurrent demands and owning deliveryHandles a queue of requests from several lines of business plus multi-week project work;
triages, scopes, estimates and communicates status;
raises issues early;
works within IT service, change and request-management practices.Success Indicators/KPI’s
Timely and efficient completion of software bug resolution for identified issues with custom applications.Timely and efficient completion of project commitments (on time, in scope, on budget).High system/software reliability contributing to efficient ongoing operation, including maintenance & feature improvements of custom-built web applications including (WPS, WPT, CAP DB, IT Datacentre, DMS, FCLMdb & related tooling)New tools implemented with open, honest communications with project teams to identify requirements, build proofs-of-concept for development environments & testing, and deployment into production, for new tools and feature improvements to existing ones.Acceptance and approvals of project scope and cost proposalsEmerging technology/upgrades presented to the team because of staying current on the latest approaches.Delivery of reports and analysis related to security issues so that appropriate measures are taken, and risk minimized.This role is based at the Conexus office in Toronto with the opportunity to work remotely 1-3 days per week.Conexus employees are expected to consistently demonstrate our core values of Integrity, Collaboration, Innovation, Sustainability and Agility, specifically:Acting with respect, transparency and commitment in all relationships and decisionsFostering connection, trust and shared success by bringing the industry together across borders, disciplines, and perspectivesDriving forward-thinking solutions and accelerating advancements that shape the future of nuclear energyDelivering exceptional results and value to advance a clean energy future that supports people, the planet, and progress.Adapting and evolving to meet challenges and realize opportunities in an ever-changing global landscapeAt Conexus, we recognize that supporting our valued employees' wellbeing extends beyond compensation. We offer a total rewards program that includes a pension plan, an annual health spending account, a fitness subsidy as well as life, health, dental and disability benefits, complemented by a truly flexible, hybrid work arrangement.Pay Transparency
Starting salary will be aligned with a candidate's demonstrated qualifications, experience, skills, and internal pay parity.Diversity & Inclusion
Conexus has earned recognition as a diversity leader in the nuclear industry, particularly for our work advancing women in engineering. We are committed to employment equity and diversity in the workplace, and we welcome applications from women, members of racialized groups/visible minorities, Indigenous persons, persons with disabilities, persons of any sexual orientation, and persons of any gender identity or gender expression. Accommodations are available on request throughout the selection process.A N ote on AI in Conexus' Hiring Process
Conexus may use artificial intelligence (AI) or other technology-assisted tools as part of the recruitment and selection process. These tools are intended to support and never replace human decision-making.If you have questions about this job posting, including accessibility needs, please reach out to Human Resources on View email address on ca.hrm.tc
#J-18808-Ljbffr
Vacancy posted 2 hours 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
- ...institutional data systems to support evidence-informed decision-making across the Faculty. Applies advanced statistical, analytical, business intelligence, assessment, and evaluation methodologies to support strategic planning, academic quality assurance, student success...SuggestedTemporary workWork at office
$75k - $90k per year
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...SuggestedPermanent employment3 days per week1 day per week- 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
$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- Position Summary:Position SummaryThe 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...
- 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
- 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...
- 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
- 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
- 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
- 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...
- 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...
- ...skills and performance. Job DescriptionDuration: Full time Location: Montreal, QC Reporting to the APM Business Intelligence, the Application specialist Level 2 will develop, implement, support, document, and provide analytical services for the Oracle Business Intelligence...Full time
- ...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
$76.8k - $115.2k per year
Line Of Business Analytics, Insights, & Artificial IntelligenceWork Location Montréal, Quebec, CanadaHours 37.5Pay Details $76... ...campaigns using HTML and AMPscript.Provide guidance and train specialists on basic SFMC capabilities and deployment best practices.Bring...Work 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...- 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
- ...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
- 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
- ...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
$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$111.18k per year
...asset. JOB PURPOSE: The Director, Information Technology & Business Intelligence is UWBC’s most senior technology professional and the... ...and vendor management, together with the judgment to direct specialists and external partners. It also requires inclusive leadership...Long term contractCasual workWork at office$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- ...having a real impact.As a BI Analyst, you will serve as a trusted business partner, translating business needs into meaningful, data-... ...requirements and large volumes of data into actionable Business Intelligence (BI) solutions.Work within an Agile development framework by translating...
$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- Shape reliable business intelligence infrastructure using Microsoft Fabric, Azure Synapse, and Azure Data Factory at Manitoba Public Insurance... ...Strengthen enterprise data delivery.This Data Transformation Specialist helps scale the corporation’s cloud and on-premises platform...
- ...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
- 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
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

