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

#J-18808-Ljbffr