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