System Canada Technologies Jobs

( Government of Ontario) Data Architect / modeler - Contract

System Canada Technologies

( Government of Ontario) Data Architect / modeler - Contract

Reposted One Month Ago

Be an Early Applicant

In-Office

Toronto, ON, CAN

Senior level

In-Office

Toronto, ON, CAN

Senior level

Design, model and implement enterprise data integration and ETL solutions using Oracle Hyperion Planning, Essbase, Oracle BI and Oracle Data Integrator. Analyze and cleanse source data, build automated extraction/transform/load processes, scheduling, monitoring and error notification. Provide full life-cycle data conversion, reporting, and automated distribution for centralized financial planning and budgeting systems. Work with business and IT stakeholders to design resilient, multi-tier solutions aligned with Government of Ontario IT standards.

The summary above was generated by AI

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

Tapestry - Coach and Kate Spade

PT III Sales Associate

Yesterday

Hybrid

Toronto, ON, CAN

Entry level

eCommerce • Fashion • Retail • Sales • Wearables • Design

Provides personalized styling advice, product recommendations, and customer service in a Kate Spade retail store. Responsibilities include driving sales through customer engagement and storytelling, completing POS transactions, maintaining stockroom organization, supporting virtual selling, and collaborating with the team. The role requires flexible scheduling, retail experience, strong communication skills, and the ability to perform physical tasks such as lifting, bending, and maneuvering through sales and stockroom areas.

Top Skills: Pos

Morningstar

Vice President, Credit Ratings - Financial Institutions Groups

2 Days Ago

Hybrid

Toronto, ON, CAN

Senior level

Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services

Lead analyst responsible for managing a portfolio of Canadian banks, non-bank financial institutions, and credit unions. Perform ongoing financial and credit analysis, prepare rating committee presentations, reports and press releases, attend issuer meetings, participate in rating committees, and maintain client relationships. Produce surveillance, research, and written analysis while collaborating with the ratings team.

Top Skills: Bloomberg

Ericsson

Senior Functional System Developer

2 Days Ago

In-Office

Senior level

Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)

Leads functional systemization and solution design for radio and wireless communication products. Translates customer, market, regulatory, and product requirements into system requirements, interfaces, behaviors, and acceptance criteria. Leads feasibility studies, architecture evaluations, and technical investigations; provides recommendations, root-cause analysis, and technical leadership across hardware, software, security, verification, and product management teams. Supports secure-by-design development, compliance, planning, prioritization, mentoring, and global stakeholder alignment.

Top Skills: CybersecurityRadio Access Networks (Ran)TelecommunicationsWireless Communication Systems

What you need to know about the Toronto Tech Scene

Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.