Role: BI Migration Lead

Location: Mississauga, ON

Mode of Work: Remote

Duration: 6-12 months

Job Description:

We are looking to hire strong BI migration specialist to lead the transition of enterprise reporting from IBM Cognos to AWS QuickSight.

Role Summary 

Seeking a BI migration specialist to lead the transition of enterprise reporting from IBM Cognos to AWS QuickSight preferably Owns data model conversion, query migration, and report rebuild end to end, ensuring parity of logic, performance, and user experience post migration.

Key Responsibilities 

• Assess existing Cognos landscape: Framework Manager models, report packages, dashboards, and scheduled outputs 
• Translate Cognos data models into QuickSight datasets, SPICE structures, and calculated fields 
• Migrate report logic, filters, prompts, and drill paths into QuickSight analyses and dashboards 
• Convert Cognos queries and SQL into Quick Sight compatible datasets sourced from the target AWS data layer (Redshift, Athena, RDS, or S3) 
• Rebuild visualizations to match or improve on legacy Cognos reports 
• Validate data accuracy and reconcile output against source reports 
• Optimize SPICE ingestion, refresh schedules, and dashboard performance 
• Document mapping, transformation rules, and migration runbook 

Required Skills 

• 5 plus years in BI and reporting, with hands on Cognos (Framework Manager, Report Studio, Cognos Analytics) 
• Proven Quick Sight build experience: datasets, SPICE, calculated fields, analyses, dashboards 
• Strong SQL and data modeling, including star and snowflake schemas 
• Working knowledge of AWS data services (Redshift, Athena, Glue, S3) 
• Experience with report parity validation and reconciliation 

Nice to Have 

• AWS certification (Data Analytics or Solutions Architect) 
• Python for data transformation and automation 

Soft Skills 

• Self-directed, able to move fast with minimal oversight 
• Clear communicator across client and delivery teams 

Role: Sr Quantexa Developer 

Location: Toronto 4 days a week on site F2F interview required

Background check MANDATORY

Duration: 6+ Months

JOB DESCRIPTION:

We are seeking a skilled Quantexa Developer with strong expertise in data engineering entity resolution and network analytics The ideal candidate will design develop and implement Quantexabased solutions to support fraud detection risk analytics and customer intelligence initiatives
You will work closely with data engineers architects business analysts and stakeholders to deliver scalable and highperformance data solutions

Key Responsibilities

• Design and develop Quantexa data pipelines and entity resolution solutions
• Build and configure Quantexa data models pipelines and scoring logic
• Develop and maintain Quantexa configuration Context Configuration Entity Resolution Analytics scoring
• Implement and manage data ingestion transformation and normalization logic
• Collaborate with stakeholders to translate business requirements into technical solutions
• Integrate Quantexa with big data platforms Hadoop Spark Databricks etc
• Optimize system performance and scalability of Quantexa workloads
• Perform data quality checks validation and troubleshooting
• Support deployment testing and production releases
• Document technical designs workflows and processes

Required Skills  

 Technical Skills

• Strong experience with Quantexa platform latest versions preferred
• Proficiency in Scala or Java Scala highly preferred
• Experience with Apache Spark Big Data ecosystems
• Strong SQL skills and experience with data modelling
• Knowledge of entity resolution graphnetwork analytics
• Experience working with ETL pipelines and data integration

Tools Technologies

• Quantexa Context Data Management Scoring
• Apache Spark  
• Hadoop ecosystem
• Databricks preferred
• Git   
• CICD tools
• REST APIs and microservices architecture nice to have

Domain Experience Preferred

• Financial services banking or insurance
• Fraud detection AML AntiMoney Laundering KYC
• Risk and compliance analytics

Soft Skills

• Strong problem-solving and analytical thinking
• Ability to work in agile environments
• Excellent communication and stakeholder management skills
• Ability to handle complex datasets and business logic

We are seeking an experienced Database Administrator with a minimum of 7 years of hands-on experience to manage, maintain, and optimize our database infrastructure.

Required Qualifications

• Minimum 7+ years of experience as a Database Administrator
• Bachelor's degree in Computer Science, Information Technology, or related field

Core Technical Skills

• SQL & Programming
• Expert-level proficiency in SQL queries, complex joins, and query optimization
• Strong experience designing and developing stored procedures, functions, and triggers
• Proficient in T-SQL, PL/SQL, or equivalent procedural SQL languages
• Experience with query performance tuning and execution plan analysis

Database Administration

• Installation, configuration, and upgrade of database systems (Oracle, SQL Server, MySQL, PostgreSQL)
• Database backup and recovery strategies (RMAN, native backups, point-in-time recovery)
• Performance monitoring, tuning, and optimization
• Database security management including user access controls, roles, and permissions
• Capacity planning and storage management
• High availability and disaster recovery implementation (clustering, replication, mirroring)
• Patch management and version upgrades

Additional Responsibilities

• Database design and data modelling
• Index management and optimization
• Monitoring database health and proactive issue resolution
• Troubleshooting database performance and connectivity issues
• Implementing and maintaining database documentation
• Automation of routine DBA tasks using scripts (PowerShell, Shell, Python)
• Collaboration with development teams for database-related requirements
   

Soft Skills

• Strong analytical and problem-solving abilities
• Excellent communication skills
• Ability to work independently and in team environments
• Strong documentation skills

We are seeking a highly motivated Application Developer with strong expertise in Snowflake, Databricks, Python, and SQL to design, develop, and support scalable data and analytics solutions. The ideal candidate will have experience building data pipelines, optimizing large-scale data processing workloads, and developing cloud-native applications that support business-critical reporting, analytics, and operational processes.

Key Responsibilities

• Design, develop, and maintain scalable data solutions using Snowflake and Databricks.
• Build and optimize ETL/ELT pipelines for structured and unstructured data processing.
• Develop high-quality Python applications, automation scripts, APIs, and data integration services.
• Write complex SQL queries, stored procedures, views, and performance-tuned data transformations.
• Implement data models, data quality controls, validation frameworks, and reconciliation processes.
• Collaborate with business analysts, data engineers, architects, and application teams to deliver end-to-end solutions.
• Monitor, troubleshoot, and optimize data pipelines and application performance.
• Support CI/CD deployments, testing, release management, and production support activities.
• Ensure solutions meet security, governance, audit, and regulatory requirements.
• Contribute to cloud modernization initiatives and data platform enhancements.

Required Skills & Qualifications

Technical Skills

• Strong experience with Snowflake Data Cloud.
• Hands-on experience with Databricks and Apache Spark.
• Advanced Python programming skills (Pandas, Pyspark, NumPy, REST APIs).
• Expert-level SQL development and query optimization.
• Experience building ETL/ELT solutions and data pipelines.
• Good understanding of data warehousing, dimensional modeling, and data lake architecture.
• Experience with cloud platforms such as Azure, AWS, or GCP.
• Knowledge of Git, CI/CD pipelines, and Agile development practices.
• Experience troubleshooting performance issues across databases and distributed environments.

Preferred Skills

• Experience with Snowpark, Cortex AI, or Databricks AI capabilities.
• Knowledge of orchestration tools such as Airflow or Azure Data Factory.
• Familiarity with Kafka, streaming data, or event-driven architectures.
• Experience with Power BI, Tableau, or other analytics/reporting platforms.
• Understanding of financial services or enterprise data platforms.

Experience

• 5+ years of software/application development experience.
• 3+ years of experience with Snowflake and cloud-based data platforms.
• 2+ years of hands-on Databricks/Spark development experience.
• Proven track record delivering large-scale data and analytics solutions.

Key Competencies

• Strong problem-solving and analytical skills.
• Excellent communication and stakeholder management abilities.
• Passion for automation, performance optimization, and continuous improvement.

DataStage Developer

Role: DataStage Developer
Duration: 12 Months
Work Model: Hybrid (3 Days per Week Onsite)
Key Responsibilities

ETL Development

• Design, develop, test, and maintain ETL workflows using IBM DataStage and Talend.
• Build reusable ETL components and integration frameworks.
• Optimize ETL processes for performance, scalability, and reliability.

Data Integration & Processing

• Develop ETL/ELT solutions for extracting, transforming, and loading data from multiple sources, including databases, APIs, flat files, and cloud platforms.
• Process structured and semi-structured data efficiently.
• Implement data validation, cleansing, and transformation rules.

Data Warehouse Support

• Support enterprise data warehousing initiatives.
• Work with Star Schema, Snowflake Schema, Fact Tables, and Dimension Tables.
• Ensure timely and accurate data delivery for reporting and analytics.

Performance Tuning & Troubleshooting

• Analyze and optimize ETL job performance.
• Handle large-volume data processing workloads.
• Troubleshoot and resolve ETL failures and production issues.

Collaboration

• Work closely with business analysts, data architects, and development teams.
• Translate business requirements into technical solutions.
• Participate in Agile/Scrum activities including sprint planning and reviews.

Documentation & Governance

• Create and maintain ETL documentation, workflow diagrams, and data mappings.
• Follow data governance, security, and compliance standards.
• Support version control and deployment processes.

Required Skills

Core Technical Skills

• Strong experience with IBM DataStage (Parallel Jobs, Server Jobs)
• Experience with Talend Open Studio / Talend Data Integration
• Strong SQL skills with databases such as Oracle, SQL Server, DB2, or PostgreSQL
• ETL design, development, and optimization experience
• Data modeling and data warehousing concepts

Additional Skills

• Unix/Linux Shell Scripting
• Performance tuning and troubleshooting of ETL jobs
• Experience working with large datasets

Preferred Skills

• Talend Open Studio
• Data Warehousing
• Star Schema and Snowflake Schema
• Data Quality and Data Governance practices
• Agile/Scrum methodology

Keywords

IBM DataStage, Parallel Jobs, Server Jobs, Talend, Talend Open Studio, ETL, ELT, Data Integration, SQL, Oracle, SQL Server, DB2, Data Warehousing, Star Schema, Snowflake Schema, Data Modeling, Unix, Linux, Shell Scripting, Performance Tuning, Data Governance.

Job Title: MS Data Fabrics Architect
Location: Toronto 
Work Type: Hybrid - Work from Office 3 days

Skills: Digital : Microsoft Power BI
Experience Required: 8-10

Role Descriptions:
Skill - Design and implement end-to-end data architectures leveraging Microsoft Fabric components One Lake| Lakehouse| Data Warehouse| Data Engineering| Data Factory| and Power BI with a strong emphasis on Medallion architectural patterns.

Data Modelling & Architecture:
Design and implement conceptual| logical| and physical data models.
Develop scalable and efficient data architectures using Azure Synapse and Databricks.
Integrate data from diverse sources including ERPs| APIs| and cloud databases.
Work closely with data engineers| analysts| and business stakeholders to gather requirements.
Derive Logical| Physical data models.
Ability to do reverse engineering.
Analysis of data across end-to-end applications.

Tools & Technologies:
Azure Synapse Analytics| Azure Data Factory (ADF).
Databricks (including Delta Lake and Unity Catalog)| SQL| PySpark |Python.
Hands-on data modelling tools (E.g., Erwin Data Modeler| ERStudio Data Architect| Power Designer etc.).
Experience with datawarehouse and Azure datalake.

Core Technical Competencies:
Strong understanding of data warehousing concepts and cloud architecture.
Design and implement conceptual| logical| and physical data models.
Develop scalable and efficient data architectures using Azure Synapse and Databricks.
Integrate data from diverse sources including ERPs| APIs| and cloud databases.
Work closely with data engineers| analysts| and business stakeholders to gather requirements.
Azure Synapse Analytics.