Business Intelligence Specialist (Winnipeg)

Business Intelligence Specialist (Winnipeg)

17 Nov
|
emergiTEL
|
Winnipeg

17 Nov

emergiTEL

Winnipeg

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 solid 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.
Stak

📌 Business Intelligence Specialist (Winnipeg)
🏢 emergiTEL
📍 Winnipeg

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: business intelligence specialist (winnipeg) / winnipeg

Subscribe to this job alert:

Get the latest job offers by email for: business intelligence specialist (winnipeg) / winnipeg