ETL / SQL BI Specialist - Remote - Contract (Toronto)

ETL / SQL BI Specialist - Remote - Contract (Toronto)

15 Nov
|
Robert Half
|
Toronto

15 Nov

Robert Half

Toronto

We have a contract role open for our client. Please see the details below

Key Accountabilities

1. Maintain COG’s file-level database environments including back-end, front-end, and global code base
2. 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
1. 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.
- Solid 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.

Competencies
- 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 modelled 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 control totals (row counts, checksums, amount totals) between source and target and reports exceptions
- Data visualization and dashboard design Designs dashboards and reports for non-technical decision-makers — selects the right visual for the question, defines KPIs with the business, keeps interactivity simple,



and engineers’ queries and aggregates so dashboards open quickly.
- Practical experience with at least one major BI tool (e.g. Power BI, Tableau) including publishing and sharing to a browser.
- Web-delivered reporting and platform integration Delivers reports from a web-based application rather than a desktop file: browser publishing/embedding, scheduled distribution, role-based and row-level security, single sign-on, connection and credential management, ODBC/OLE DB and REST/JSON data access. Working familiarity with web hosting and environment promotion (dev → test → production) sufficient to partner with the infrastructure and application teams.
- Automation and scripting for repeatable operations
- Automates 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 transfer
- Writes 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 partners
- Frames 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 investigation Investigates 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 delivery Handles 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.

*This job posting is for a current vacancy with our client. *Our specialized recruiting professionals apply their expertise and utilize our proprietary AI to find you great job matches faster.

📌 ETL / SQL BI Specialist - Remote - Contract (Toronto)
🏢 Robert Half
📍 Toronto

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: etl / sql bi specialist - remote - contract (toronto) / toronto

Subscribe to this job alert:

Get the latest job offers by email for: etl / sql bi specialist - remote - contract (toronto) / toronto