Apply now

Posted 166 months ago

( Government of Ontario) Data Architect / modeler - Contract

@ system canada technologies

Toronto, Ontario

On-siteContract
Apply now
SIGNALS

Overview

SCT Resources is hiring a contract Data Architect and Modeler for the Government of Ontario. The role designs and integrates Oracle Hyperion Planning, Essbase, Business Intelligence and Data Integrator solutions for centralized financial planning and budgeting, covering ETL, data quality and data distribution. The posting asks for multi-project, multi-client experience with a full life-cycle data conversion track record.

Responsibilities:

  • Integrate Oracle Hyperion, Essbase, BI and Data Integrator solutions
  • Build ETL, load and automated data distribution processes
  • Analyze source data and drive data quality fixes
  • Design solutions with business users and IT teams for government financial planning

Requirements summary:

  • Proven Oracle Hyperion, Essbase, OBIEE and ODI experience
  • Experience with ETL and multi-platform data repositories
  • Knowledge of GO-ITS and SDLC methods
  • Strong analytical, communication and negotiation skills

Tools & skills

Source and dates

Employer career site / ATS feed · smartrecruiters

Employer posting date
2013-03-18
First seen by our source
2026-10-14
Source record updated
2026-10-14

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

SenioritySenior
DepartmentData & analytics
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high
LanguagesEnglish

Summary and details written by AI from the posting; the employer’s posting is the authority.

system canada technologies

FieldValue
Open jobs on Jobsy399
Job description

Company Description

SCT resources have a broad range of skills in different technologies. The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that adds to our offerings. We learn continuously, both on the job and through formal training programs.

Job Description

• Demonstrated experience of integrating Oracle Hyperion Planning and Oracle Essbase with Oracle Business Intelligence and Oracle Data Integrator products.
• Advanced knowledge and demonstrated experience working with Oracle Business Intelligence, Oracle Data Integrator, Web Services and other middleware/gateway/web/application server technologies that could be used for enterprise integration architecture.
• Experience with analyzing data in source systems to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data)
• Experience with developing feedback processes to get corrupt data fixed in the source systems
• Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide-range of data repositories (relational and multi-dimensional data stores)
• Experience with developing, implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
• Experience with developing monitoring and error notification processes to ensure data is updated as designed
• Experience with developing automation extraction, cleansing and load scripts
• Experience generating research models and reports (scheduled and ad-hoc)
• Experience in designing/developing an automated data distribution mechanism
• Full life-cycle data conversion experience using Oracle Hyperion Planning and Oracle Essbase with Oracle Business Intelligence and Oracle Data Integrator products, including deployment experience
• Knowledge of various database structures including Oracle relational database and Essbase multi-dimensional databases.
• Able to work in a multi-project, multi-disciplinary enterprise environment seeking input and comment from other major initiatives.
• Experience developing system solutions using systems requirements for centralized financial planning and budgeting functions using tools/technologies specified under project requirements checklist.
• Demonstrated knowledge of generic system capabilities of government funding modeling and financial administration business activities.
• Experience working with both the business users and IT development teams to ensure business requirements are properly reflected in the system design, technical specifications and final solution.
• Experience in building system solution options and alternatives to establish client buy-in for the proposed solution.
• Demonstrated experience in building system solutions for the modernization of large complex multi-platform, multi-tier Information Technology Systems.
• Experience working in programs consisting of multiple highly inter-dependent projects.
• Experience developing system solutions using development tools under Oracle Hyperion Planning and Oracle Essbase technology stack.

• Awareness of emerging IT trends and directions with regard to future versions of the products such that proposed solution is resilient to technology advancement.
• Proven ability to manage to successful completion an assignment of this nature, magnitude and complexity, and achieve the results on schedule.
• Experience working on projects within a multi-client/partner environment.
• Proven experience facilitating the resolution of I&IT issues.
• Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills.
• Knowledge with SDLC and structured methodologies waterfall and iterative.
• Proven experience in clearly articulating how the proposed systems solutions meet the defined business systems requirements.
• A team player with the ability to coordinate multiple projects with competing priorities and strict deadlines.
• Experience in dealing with system solutions related to funding modeling, financial information management and web based n-tier technology implementation.
• Knowledge of, and experience with Government of Ontario Information Technology Standards (GO-ITS)

Similar jobs

  • Senior Data Architect

    Mississauga, ON
    Contract

    Ccube

    8+ YOECandidates need 8 to 10 years of data architecture or engineering experience, with strong AWS or Azure and Databricks skills. They also need strong SQL, Python, and experience with Spark, Kafka, and Airflow or dbt.

    Databricks, Spark, Kafka, Airflow, dbt, AWS

  • Senior Data Architect / Modeler - Contract

    Toronto, ON
    Contract

    Compugen Inc

    Candidates need extensive experience designing enterprise data architectures and conceptual, logical and physical data models, plus experience with AI/ML data pipelines and Retrieval-Augmented Generation. Strong knowledge of the Microsoft Azure data and AI ecosystem and data governance is required.

    Azure Machine Learning, Microsoft Azure AI Foundry

  • Data Architect

    Toronto, ON
    Contract

    Gala Solutions

    Candidates need strong data architecture and data governance experience, plus data security skills such as encryption, tokenisation, RBAC/ABAC and secure logging. Experience with cloud data platforms, integration architecture and tools like Azure Data Factory, Databricks, Kafka and SQL is expected.

    Azure Data Factory, Azure Data Lake, Azure SQL, Databricks, IBM DataStage, Kafka

  • Data Architect

    Toronto, ON
    Contract

    Ness Digital Engineering: Ness Digital Engineering is a global provider of Intelligent Data and Software Engineering services, specializing in data, AI, and cloud-powered…

    Candidates need strong data architecture, data governance and data security experience, including data modeling, PII classification, encryption, tokenization and access controls, plus cloud data platform experience, ideally with Azure.

    Azure Data Factory, Azure Data Lake, Azure SQL, Databricks, IBM DataStage, Kafka

  • Data Architect

    Toronto, ON
    Contract

    Cyber Space Technologies LLC

    Candidates need hands-on experience in data architecture, data modeling, data governance and data security, including PII classification, encryption, tokenization, RBAC and ABAC. Experience with integration architecture, batch and API processing, and cloud data platforms is also required.

    Data Architect

    Ontario
    Contract

    Cyber Space Technologies LLC

    Candidates need strong data architecture, data governance and data security experience, including PII classification, encryption, tokenization, RBAC/ABAC and integration architecture. Experience with Azure data platforms, Databricks, Kafka, REST APIs and SQL is expected, and retail, loyalty, banking or customer data experience is preferred.

    Azure Data Factory, Azure Data Lake, Azure SQL, Databricks, Kafka, IBM DataStage

  • Data Architect

    Toronto, ON
    Full Time

    Project X: is a boutique advisory, systems integration and support firm focusing on data & analytics and business consulting.

    5+ YOECandidates need 5+ years in data architecture or engineering, with hands-on Snowflake experience and strong SQL and Python skills. Cloud expertise on AWS, Azure or GCP, plus strong communication and stakeholder skills, are also required.

    Snowflake, Snowpipe, Snowpark, Tableau, Power BI, MicroStrategy

  • Data Architect

    Toronto, ON
    Contract

    Envision Technology Solutions

    10+ YOECandidates need 10+ years in data architecture, engineering or enterprise data management, strong SQL and database skills, and experience with cloud data platforms, big data tools and ETL/ELT tools. Strong communication and stakeholder management skills are also required.

    SQL, Informatica, Talend, Azure Data Factory, AWS Glue, Apache Spark

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.