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

Ericsson

Product Owner

5 Hours Ago

Hybrid

Expert/Leader

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

Leads the technical strategy, roadmap, architecture, and global delivery of cloud-native Core Network User Plane sub-services. Oversees engineering practices including CI/CD, SRE, DevOps, security, compliance, scalability, reliability, and cost efficiency across incubation, trials, commercial deployment, and scale-up. Builds engineering culture, establishes ways of working and performance metrics, and collaborates with global leadership, architects, engineers, and SRE teams to deliver customer-centric telecommunications products.

Top Skills: 3Gpp4G/5G Core NetworksAgileAWSAzureCi/CdCloud-Native ArchitectureDevOpsDistributed CloudDpdkEbpfEdge ComputingGCPHyperscalersPublic CloudSite Reliability Engineering (Sre)Sr-IovTraffic SteeringUpf

Tapestry - Coach and Kate Spade

Acting Store Leader

13 Hours Ago

Hybrid

Mississauga, ON, CAN

Entry level

eCommerce • Fashion • Retail • Sales • Wearables • Design

Leads store operations for Kate Spade New York, supporting sales performance, customer experience, team development, and achievement of business goals. The role requires strong interpersonal skills, strategic agility, creativity, customer focus, and the ability to provide feedback and build effective teams. Candidates must regularly lift 25 pounds, occasionally lift up to 50 pounds, and maneuver throughout the sales floor and stockroom.

Mastercard

Lead Data Scientist

Yesterday

Hybrid

Toronto, ON, CAN

Entry level

Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing

Lead Data Scientist analyzing global fraud data to identify patterns, develop predictive models, and prevent payment fraud. The role builds fraud-related products and services, extracts insights from large datasets, collaborates with stakeholders, and presents findings to management and clients. Required skills include Python, Spark, complex data queries, and advanced data analysis. Experience with agentic AI systems and Unix is preferred, along with payments or fraud expertise.

Top Skills: SparkLlm-Based AgentsPythonUnix

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.