Highlights
Design and deliver LLM and agentic AI solutions using Snowflake Cortex, Azure AI Foundry, Azure OpenAI Service, Copilot Studio, and orchestration frameworks. Enable Snowflake governance: RBAC, dynamic masking, row level security, encryption.
Numbers & Facts
| Location | (Remote) |
| Job Type | Full-time |
| Company Size | 11 - 50 |
| Headquarters | Torrance, CA, US |
| Website | https://www.offsoar.com |
Description
- Define and govern enterprise Data & AI architecture across legacy, cloud, and AInative platforms
- Architect hybrid data integration across mainframe, DB2, Snowflake, Postgres, Talend, and event streaming
- Design and deliver LLM and agentic AI solutions using Snowflake Cortex, Azure AI Foundry, Azure OpenAI Service, Copilot Studio, and orchestration frameworks
- Establish RAG, vector database, and embedding strategies for enterprise research and analytics
- Coordinate the continual modernization of ETL and Lakehouse architecture
- Enable Snowflake governance: RBAC, dynamic masking, row level security, encryption
- Ensure compliance with OSFI, SOX, NAIC, PIPEDA/GDPR, SEC/state insurance regulations
- Partner with business, risk, compliance, legal, IT, Information Security and vendors as the lead technical advisor
Qualifications
Required Skills:
- 3+ years hands on Snowflake experience (Snowpark, Cortex, data sharing)
- 3+ years delivering production LLM / GenAI solutions (RAG, agents, finetuning)
- Proven legacy to cloud migration experience involving IBM DB2 or equivalent
- Experience with Talend, modern data integration, and real time ingestion
- Knowledge of relational (e.g., PostgreSQL), NoSQL, NewSQL, and vector/LLM databases
- Demonstrated experience with legacy-to-cloud data migration involving IBM DB2 or equivalent mainframe/relational systems
- Proven delivery of agentic AI systems or multi-model orchestration pipelines in enterprise environments
Education Required:
- 12+ years in data architecture, data engineering, or enterprise architecture
- 5+ years in financial services (life insurance, annuities, investments preferred)
About Company
Offsoar is a global technology consulting and IT staff augmentation company dedicated to helping enterprises
modernize their operations through data, cloud, AI, and digital transformation solutions. Our flexible delivery
models (onsite, offshore, and nearshore) and deep industry expertise enable us to drive measurable outcomes.
✔ Reducing IT and operational costs
✔ Accelerating digital transformation
✔ Building high-performance data analytics platforms
✔ Implementing Generative AI-based intelligent solutions
Our Vision
To be the global partner of choice for consulting, IT staff augmentation, and digital solutions across offshore, nearshore, and onsite delivery models.
