Job Archives
We are looking for an ETL Developer! Reach out if you are interested and feel free to refer friends/colleagues!
Type of Employment: Contract
Title: ETL Developer
Term: Contract – 12 months with extension
Location: Toronto – Hybrid 3 days on-site
Industry: Government
Job ID number: C158
Description:Â
SCOPE:
- A senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution
- Provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution.
- Establish a strong working relationship with clients, interact effectively at all levels and analyses legacy data and files stored in a variety of data sources and formats.
- Analyze and complete data profiling and suggest any pre migration data cleansing activities.
- Complete data migration strategy, data mapping, define interfaces, perform mock conversion, define enhancements and perform actual conversion.
- Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.
- Resolve and troubleshoot technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations
- Work with importing files from heterogeneous platforms and coordinates data file migration.
- Define testing strategy, plan and conducts testing to ensure data integrity and data comparisons.
- Perform post migration audit and data reconciliation.
- Generate data migration exception reporting and perform data cleansing as required.
- Provides pre- and post-effective conversion support to business clients
- 7+ years of experience in developing data conversion and migration
- Extensive experience in data migration in terms of digital transformation, ETL experience in migrating data from legacy applications to modernized solutions.
- Experience in migrating document attachments from legacy solution to a new modernized solution.
- Experience working in cloud DB technologies (such as Azure SQL).
- Experience working in ETL tools such as Azure Data Factory, Informatica, etc.
- Knowledge and experience in development of business case, data migration strategy and plan.
- Knowledge and understanding of Information Management principles, concepts, policies and practices.
- Excellent understanding of master data and transactional data concepts and interdependencies.
- Full life-cycle data conversion experience with enterprise systems, including deployment experience.
- Experience working with all steps of data migration activities such as data profiling, data mapping, developing data migration solutions, data validation and audit.
- Proficiency in query languages such as SQL, PL-SQL.
- Familiarity with and construction of complex query statements.
- Knowledge of various database structures and RDMS like Oracle DB and MS SQL Server, Azure SQL Database, and write complex SQL queries
- Knowledge and understanding of mainframe data formats, data types, segments and non-relational data structures
- Experience ensuring the data migration solution is scalable.
- Data analysis, investigative and logic skills with high attention to detail
- Experience with migrating file attachments from legacy applications to new solution.
- Experience with data conversion scripts and various ETL tools such as Informatica, Azure Data Factory, etc.
- Experience with overseeing /completing all tasks involved in the conversion process including data extraction, cleansing, transformation and loading
- Experience liaising with teams to understand to-be migration requirements.
- Establish a strong working relationship with all groups, interact effectively with all levels of client personnel, and provide conversion support.
- Experience completing mapping, interfaces, conversion work, documentation and verifying completeness and accuracy of converted data.
- Experience delivering the required system changes and/or working with the development team or a dedicated conversion team to specify loads programs.
- Experience providing support through the cutover process
- A team player with a track record for meeting deadlines, managing competing priorities and client relationship management experience
- Communication, facilitation, negotiation, consensus building, and problem-solving skills
- 7+ years of experience in developing data conversion and migration
- Experience working with migrating data from different legacy platforms to a new solution.
- Full life-cycle data conversion experience with enterprise systems, including deployment experience.
- Knowledge of various database structures and RDMS like Oracle DB, MS SQL Server, Azure SQL Database, and write complex SQL queries, etc.,
- Data analysis, investigative and logic skills.
- Experience with overseeing /completing all tasks involved in the conversion process including data extraction, profiling, cleansing, import data, manipulate data, transformation and loading.
- Experience liaising with teams to understand to-be migration requirements.
- Knowledge and understanding of Information Management principles, concepts, policies and practices.
- Experience providing support through the cutover process.
- Knowledge of data model of case management solutions and experience in data migration/conversion of large case management applications.
- Experience with migrating attachment files from legacy applications to new solution.
- Experience with document migration
- Proficiency in query languages such as Oracle SQL, PL-SQL, SQL Server, etc.,
- Exceptional level of knowledge on relationships between tables to perform and construct complex query statements from multiple data sources.
- Knowledge of various database structures and RDMS like Oracle, MS SQL Server, Azure SQL Database, and write complex SQL queries, etc.,
- Knowledge and understanding of mainframe data formats, data types, segments and non-relational data structures
- Data analysis, investigative and logic skills with high attention to details.
- Experience with data conversion scripts and tools.
- Experience with industry leading ETL tools such as Informatica, Azure Data Factory and cloud technologies.
- Experience with file migration from different file storages such as Azure BLOB, Azure file share, SharePoint, Oracle BLOBs.
- Experience completing mapping, interfaces, conversion work, data exclusion and inclusion, documentation and verifying completeness and accuracy of converted data, including data dictionary development and updates.
- Experience delivering the required system changes and/or working with the development team or a dedicated conversion team to specify loads programs.
- Communication, facilitation, negotiation, consensus building, and problem-solving skills
- Provide periodic status reports, present data migration strategy and approach to executives and other stakeholders
- Previous experience working in Government or Public Sector organizations
- All documentation relating to the technology designs and technology knowledge specific to the candidate’s assignment All information gathered while working with vendors and internal solutions to be shared Any best practices, work around, lessons learned must be documented
Job Features
| Job Category | ETL Developer |
We are looking for an SharePoint Developer! Reach out if you are interested and feel free to refer friends/colleagues!
Type of Employment: Contract
Title: SharePoint Developer
Term: Contract – 12 months with extension
Location: Montreal – Hybrid
Industry: Financial
Job ID number: C157
Description:Â
The SharePoint Development service provider will develop business-changing enterprise solutions with SharePoint Online and other leading-edge technologies. The ideal service provider will have experience developing web applications using Microsoft and compatible technologies including SharePoint Online, Microsoft Power app and Power Automate.
Primary Responsibility:Â
- Assist other developers, analysts, and designers in conceptualizing and developing SharePoint solutions. This may include integrating third-party tools and/or into SharePoint.
- Work with business users and analysts to document and analyze workflows that will be automated in SharePoint.
- Provide expertise and support to end users and other members of IT support.
- Conduct research on emerging SharePoint development tools and strategies.
- Recommend, schedule, and perform software improvements and upgrades.
- Continually strive to improve the efficiency and usability of our SharePoint solutions, leveraging your ongoing research and understanding of business needs.
- Expertise in SharePoint implementations.
- Experience in SQL Server or equivalent databases.
- Experience in Web development (HTML, CSS, JavaScript).
- Experience with Microsoft Power App and Power Automate.
- Strong understanding of Object-Oriented Programming and Design.
- Proven analytical and problem-solving abilities.
- Ability to effectively prioritize and execute tasks in a high-pressure environment.
- Strong interpersonal and oral communication skills.
- Skilled at working within a team-oriented, collaborative environment.
- Ability to present ideas and solutions in business-friendly and user-friendly language.
- Highly self-motivated and self-directed.
- Keen attention to detail.
Job Features
| Job Category | Sharepoint Developer |
We are looking for an Security Architect! Reach out if you are interested and feel free to refer friends/colleagues!
Type of Employment: Contract
Title: Security Architect
Term: Contract – 12 months with extension
Location: Ontario – Hybrid
Industry: Government
Job ID number: C156
Description
Role:
- Provide expertise and leadership in information technology (IT) architecture with focus in Technical (including infrastructure and networks) Application architecture, as well as focus in business and information architecture, along with enterprise architecture frameworks, strategies, and methodologies.
- contribute to and manage the planning, design, delivery, and implementation of architecture solutions related to large scale, complex, multi-year I&IT projects required to meet the critical business requirements of our ministry client(s)
- help and support with the development of designs and solutions to challenging multi-ministry, enterprise-wide business issues.
- contribute to the definition, evaluation and provide leadership in the development of architecture policies, standards, guidelines, and best practices affecting multi-ministry/cluster initiatives.
- determine the risk of business solutions and propose risk mitigating techniques.
- lead and facilitate the development and use of frameworks to identify, measure and propose mitigating tactics for enterprise-wide technical debts.
- Work with the project team in completing all relevant and required documentation in alignment with OPS standards.
- 5 to 10 years of experience in a Security Architect senior role
- experience with I&IT security concepts, programs, frameworks, and methodologies
- experience with identity and authentication schemes for internal and external access in high sensitivity environments
- experience with various development methodologies (Waterfall, Agile, DevOps) and security testing frameworks
- experience with process design and analysis
- experience with public sector governance processes and requirements.Public sector experience with law enforcement is a benefit.
- Expertise in I&IT enterprise architecture with knowledge primarily in Technical, Application as well as in security, business, and information domains.
- Have successfully led the design of multi-stakeholder, cross-platform technology solutions.
- Have experience with IT strategies, policies, plans, current and emerging enterprise architecture principles, methodologies, mechanisms, and techniques.
- Have experience conducting threat risk analysis, identifying risks pertaining to existing business solutions and applications and providing appropriate mitigation strategies.
- Have experience analysing portfolios of business solutions and determining the future direction of each portfolio based on the organizational needs and industry directions.
- Have knowledge of technical security best practices to provide practical expertise to meet complex and diverse needs.
- Have knowledge of current industry standards to provide advice, including systems analysis, performance & capacity management, development, testing and implementation methods, Change Management tools and techniques.
- Have a deep understanding of governance processes and best practices in governing architecture of technology projects.
- Have a strong understanding of risk management and how enterprise architecture processes and best practices can be used to manage risk.
- Have the ability to apply industry best practices and standards in architecture, software and systems engineering, design and development tools and techniques, and software lifecycle methodologies.
- Have knowledge of Project Management and Service Management practices
- you have knowledge of Application Portfolio Management frameworks.
- Have led cross functional, and multi-organizational projects.
- Have led project status meetings and other organizational activities related to architecture priorities.
- Can provide guidance and training to project staff engaged in architecture related project activities.
- Can provide technical guidance to support staff; schedule activities and explain/document procedures related to the solution infrastructure.
- Can establish effective working relationships, obtain buy-in for systems development, promote systems to senior management and stakeholders.
- Can develop architectural solutions to meet complex, multi-year plans, spanning multiple internal/external stakeholders and broadly defined business objectives.
- Can resolve significant integration and technical issues to address multiple systems/applications linkages, interdependencies and impacts where requirements are not initially clear.
- Can research and recommend innovative systems architecture alternatives and integration strategies.
- Have developed and compiled your research and recommendations into reports for senior executives.
- Can plan and coordinate all phases of complex multi ministry/cluster architecture for systems supporting both internal/external clients and stakeholders.
- Can develop appropriate performance measures that are adaptive and responsive to address the continuous introduction of new and emerging technologies, use of unfamiliar or unproven technology, broadly defined or undefined business and systems requirements.
- Have developed and delivered presentations to senior executives.
- Can present IT strategies and solutions to management.
- Can advise regarding approaches to contentious systems architecture issues.
- Can provide architecture and processes training to clients and projects.
- Can consult with multiple stakeholders and clients to advise on technical issues.
- Can facilitate discussions among stakeholders with different interests.
- Can encourage participation in the systems design process.
- Can negotiate service agreements with client management and other IT groups to minimize delivery issues and exceed service expectations.
- Can provide advice and recommendations regarding effective architecture strategies.
- Can facilitate both performance and capacity management discussions with support teams as well as clients
- Creation of technical specifications for system(s) development
- Design, implement and work with the project team in completing all relevant and required architectural and system design documentation.
- Ensure alignment with OPS and OPP I&IT directives, policies, and standards.
- Business architecture, as well as traceability to solution logical and physical architectures
- Ensure appropriate documentation to support privacy assessments, threat risk assessments, penetration tests and other required security testing and evaluation are as per OPS I&IT standards.
- Create, review, provide input and support of Enterprise Architecture artifacts for all Governance Points as required.
- Review all test scenarios to ensure the requirements are met; establish traceability matrix to monitor output.
- Ensure alignment and adherence to Ministry of Public and Business Service Delivery (MPBSD) I&IT governance, standards, workflows, and processes.
- Support the testing team during system, UAT and other testing.
- Create and validate business scenarios and use cases.
- Produce visual depiction of use cases and process flows; ensure alignment with the program area and associated business requirements, objectives and mandate.
- Be prepared for and participate in knowledge transfer.
- Undertake special assignments/sub-projects as assigned.
- Experience with I&IT security concepts, programs, frameworks, and methodologies.
- Experience with identity and authentication schemes for internal and external access in high sensitivity environments.
- Experience with various development methodologies (Waterfall, Agile, DevOps) and security testing frameworks.
- Experience with multi-tiered high availability services including web front end, APIs, applications, storage, and database tiers.
- Experience with I&IT networking concepts and design.
- Experience with data storage concepts, structures, and backups.
- Experience of encryption and public key infrastructure concepts and use of certificates.
- Experience converting business requirements to technical outcomes.
- Experience with developing business models for cross agency/partner data flows.
- Experience developing wireframes and user test cases.
- Experience with process design and analysis.
- Support development of business process and technical documentation.
- Experience managing executive relationships and reporting to senior management.
- Experience building relationships with stakeholders, in a multi-stakeholder, cross jurisdictional environment.
- Experience with public sector governance processes and requirements.
- Leadership to manage and resolve issues, working in collaboration with team members.
Job Features
| Job Category | Security Architect |
We are looking for an Oracle Database Administrator ! Reach out if you are interested and feel free to refer friends/colleagues!
Type of Employment: Contract
Title: Oracle Database Administrator
Term: Contract – 6 months with extension
Location: Toronto – Hybrid
Industry: Banking
Job ID number: C155
Story Behind the Need:
The GTEP - Technology Operations & Engineering teams work together to improve how customers and employees experience technology every day. We build effective and stable infrastructure technology solutions to support the systems and services that our customers and employees rely on. The team is seeking a Database Administrator to support the business initiatives for FY24, working on Tuning, Support, Maintenance deliverables for Payment Screening.
Candidate Value Proposition:
We are technology partners who help the business transform how our employees around the world work. They will have the opportunity to work with cutting edge technology to implement a new database on a global scale, and provide database support on a variety of hardware and software platforms and peripherals.
Typical Day in Role:
- Oracle Installation, Database creations and upgrades from lower Database versions to higher versions.
- Troubleshooting connectivity and addressing any system concerns.
- Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues (ex. correcting installation, configuration, or data problems). Plan and perform software installation, configuration, upgrade and patching database configuration, maintenance, upgrade and patching.
- Perform and manage system and database backups.
- Reporting to Senior Manager.
- 8-10+ years of working experience as a Database Administrator
- 5+ years of hands on experience with Oracle Installation - Database upgrades/migrations
- 5+ years of hands on experience with Database creation and upgrade of Oracle database versions 12c & 19c
- 5+ years of hands on experience with Data Guard – Database replication tools, setup, configure and support
- 5+ years of hands on experience with Database performance and tuning
- Previous Banking/FI experience is an asset
- Familiar with Security and Auditing
- Oracle Certifications
- Oracle Golden Gate and Oracle Exadata
- Database setup in a Cloud environment
- RAC (Real Application Cluster) and Automatic Storage Management (ASM)
- OEM/Grid Control (13c)
- Excellent written, presentation, and verbal communication skills to be able to work well with technical peers and business stakeholders at different levels within the organization.
- Ability to work as part of a team, as well as work independently or with minimal direction.
- Good time management and organizational skills to effectively manage high scale project.
- Solid Oracle based knowledge and experience.
- Good attitude, willing to learn and a good team player.
- Ability to work independently and under pressure.
- Experience working with executives.
- Post-secondary degree in a technical field such as computer science, computer engineering or related IT field is a nice to have.
Job Features
| Job Category | Oracle Database Administrator, Oracle DBA |
We are looking for a React Developer! Reach out if you are interested and feel free to refer friends/colleagues!
Type of Employment: Contract
Title: React Developer
Term: Contract – 6 months with extension
Location: Toronto – Hybrid – once a week
Industry: Banking
Job ID number: C154
Candidate Value Proposition:
The successful candidate will have the opportunity to work with a high performing team on React and Angular frameworks; ability to take ownership of the project and work independently to suggest enhancements, provide inputs, shape the project - as it is more of an individual role.
Typical Day in Role:
- Tech Stack: React and Angular – front-end developer role
- Working with design product teams on building new components for web applications
- Engaging with the community of developers to answer questions and guide them
- Help support to maintain the incremental builds for the UI library components frameworks
- Comfortable with modern JavaScript including ES6 through ES9 and Typescript.
- Build Reusable components and front-end libraries for future use.
- Knowledge on HTML, CSS, SASS and CSS in JS(styled-components).
- Maintain high standards of software quality within the team by establishing good practices and habits.
- Familiar with Object-Oriented Programming Concept and Test-Driven Development.
- Stay up-to-date with the latest web development technologies and best practices.
- Participate in code reviews and provide constructive feedback to other team members.
- A great understanding of the software development lifecycle and methodologies.
- Strong analytical and problem-solving skills, coupled with excellent communication and collaboration abilities.
- 10+ years of experience as a developer working on web applications
- 5+ years of recent experience with React UI components
- 5+ years combined experience with HTML, CSS, SASS and CSS in JS(styled-components)
- 2+ years’ experience with CI/CD tools (Bitbucket, Azure)
- Experience with JavaScript including ES6 through ES9 and Typescript.
- Experience working on Angular
- Experience with accessibility and mobile standards
- Demonstrated ability to build relations with multiple teams and collaborate with them
- Excellent communication skills
- Strong stakeholder managements skills
- Demonstrated leadership and mentorship capabilities.
- Exceptional time management and organizational skills, with a proactive and innovative approach to work.
- Adaptability to changing priorities and technologies, with a keen attention to detail and a commitment to quality.
- Ability to grasp new concepts quickly.
- Need a strong senior React developer who has experience with managing stakeholder expectations and working with a large team, able to adapt, strong communication skills needed in this role; very strong with React UI components, capable of working independently and is accountable for their work; if they have worked on newer types of applications and designs v.s. old ones, this will help set them up for success
Job Features
| Job Category | React Developer |
We are looking for a Python Developer! Reach out if you are interested and feel free to refer friends/colleagues!
Type of Employment: Contract
Title: Python Developer
Term: Contract – 6 months with extension
Location: Ontario – Hybrid – twice a week
Industry: Banking
Job ID number: C153
Story Behind the Need
Candidate Value Proposition
- The successful candidate will have the opportunity to work with a dynamic and experienced team of software developers, infrastructure specialists, and business analysts, as well as gaining experience in the capital markets and credit risk technology fields. The project will contribute to the bank’s core risk management and reporting functions, helping to protect the bank and its customers.
- Project aims to implement a counterparty credit risk check in to existing system.
- Primary function is to support the building out of a reporting system.
- Building the limit reporting system to display credit check information.
- Development of calculation and/or reporting applications
- Enhance reporting web application at enterprise level
- Producing thorough, clear, and detailed documentation
- Communicating with stakeholders to ensure they are implementing best practices, integrating existing technologies, etc.
- Leveraging existing infrastructure to communicate information between systems and applications.
- Will be working on creating net new code and enhancement of existing code in a 70/30 capacity, depending on project deliverables.
- Workload will consist of a 60/40 split between front and back end development
- Working collaboratively with project team, participating in scrums and meetings, implementing all steps of SDLC.
- 10+ years’ experience in the capacity of a developer
- 5+ years’ hands on experience in Python Django and JavaScript web framework.
- 5+ years’ hands on experience using both listed Python libraries: NumPy , Panda
- 3 + years’ experience with Unix/Linux environment and proficient in shell scripting
- 5 + years’ experience with RDMS including Postgres SQL, as well as Oracle or SQL
- 2+ years’ recent experience in Object Oriented Programming (Java)
- Banking or Capital Markets experience is an asset
- Previous credit risk monitoring systems experience is an asset
- Good communication, both written and oral, whether producing documentation or attending meetings with other developers, non-technical team members, or external stakeholders
- Proactively raise issues as they are identified
- Creativity and resourcefulness in solving problems within the framework of the existing technology stack
- Willingness to learn and upgrade skills as needed on the job
Job Features
| Job Category | Python Developer |
We are looking for a Business Analyst! Reach out if you are interested and feel free to refer friends/colleagues!
Type of Employment: Contract
Title: Business Analyst
Term: Contract – 6 months with extension
Location: Ontario – Hybrid – once a week
Industry: Banking
Job ID number: C152
Story Behind the Need
- Business group: GWRT-GCMT-Commodities, FX Options & Derivatives Technology US – Group focuses primarily on FX trading (front to back office)
- Project: Oracle 19c work under Software Currency Project – Wallstreet FX database upgrade
- Reason for request: Backfilling resource who has been converted to FTE on the team
- The successful candidate will have the opportunity to work on a critical project, supporting the FX trading business of a leading financial institution.
- Contributing to the success of Oracle Migration project
- Research, formulate, and perform data-driven analytics using SQL
- Manage the collection of business requirements and preparation of functional requirements for development to build
- Prepare test cases and plans and execute those test cases in the required timelines, ensuring deliverables conform to business requirements
- Conduct regression testing
- Develop and maintain a strong working relationship with business stakeholders, various technology teams and production support teams.
- Assist in resolving complex, multi-faceted problems to meet the system needs for FX trading business by applying your business and technological knowledge to perform analysis, reconciliations, defining user requirements, etc.
- Test, validate, create artifacts, and assist in deployment of solutions to production environment
- Working primarily with global markets data
- Looking at data attributes (related to FX) and ensuring that the data is accurate and complete. Ensure that what is fed from upstream is accurate (investigation, analysis, altering format to fit system format, etc.)
- May be expected to look into downstream reporting to assist with building out some reports
- Will be working internally with the project team, other BSAs, Developers, as well as with some business users
- 5+ years’ experience within in the capacity of a BA/BSA (including regression testing)
- 3+ years’ recent experience in Capital Markets technology space
- 5+ years’ professional experience writing and designing SQL queries (intermediate to advanced skills)
- Hands-on experience with the SDLC (testing and technical specifications), as well as a strong understanding of configurations, technical mappings, data attributes
- Experience supporting database upgrades
- Working knowledge of Unix/Linux
- Wallstreet FX experience is an asset
- Verbal and written communication
- Organization
- Willingness to learn new things is a key value
- Problem solver
Job Features
| Job Category | Business Analyst |
We are looking for a Business Intelligence Developer! Reach out if you are interested and feel free to refer friends/colleagues!
Type of Employment: Contract
Title: Business Intelligence Developer
Term: Contract – 6 months with extension
Location: Ontario – Hybrid - twice a week
Industry: Banking
Job ID number: C151
Department Overview:
What does Data & Analytics stand for? For starters, we believe in visionary leadership and insights. We believe in using every resource at our disposal to better serve our clients, and this includes our vast data.
The Business Intelligence group delves into our data, past and present, to develop crucial metrics and reporting functionality that better informs and optimizes key businesses decisions across the organization.
This is the team building the dashboards, scorecards and business intelligence insights that deliver and process vital data to business partners across the enterprise.
Joining us in Business Intelligence is an opportunity to advance and deepen your career and to help us serve its customers in a way we never have before.
Job Description
Are you a big picture thinker? Fantastic! This is exactly the kind of thinking we need when it comes to our business intelligence support and analytics. In this role, we need you to take a holistic, high level approach to collection and reporting of data & key insights for major projects and initiatives.
As data's role in providing extraordinary products and services to our customers grows, we'll look to the valued expertise you'll provide in this role, to develop, adopt and evolve the best in class reporting and business intelligence capability.
Does this sound like you? You're a natural leader, and can lead major initiatives and projects, joining business owners and partners to determine business needs and recommend solutions. Moreover, you have a talent for looking at a collection of data and drawing rare insights. In this role, we'll need you to include those insights and commentary within the existing reporting packages you deliver. Finally, you'll fit in well if you like to own your space and execute with speed and precision, relishing all challenges as opportunities to dig in, collaborate and take into the future of banking.
Job Description:
- Develop and understand business drivers, definitions, and metrics to interpret findings, take-action, and provide meaningful business direction.
- Develop and maintain specialized Business Intelligence (BI) packages, dashboards and scorecards on the MS Azure Cloud Platform
- Manage the repository of all reporting assets including and not limited to data analysis, development scripts, objects and documentation.
- Maintain expert knowledge of all main data sources for the data used within the business unit and ability to effectively utilize these data sources
- Lead the discussion with business partners to understand business objectives and develop valuable reporting for enablement and fact based decisioning
- Validate the quality and integrity of the data included in all artifacts
- Develop substantial and insightful commentary/insights on new and existing BI packages
- Work independently as the senior analyst / expert and may provide technical support to others
- Enthusiastic and focused self-starter who can work with minimal supervision to strict deadlines and is able to prioritize, multitask, and manage various projects simultaneously
- Excellent verbal and written communication skills with the ability to work with various level of management and senior management to convey findings concisely through presentations and business commentaries
- Strong ownership mentality, proactive attitude, and ability to get things done
- Demonstrated passionate analytical thinker with track record of delivering business impact and results through developing and executing on innovative BI solutions
- Strong problem-solving skills, with a history of using data to understand not only what is happening, but why it is happening, and what can be done to resolve the issue
- Strong organizational skills, with the ability to excel in a fast-paced environment and run multiple deadlines and priorities
- Contractor will gather requirements from business and data exploration.
- 60% is exploring the code and 20% is interacting with business, 20% team knowledge sharing.
- Build data model and pass it on to data as a service team. Someone who is proactive and can see something is wrong with the data.
- Experience working or leading end to end project i.e. from data sourcing, ETL and reporting.
- Experience working in Agile environment
- Hands-on experience in using business intelligence, developing, and building data and tools with Tableau and Azure Cloud
- Experience with Python, SQL, Tableau coding experience
- Strong team player who fosters and thrives in an environment of peer development and sharing
- Strong analytically-anchored problem-solving skills – a logical and strategic thinker with strong critical reasoning skills, proactively identifies risks and issues, recommends solutions, challenges the status quo
- Experience Databricks and Pyspark
- 2+ years JIRA and Confluence
- Preference for banking industry experience
Job Features
| Job Category | Business Intelligence Developers |
We are looking for a Data Analyst! Reach out if you are interested and feel free to refer friends/colleagues!
Type of Employment: Contract
Title: Data Analyst
Term: Contract – 12 months with extension
Location: Ontario – Hybrid - Flexible
Industry: Insurance
Job ID number: C150
Company Overview
Our teams live by a set of core beliefs that put our clients’ needs and goals first. We are looking for talented professionals at all stages of their financial careers: those who are ready to learn, ready to collaborate and those who are ready to lead.
Senior Data Analyst
Are you passionate about data? Do you want to join a dynamic team that produces data to drive business decisions and outcomes? Are you passionate about delivering innovative solutions in a fast paced, growing asset management environment. If yes, then read on!
We are looking for a data analyst to join our Data Platform Team. You will be responsible for data analysis, data mapping, data modeling, governance and testing of various data sources and platforms. You will also collaborate with other data analysts, engineers, and business stakeholders to create derived consumable data products. This role includes thorough analysis and understanding of capital markets data so a strong background in Asset Management/Capital Markets is required. Proficient facilitation, interpersonal and elicitation skills are also imperative to capture complex business/data requirements in this fast-paced environment.
Responsibilities
- Perform data mapping and data modeling activities to ensure data quality and integrity across different data sources and platforms. When establishing new data products, define, develop and implement the component defined within the data certification process.
- Adhere to, enhance and support governance policies and procedures by ensuring data attributes are clearly defined and data security, privacy, and compliance requirements are met.
- Support Data Owners/Steward in resolving technical data-related issues using specialized skills and tools.
- Conduct data/process testing and validation to identify and resolve issues and anomalies.
- Analyze and interpret data using various tools and techniques to generate insights and recommendations for business stakeholders.
- Define and clearly articulate problem statements while communicating and presenting data insights/recommendations to various audiences, both technical and non-technical.
- Manage discussions, negotiations and conflicts through resolution, using communication strategies that align with various audience styles and cultures.
- 8+ years of hands-on experience in data analysis, data modeling, data governance, or data engineering.
- 5+ years of experience in Asset Management and/or capital markets with strong/broad domain knowledge of investment instruments and the asset management business.
- Strong analytical and problem-solving skills.
- Ability to work independently and collaboratively in a fast-paced environment.
- Practical experience with technologies such as SQL, python in cloud environments.
- Experience with Agile delivery model, tools (e.g., Jira; confluence; Miro), and writing technical user stories.
- Evidence of effective and efficient delivery in a virtual, multi-site environment.
- Highly motivated with demonstrated eagerness for continuous learning and self-growth.
- Proven communication, consultation, and facilitation skills to lead diverse stakeholder group to agreement.
- Bachelor's degree in data science, computer science, statistics, mathematics, or training in related field.
- Excellent communication and presentation skills.
- All employees affiliates are committed to fair dealings and integrity in our business. As part of that commitment, all employees are considered Access Persons under our Code of Ethics. An Access Person is someone who may have access to nonpublic information regarding Clients’ purchase or sale of securities, who is involved in making securities recommendations, or who has access to such recommendations that are nonpublic. Upon joining, employees are required to follow compliance procedures, which include the disclosure of personal investment accounts, the reportable holdings in those accounts and gain pre-clearance on personal trades.
Job Features
| Job Category | Data analyst |
We are looking for a Risk Analyst! Reach out if you are interested and feel free to refer friends/colleagues!
Type of Employment: Contract
Title: Risk Analyst
Term: Contract – 12 months with extension
Location: Ontario – Hybrid 3 days on-site
Industry: Financial
Job ID number: C149
Brief Description on Duties:
- The TPRM Junior Analyst reports to the Director, TPRM Supplier Governance and is responsible for supporting the Third-Party Risk Management and Supplier Performance and Governance activities throughout the end-to-end third-party life cycle. The TPRM Junior Analyst will be primarily responsible for monitoring vendor related risks through various governance procedures for high residual risks identified for Tier 1 Suppliers. The TPRM Junior Analyst will also assist in collecting and storing reporting of SLA’s with Business Owners for performance management of Tier 1 Suppliers.
- The TPRM Junior Analyst will assist in creating guidance documents for Business Owners on appropriate governance activities for Tier 3 Suppliers.
- Additionally, the TPRM Junior Analyst will assist TPRM Junior Manager in ad-hoc administrative tasks related to the management of Tier 1 suppliers.
- Aggregates internal and external supplier information to onboard Tier 1 suppliers
- Assists of TPRM Junior Manager with completion of risk assessments with the designated Business Owners and Governance Stakeholders for Tier 1 Supplier engagements.
- Assists TPRM Junior Manager with trend analysis and compiles material updates at Service Excellence and Third-Party Risk Management Committee for Tier 1 Suppliers
- TPRM Framework – First Line of Defense – Assists TPRM Junior Manager with compiling and documenting identified potential risks with Tier 1 Supplier engagements across all 9 risk categories.
- Supports the TPRM Program and internal stakeholders with supplier segmentation assessments based on spend, risk and business criticality for all Tier 1 suppliers
- Assists the TPRM Junior Manager with the collection and compilation of materials for Business Reviews for Tier 1 Suppliers. Follows up with Business Owners and Suppliers as required.
- Supports TPRM Junior Manager with coordination of Supplier Surveys and Scorecard Compilation for Tier 1 Suppliers.
- Supports TPRM Junior Manager with monthly operational reviews for Tier 1 Suppliers.
- Validates Tier 3 risk assessments (including annual segmentation validation).
- Updates documents (as required) in repository used for Tier 3 Supplier governance (business guidance).
- Assists with the creation of Supplier Profiles for all Tier 1 Suppliers and ensure profiles are updated semi-annually.
- Collects all contractual due diligence items for Tier 1 suppliers and maintains repository
- Liaisons with Contract Management Administrator for any required reporting
- Post-secondary diploma/ degree in a related field
- Experience in banking industry, vendor management or strategic sourcing
- Solid understanding of third party/vendor management programs
- Excellent communication skills and time-management
- Advanced level of understanding of Microsoft Office Tools (e.g., Excel, Project Access)
- Exceptional analytical skills to gather relevant information, identify key issues, critically compare information, develop conclusions, and develop well-supported recommendations
- Convey ideas, information and materials to individuals and groups
- Experience working for a Financial Services organization
- Demonstrated experience segmenting, analyzing, and reporting third-party performance and risk
- Demonstrated experience working with SAP Ariba
- Experience working with database and data analytical tools, such as SQL, VBA, Power Query
- Experience working with visualization tools, such as Tableau, Power BI
Job Features
| Job Category | Risk Analyst |
We are looking for a Project Manager! Reach out if you are interested and feel free to refer friends/colleagues!
Type of Employment: Contract
Title: Project Manager
Term: Contract – 12 months with extension
Location: Ontario – Hybrid 3 days on-site
Industry: Telecom
Job ID number: C1438
Brief Description on Duties:
- We are seeking a Project Manager and Principal Agile Delivery Specialist with an unparalleled 30 years of IT experience, including a remarkable 17-year journey within the Telecommunications sector. This role is ideal for a visionary leader who blends technical prowess with an in-depth understanding of telecom infrastructure, architectural frameworks, and systems structure. The successful candidate will lead technical deliveries for large-scale Telecom projects, utilizing both traditional Waterfall and modern Agile methodologies to ensure seamless project execution.
- Technical Project Leadership: Utilize your extensive IT and Telecom experience to lead technical deliveries from inception to completion, ensuring projects align with strategic goals and are delivered on time and within budget.
- Strategic Alignment: Work closely with the executive leadership to align project initiatives with corporate objectives, demonstrating your strong technical and program management skills.
- Agile Methodology Advocacy: Champion Agile best practices, providing hands-on support to both technical and business teams, and guiding the technical delivery team towards success.
- Policy and Control Implementation: Implement policies, system monitoring, and controls, leveraging your experience for effective management and reporting of corporate initiatives.
- Communication and Autonomy: Utilize exceptional communication skills to facilitate strategic decision-making, ensuring clear and effective communication at all levels.
- Agile Leadership: Serve as a mentor to Release Train Engineers (RTEs), enhancing the team's Agile practices and understanding through your extensive experience.
- Comprehensive IT and Telecom Experience: 30 years of IT expertise, with a focus on 17 years within the Telecom industry, showcasing a deep understanding of software development and technical intricacies.
- Technical and Project Management Expertise: Demonstrated ability to integrate technical skills with project management methodologies, managing large-scale projects and fostering strong vendor relationships.
- Agile and Waterfall Methodologies: Proficient in both Agile and Waterfall methodologies, able to adapt and guide teams through Agile practices effectively.
- Exceptional Leadership and Communication: Strong leadership skills with the ability to guide project resources and communicate effectively at the executive level.
- Technical Skills: Proficiency in PeopleCode, Java, XML, Cobol.
- Program Management Skills: Expertise in PMO program governance, PMP and PMI-ACP Agile methodologies, project recovery, strategic alignment, change management, risk evaluation, and stakeholder management.
- MBA
- Bachelor of Engineering (B.E.) in Computer Science or similar
- Certified SAFe® 5 Practitioner
- Certified SAFe 5 Agilist
- Certified SAFe 5 Teams
- Certified SAFe 5 Scrum Master
- PeopleSoft Certified Consultant
- Senior Product Owner
Job Features
| Job Category | Project Manager |
We are looking for a Data Engineer! Reach out if you are interested and feel free to refer friends/colleagues!
Type of Employment: Contract
Title: Data Engineer
Term: Contract – 6 months with extension
Location: Toronto – Hybrid 2 days on-site
Industry: Financial
Job ID number: C1437
Brief Description on Duties:
The Data Engineer will design, build, and support the cloud-based infrastructure for the data pipeline and analytics across the client's development and data platforms to produce high-performance and scalable solutions.
The role requires the incumbent to innovate and drive solutions that complement the IT vision.
- This role will lead enhancements requested by Investment business partners, including Front Office, Investment Risk, and Investment Operations. They will be providing occasional production support to their core investment data warehouse.
- As a key member of the data platform design committee, set guidelines, standards, and best practices for new project initiatives across development and data management teams.
- Design and implementation of data and technology infrastructure for new data and analytics platform with Azure data stack
- Design and build data solutions for distributed ETL processing for all data ingestion into the data platform (dimensional layer) with scalable and usable data pipelines.
- Be the primary liaison and owner for data projects, technical backlog, and managing the delivery solutions with business stakeholders.
- Oversee and build custom web APIs using Azure Function Apps to integrate with external services
- Oversee and develop complex SQL for ETL and data extractions with high-performing and easy-to-manage code.
- ETL with Azure Data Factory experience, building pipelines, with strong experience building Dimensional data warehouses
- Azure Data Factory (ADF)
- Azure Data Lake Storage (ADLS)
- Azure Databricks (ADB)
- Azure Synapse
- Azure Function apps
- Build processes (plan, design, and implement enhancements end-to-end)
- Expert in SQL – development from transformation perspective, writing complex SQL queries, views, and procedures
- Some sort of investment or capital markets experience
- Independent worker needing very little guidance after being trained on framework
- Flexible and accommodating with work being done – learn existing practice/framework, can enhance and work with it
- Strong communication skills
- Power BI
- Snowflake - VERY NICE TO HAVE
Job Features
| Job Category | Data Engineer |
We are looking for a Security Analyst! Reach out if you are interested and feel free to refer friends/colleagues!
Type of Employment: Contract
Title: Security Analyst
Term: Contract – 12 months with extension
Location: Toronto – Hybrid 2 days on-site
Industry: Banking
Job ID number: C1437
Brief Description on Duties:
Story Behind the Need:
The Identity Lifecycle Management team within the Access Management Operations is responsible for the execution of established security controls pertaining to identity and access. This includes the centralized provisioning of user identities, the user accounts linked to those identities, management of user access, privileged access, as well as the selection and integration of identity management tools. The Senior Analyst, Identity Lifecycle Management is responsible for supporting the achievement of the Bank’s information security objectives of integrity, confidentiality/privacy, availability, and continuity by:
- Ensuring logical access control is effectively implemented across the Enterprise.
- Addressing logical access and risks commensurate with the Bank’s risk appetite.
- Providing support for logical access working with MS Active Directory (on prem), LDAP, provisioning access on user’s local workstation, access on vFiler shares, privileged access management.
- Supporting the business to understand their responsibilities with respect to logical access controls.
- Continuously, provides value and consistency added to the user and customer experience by improvising workflows associated with bank’s onboarding and Logical Access platforms
- Perform required tasks for Logical Access Control; tasks relevant to Identity & Access Management including access request, access provision/deprovision, communication, and documentation of operational processes and procedures, etc.
- Process Add/remove/change activities, and provide support on access issues for: ScotiaID, Windows ID (Active Directory).
- AD Security Groups, Distribution Groups, Group Mailboxes access management Service Accounts.
- Utilize troubleshooting skills to understand moderately complex systems/issues related to user Identity and access, and potential root causes.
- Liaise with 2nd and 3rd level support when required.
- Provide reports and data, as requested, for audits and walkthroughs of internal controls IAMOPS ILM owned processes.
- 10+ years of technical working experience as an IT Security Analyst
- 5-7+ years of experience managing Users and Groups in on-prem Microsoft Active Directory and LDAP
- 3-5+ years of experience with PowerShell scripting for AD administration tasks, ServiceNow, SQL/Oracle
- 3-5+ years of experience with SailPoint IIQ, Centrify (or similar) PAM solution for Privilege ID onboarding and management
- Advanced Excel data management skills (working with big reports)
- Technical and Security Designation is an asset (MCSE\MCSA, CISSP, Security+)
- Previous Banking/FI experience
- Power BI experience
- Bilingual in Spanish
- Excellent written, presentation, and verbal communication skills to be able to work well with technical peers and business stakeholders at different levels within the organization.
- Strong decision making, forward thinking and creative problem-solving skills to anticipate and respond quickly to technological/market influences.
- Ability to work as part of a team, as well as work independently or with minimal direction.
- Advanced AD and PowerShell scripting skills
- Proactive and consistently seeks solutions for problems
- Post-secondary degree in a technical field such as computer science, computer engineering or equivalent work experience
Job Features
| Job Category | Security Analyst |
We are looking for a QA Analyst! Reach out if you are interested and feel free to refer friends/colleagues!
Type of Employment: Contract
Title: QA Analyst
Term: Contract – 12 months with extension
Location: Toronto – Hybrid 2 days on-site
Industry: Banking
Job ID number: C1436
Brief Description on Duties:
Job Description:
The position requires a dedicated, driven individual who can identify issues, analyze problems and propose solutions independently of management guidance. The type of person suitable for this role is someone who has experience in the QA and Automation, with at least three years in automation testing groups performing a range of testing tasks. The ideal candidate is results-oriented and forward thinking, and can help drive our long term plans.
Responsibilities:
- Define and execute the automation, testing and QA processes used in the infrastructure group from smoke testing through final acceptance testing
- Define and execute an automation strategy working with external groups
- Execute QA and automation processes on all Engineering projects with direction from a team manager
- Ensure we meet deliverable deadlines without compromising the quality of the deliverables
- Establish a culture of quality and testing within the ITS group
- Work with our Customer base to understand their needs and ensure the team delivers high-quality products that meet end-user requirements
- Design and develop automation architecture & scripts to interface with additional scripts for startup, cleanup, logging, reporting and to reduce maintenance
- Ensure that the scripts are complete, executable, reusable and maintainable
- Responsible for setting standards for scripting and the environment that best suit the production
- Responsible to ensure that all planned activities are implemented, executed and completed in accordance to the planned timeline
- Responsible for progress reporting and ensuring that problems and issues are raised for prompt corrective action
- Manage short term & long term objectives and effectively scope projects within schedule constraints
- Work with other QA teams, Business Analysts and Solution Analysts to validate requirements and incorporate the requirements for the design and development of the automation test scripts
- Attend QA team meetings and articulate any concerns and findings as well as report those concerns using standard problem reporting tools
- Participate in test strategy, test estimation and planning discussions
- Candidate must be able to read Requirement Specification documents and produce Test Plans and Test Cases
- Candidate must be able to define Automation Strategies that will verify the operation of new services or products while tracking to project schedule 5-7 years of experience.
- Able to look at excel spreadsheets, follow prescribed steps exactly and populate as per instructions provided with accuracy.
- Every day they will have a process to follow for testing
- They will be extracting data to excel, 100 to 200 rows, data mine text free format
- Populate field according to the procedure.
- Follow procedure and steps to populate field based on text format.
- Advanced Excel
- SQL experience
- Good communication
- IT QA experience
- Automation exp
- SAS
Job Features
| Job Category | QA Analyst |
We are looking for a Security Analyst! Reach out if you are interested and feel free to refer friends/colleagues!
Type of Employment: Contract
Title: Security Analyst
Term: Contract – 6 months with extension
Location: Toronto – Hybrid 2 days on-site
Industry: Banking
Job ID number: C1434
What can you expect:
Story Behind the Need:
As part of the Information Security and Control (IS&C), Senior Information Security Advisor is providing advisory services to business lines, subsidiaries and affiliates enabling the achievement of the Bank's Information Security Policy. As a Senior Security Advisor within the IS&C – Global Technology Applications – Security Advisory Services team, you will provide a central point of reference and core competency for Information Security. Assisting in the classification and protection of data resources by providing guidance on secure and cost-effective implementation of Bank's security policies and standards. Providing guidance to design, develop and implement sound risk management controls in accordance with Bank's standards that assure the Bank's compliance with industry regulations. Keeping informed and well versed on financial industry regulations demands in different regions based on practical experience. Pursuing security and control process improvements to advance security compliance and improve internal processes.
Candidate Value Proposition:
You will have the opportunity to work in a diverse team, that encourages teamwork, provides learning opportunities and time for knowledge sharing. You will work with and learn from diverse industry leaders, who have hailed from top cybersecurity and technology companies around the world. Opportunity to make a significant impact as you will contribute to achieving the Bank’s regulatory and compliance commitments as well our responsibility and commitment to keeping our customers secure.
Typical Day in Role:
- Develop and execute a frameworks for risk and audit issues management, including the creation Participate in initiatives and projects driven by various business lines. Guide project and delivery managers to design and establish sound information security practices, facilitating key artifacts such as security design documents, threat/risk assessments and data classifications with the owner to ensure that risk is identified and effectively managed.
- Provide first line subject matter expert advice on pervasive Bank's information security standards, policies and processes, information security world class standards and major regulations in the industry.
- Liaise with internal and external security teams, local and international, and participate in reviews that pertain to compliance with Bank and Regulatory IT security controls and guidelines.
- Work with our business line partners to assess risk and avoid deviations to Bank standards; where possible, identifying secure solutions. When unavoidable, escalate deviations or risk acceptance requests through appropriate channels.
- You enjoy taking part in initiatives to contribute to the strategic direction for security related technologies or other controls that need to be put in place to reduce the threat levels to the company.
- You excel managing vendor interactions to evolve and continually improve the bank’s protection programs.
- You thrive in delivering best in class support for all endpoint technologies.
- You are comfortable providing metric and reports to the leadership teams.
- 10+ years of working experience as an IT Security Analyst, and keep current with relevant technological change and information security best practices.
- Recent hands-on experience with cloud security controls and experience in deployments and cloud architecture security.
- Recent hands-on experience with security controls/mechanisms and threat/risk assessment techniques pertaining to complex data, application and networking environments.
- Strong knowledge of IT infrastructure and data centre processing environments. Knowledge of security technologies such as: Identify & Access Management, PKI, Intrusion
- Prevention, vulnerability assessments. Knowledge of network security components such as firewalls, routers, intrusion detection, anti-virus software.
- Strong Microsoft Office software skills particularly Excel, Word, Visio and PowerPoint.
- Working knowledge of regulatory guidelines related to the financial industry like OSFI.
- Knowledge of the financial services’ Security Governance Framework (policies and standards) is a strong asset.
- Knowledge of Agile, Lean, Rapid Labs and other accelerated project frameworks would be an asset.
- Security Certifications: CISSP, CCSP, GSEC, CISA, CISM, etc.
- Must have advanced verbal and written communication skills in English, especially report writing ability.
- Proven ability to meet deadlines for multiple assignments and adapt quickly to changing priorities.
- Well developed communication skills are required, and the ability to confidently present ideas and recommendations at formal presentation and conference calls.
- Security Advisory Banking experience.
- Â Ability to complete threat risk assessments.
Job Features
| Job Category | Security Analyst |