Senior Consultant / Lead – Agentic AI & SAS to PySpark Modernization
About the role
Themesoft Inc. is a global IT solutions provider and a Woman‑Owned Minority Business Enterprise headquartered in Dallas, TX. With a strong presence across the US, Canada, India, Singapore, and Brazil, we specialize in digital transformation, consulting, and workforce solutions across diverse industries. We are currently looking for a tech-savvy and results-driven professional for one of our leading clients. If you’re passionate about technology and looking to grow in a dynamic, fast-paced environment, this could be the perfect fit for you.
Senior Consultant / Lead – Agentic AI & SAS to PySpark Modernization Toronto, ON-Hybrid Long term Contract Job Summary We are seeking a highly skilled professional to design and build Agentic AI-driven solutions to automate SAS to PySpark code conversion and validation. The role will leverage AWS Bedrock (Claude), Retrieval-Augmented Generation (RAG), and multi-agent orchestration to enable intelligent code transformation and automated testing frameworks, particularly in actuarial/data domains. This position is part of a strategic data modernization initiative with strong focus on automation, scalability, and accuracy. Key Responsibilities Design and develop agent-based AI systems for Automated SAS → PySpark code conversion Intelligent test case generation and validation Build and orchestrate multi-agent workflows leveraging LLMs (Claude) for Code parsing, transformation, optimization, and validation Implement RAG pipelines to retrieve reusable patterns, business rules, and legacy logic during code conversion Develop and execute automated testing frameworks to compare SAS vs PySpark outputs (data reconciliation, validation checks Integrate solutions with AWS services (Bedrock, S3, Glue, Lambda, API Gateway, etc) Collaborate with actuarial/business teams to interpret domain-specific logic and ensure functional equivalence Build reusable accelerators for large-scale legacy modernization progr amsEnsure robustness through logging, monitoring, and evaluation of agent outputs Contribute to best practices for AI-driven software engineering and autonomous pipelines
Required Skills Strong experience in Python & PySpark development Hands-on experience in AWS (Glue, S3, Lambda, Bedrock, CloudWatch) Experience with LLMs (Claude / OpenAI / similar) and prompt engineering Expertise in RAG architectures and vector-based retrieval systems Experience in SAS programming / SAS data pipelines (critical for conversion logic) Knowledge of ETL/data engineering and large-scale data migration Familiarity with agentic AI frameworks / multi-agent orchestration concepts [Agentic AI...cture Dive | SharePoint) Strong experience in data validation and testing frameworks Exposure to LangChain / LangGraph / agent frameworks
Nice to Have Experience in actuarial / insurance domain (pricing, risk models, etc) Familiarity with MLOps / CI-CD for AI pipelines Experience:8–12+ years (Senior Consultant) Location: Toronto - Hybrid
Regards,
Parthasarathy K Lead Recruiter Work: 972-474-8787 Ext: 306,Direct: 972-737-8607 Partha.k@themesoft.comThemesoft Inc |Themesoft Jobs
Not the right fit? Search for Consultant / Lead jobs in Toronto, Ontario, Canada
About THEMESOFT
Dallas based, global IT Consulting and Creative Lab firm founded in Aug 2004, Themesoft is a leading provider of in house team, out of house team, or as a somewhere in between global partner. We manage client's information technology needs, refine and define clients digital strategy and create the digital media client's need to communicate their vision. Our success is measured in our client's successful realization of their vision and goals.
As a global IT Consulting and Creative Lab firm, we have the global perspective and the collaborative spirit. We take the time to understand our partner's culture, ideas and aspirations. This partnership approach allows us to take our partners farther than they ever dreamed possible.
Themesoft partners with all types of businesses from small bright idea start ups to industry leaders. Our portfolio of diverse and global companies teach us something new everyday.
Themesoft believes in constantly evaluating performance on every project and at the company level. We improve as we go and have committed to staying one step ahead of every curve. We truly believe that providing high level consultants and technology services requires that we maintain the same standards for ourselves.
We have 9 offices located in the United States, Canada, Singapore, and India.
Similar Jobs
Senior Consultant / Lead – Agentic AI & SAS to PySpark Modernization
About the role
Themesoft Inc. is a global IT solutions provider and a Woman‑Owned Minority Business Enterprise headquartered in Dallas, TX. With a strong presence across the US, Canada, India, Singapore, and Brazil, we specialize in digital transformation, consulting, and workforce solutions across diverse industries. We are currently looking for a tech-savvy and results-driven professional for one of our leading clients. If you’re passionate about technology and looking to grow in a dynamic, fast-paced environment, this could be the perfect fit for you.
Senior Consultant / Lead – Agentic AI & SAS to PySpark Modernization Toronto, ON-Hybrid Long term Contract Job Summary We are seeking a highly skilled professional to design and build Agentic AI-driven solutions to automate SAS to PySpark code conversion and validation. The role will leverage AWS Bedrock (Claude), Retrieval-Augmented Generation (RAG), and multi-agent orchestration to enable intelligent code transformation and automated testing frameworks, particularly in actuarial/data domains. This position is part of a strategic data modernization initiative with strong focus on automation, scalability, and accuracy. Key Responsibilities Design and develop agent-based AI systems for Automated SAS → PySpark code conversion Intelligent test case generation and validation Build and orchestrate multi-agent workflows leveraging LLMs (Claude) for Code parsing, transformation, optimization, and validation Implement RAG pipelines to retrieve reusable patterns, business rules, and legacy logic during code conversion Develop and execute automated testing frameworks to compare SAS vs PySpark outputs (data reconciliation, validation checks Integrate solutions with AWS services (Bedrock, S3, Glue, Lambda, API Gateway, etc) Collaborate with actuarial/business teams to interpret domain-specific logic and ensure functional equivalence Build reusable accelerators for large-scale legacy modernization progr amsEnsure robustness through logging, monitoring, and evaluation of agent outputs Contribute to best practices for AI-driven software engineering and autonomous pipelines
Required Skills Strong experience in Python & PySpark development Hands-on experience in AWS (Glue, S3, Lambda, Bedrock, CloudWatch) Experience with LLMs (Claude / OpenAI / similar) and prompt engineering Expertise in RAG architectures and vector-based retrieval systems Experience in SAS programming / SAS data pipelines (critical for conversion logic) Knowledge of ETL/data engineering and large-scale data migration Familiarity with agentic AI frameworks / multi-agent orchestration concepts [Agentic AI...cture Dive | SharePoint) Strong experience in data validation and testing frameworks Exposure to LangChain / LangGraph / agent frameworks
Nice to Have Experience in actuarial / insurance domain (pricing, risk models, etc) Familiarity with MLOps / CI-CD for AI pipelines Experience:8–12+ years (Senior Consultant) Location: Toronto - Hybrid
Regards,
Parthasarathy K Lead Recruiter Work: 972-474-8787 Ext: 306,Direct: 972-737-8607 Partha.k@themesoft.comThemesoft Inc |Themesoft Jobs
Not the right fit? Search for Consultant / Lead jobs in Toronto, Ontario, Canada
About THEMESOFT
Dallas based, global IT Consulting and Creative Lab firm founded in Aug 2004, Themesoft is a leading provider of in house team, out of house team, or as a somewhere in between global partner. We manage client's information technology needs, refine and define clients digital strategy and create the digital media client's need to communicate their vision. Our success is measured in our client's successful realization of their vision and goals.
As a global IT Consulting and Creative Lab firm, we have the global perspective and the collaborative spirit. We take the time to understand our partner's culture, ideas and aspirations. This partnership approach allows us to take our partners farther than they ever dreamed possible.
Themesoft partners with all types of businesses from small bright idea start ups to industry leaders. Our portfolio of diverse and global companies teach us something new everyday.
Themesoft believes in constantly evaluating performance on every project and at the company level. We improve as we go and have committed to staying one step ahead of every curve. We truly believe that providing high level consultants and technology services requires that we maintain the same standards for ourselves.
We have 9 offices located in the United States, Canada, Singapore, and India.