Business Intelligence Specialist
8 hours ago
Winnipeg, Manitoba, Canada
Conexus Nuclear Inc.
Full-time
Free with email or Google
Save this job and keep your search organized
Create a free account to save jobs, create alerts and return to this listing from your dashboard.
Free with email or Google
By continuing, you agree to our Terms & Privacy Policy.
Salary Range: $75,000.00 To $90,000.00 Annually
Role
Business Intelligence Specialist Assignment
IT Development Line of Business
Information Technology Director, Information Technology President & CEO Scope (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 base Aid 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 process Build 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 modelling Designs 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 development Builds 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 control Profiles 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
Business Intelligence Specialist Assignment
IT Development Line of Business
Information Technology Director, Information Technology President & CEO Scope (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 base Aid 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 process Build 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 modelling Designs 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 development Builds 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 control Profiles 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