Specialized IT Consultant – Senior

Job Title: Specialized IT Consultant – Senior

Work Arrangement

• Onsite – 5 days/week

• Office-based assignment

Role Summary

The Specialized IT Consultant – Senior provides strategic and hands-on expertise in enterprise data integration, ETL, data warehousing, and business intelligence solutions. The role supports large-scale modernization initiatives, production sustainment, release activities, and infrastructure upgrades, while ensuring structured knowledge transfer to internal teams.

Key Responsibilities

• Advise clients on Information Management and IT solutions to meet business objectives

• Improve efficiency and structure of enterprise I&IT systems using Oracle Data Integrator, Informatica, and SSIS

• Provide strategic guidance on IM, data platforms, and task-based IT technologies

• Act as subject matter expert during procurement and delivery phases

• Support release management, infrastructure sustainment, urgent priorities, and upgrades

• Design, develop, optimize, and maintain ETL pipelines and data warehouse solutions

• Enhance ETL and SQL performance across large data environments

• Design data warehouse components, ETL scripts, and hierarchical data models

• Develop reports, dashboards, and BI solutions using Cognos and Power BI

• Lead cloud-based data solutions using Databricks, Apache Spark, Delta Lake, and Fabric Data Factory

• Support production operations, incident resolution, defect management, and unplanned deployments

• Document system designs, ETL processes, and BI specifications

• Ensure compliance with Ontario Digital Platform (ODP) standards and data governance practices

• Perform knowledge transfer to designated internal resources prior to contract completion

Knowledge Transfer Requirements

• All deliverables, drafts, and final documentation must be stored in designated repositories

• Project managers and designated staff must be informed in writing of documentation locations

• Minimum one walkthrough session of all documentation is required

• Knowledge transfer conducted via one-on-one sessions, documentation reviews, and written communication

• Knowledge transfer must be completed one week prior to contract end or consultant exit

Required Skills & Experience
Technical Skills (45%)

• 5+ years senior-level experience with Oracle Data Integrator and/or Informatica

• Strong experience with SSIS in data warehousing and large-scale data migration

• Advanced SQL skills across Oracle (10.x+), DB2, SQL Server, PL/SQL

• Experience optimizing ETL pipelines and SQL queries

• Experience designing data warehouse components and ETL scripts

• Hands-on experience with PowerDesigner for data modeling and DDL generation

• Experience debugging ETL mappings, transformations, and unit testing components

• Experience with Unix and Korn-shell scripting

• Experience using Cognos (v10+) and Microsoft Power BI for BI solutions

• Hands-on experience with Databricks, Apache Spark, Delta Lake

• Experience integrating Databricks with Azure Fabric Data Factory and Power BI

• Familiarity with Ontario Digital Platform (ODP) standards and compliance

• Experience designing cloud-based data solutions for modernization initiatives

Core Skills (35%)

• Strong experience in data warehouse design and optimization

• Experience documenting application designs, ETL processes, and BI specifications

• Knowledge of aggregate reporting and enterprise ETL workflows

• Experience troubleshooting production issues and managing fixes

• Experience with defect and issue management tools (HP ALM, HP Service Manager)

• Experience modernizing large, multi-platform, multi-tier IT systems

• Experience working across Agile and Waterfall methodologies

Communication & Analytical Skills (15%)

• Strong collaboration with business and IT stakeholders

• Ability to translate business requirements into technical designs

• Strong analytical and problem-solving skills to assess priorities and design alternatives

Public Sector Experience (5%)

• Previous experience working in a large public-sector organization

Must Have

• 5+ years senior-level experience in ETL design, development, optimization, and data migration

• Strong expertise in data warehousing, data modeling, mapping, and performance tuning

• Advanced SQL across Oracle, DB2, SQL Server, and PL/SQL

• Hands-on experience debugging ETL pipelines and performing unit, system, and UAT testing

• Experience with PowerDesigner and hierarchical data models

• Delivery of enterprise BI solutions using Cognos and Power BI

• Hands-on Databricks experience (Spark, Delta Lake, Fabric Data Factory integration)

• Experience designing cloud-based data solutions for modernization initiatives

• Production support and defect management experience (HP ALM / HP Service Manager)

• Strong collaboration skills in large public-sector environments with ODP familiarity

---