KData AI

Company Name: KData AI
Job Title: SSIS Developer
Job Description: **Job Title** SSIS Developer **Role Summary** Design, develop, and maintain SSIS packages to migrate data from Guidewire Aurora PostgreSQL to on‑prem SQL Server, ensuring nightly batch processing, data integrity, and alignment with a Guidewire upgrade initiative. **Expectations** - Deliver fully tested, optimized SSIS solutions within the project timeline. - Meet defined ETL SLAs and maintain high data quality standards. - Collaborate with data, functional, and operations teams to resolve discrepancies and support migration cutover. **Key Responsibilities** 1. **ETL Design & Development** – Build scalable SSIS pipelines for full, incremental, and delta loads; apply business logic, surrogate key generation, and referential integrity rules. 2. **Nightly Batch Orchestration** – Configure SQL Server Agent or enterprise schedulers; implement error handling, retry logic, logging, and alerting; monitor and tune job performance. 3. **Data Validation & Reconciliation** – Execute field‑level and record‑level reconciliation scripts; analyze mismatches; document data lineage and maintain dashboards. 4. **Guidewire Upgrade Support** – Map Guidewire PC/CC/BC models, perform data profiling, coordinate parallel runs, cutover, and post‑migration validation to meet release standards. 5. **Documentation & Delivery** – Produce technical design documents, mapping sheets, ERDs; manage source code in Git/Azure DevOps; provide post‑deployment support and optimizations. **Required Skills** - Advanced proficiency in SSIS (≥3 years) and T‑SQL (stored procedures, indexing, query tuning). - Experience extracting data from PostgreSQL/Aurora via ODBC/OLEDB/.NET providers. - Knowledge of Guidewire data models (Policy Center, Claim Center, Billing Center) and upgrade processes. - Familiarity with ETL scheduling tools (SQL Server Agent, Control‑M, Autosys). - Version control with Git/Azure DevOps; CI/CD awareness. - Ability to write reconciliation scripts in SQL and/or Python. - Strong understanding of data quality, audit, and compliance practices. **Required Education & Certifications** - Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent experience. - 5–8 years total ETL development experience, including 5–8 years of overall data migration projects; proven record in insurance or similar domain. ---

Canada

Remote

Junior

08-12-2025

Company Name: KData AI
Job Title: AI Engineer Junior (Vertex AI & GCP)
Job Description: Job title: Junior AI Engineer – Vertex AI & GCP Role Summary: Support the design, development, and deployment of AI agents and chatbots on Google Cloud Platform using Vertex AI. Execute end‑to‑end AI workflows, integrate with enterprise APIs, and optimize model performance in production environments. Expectations: - Fresh graduate or 0‑2 years of professional experience. - James involvement in real‑world, enterprise‑grade AI projects. - Proactive learning and collaboration with senior engineers to translate research into production systems. Key Responsibilities: - Build and customize AI agents and conversational chatbots with Vertex AI. - Develop prompt templates, embeddings, and conversational flows for LLM‑based solutions. - Integrate AI modules with RESTful APIs, other cloud services, and enterprise applications. - Deploy models on GCP, implement monitoring, and perform performance tuning. - Conduct A/B testing, debug issues, and refine agent behavior based on analytics. Required Skills: - Proficient in Python programming. - Familiarity with Google Cloud Platform, especially Vertex AI. - Basic understanding of large language models (LLMs) and chatbot architectures. - Knowledge of prompt engineering, embeddings, or retrieval‑augmented generation (RAG) a plus. - Ability to work with RESTful APIs and cloud‑based services. - Strong interest in generative AI and applied machine learning. Required Education & Certifications: - Bachelor’s or Master’s degree in Computer Science, Data Science, Artificial Intelligence, Engineering, or related field. - Legally eligible to work in Canada. ---

Toronto, Canada

Hybrid

Junior

16-01-2026

Company Name: KData AI
Job Title: Business Analyst – Artificial Intelligence & Automation
Job Description: Job Title: Business Analyst – Artificial Intelligence & Automation Role Summary: Senior AI & Automation Business Analyst to drive early-stage qualification, discovery, and governance of AI/automation initiatives in a manufacturing enterprise, converting ideas into structured, delivery-ready projects. Expactations: Lead discovery and problem framing for AI/automation projects; govern vendor solutions; standardize process frameworks; and deliver measurable outcomes aligned with security and architecture standards. Key Responsibilities: 1. Conduct stakeholder workshops and intake meetings for AI/automation initiatives. 2. Evaluate feasibility of AI use cases, redefine expectations, and establish success criteria. 3. Design decision workflows, data frameworks, and KPI metrics for AI/automation solutions. 4. Assess and govern vendor proposals to ensure compliance with technical and operational standards. 5. Standardize intake processes, MVP roadmaps, and executive-level documentation. Required Skills: - 8+ years in business analysis, product analysis, or solution consulting. - 4+ years in AI project execution and deployment (end-to-end). - Strong Microsoft Azure ecosystem proficiency (Azure, Synapse, Fabric). - Manufacturing industry experience. - Proven ability to define measurable business outcomes for AI initiatives. - Vendor governance and stakeholder leadership expertise. - Bilingual (English required, French functional). Required Education & Certifications: - Bachelor’s degree in Business, Computer Science, or related field. - Demonstrated hands-on AI/automated project delivery experience (no specific certifications listed).

Côte-des-neiges, Canada

Hybrid

Senior

18-02-2026

About the Company

Listed Jobs