Job 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
Numbers & Facts
| Location | (Remote) |
| Job Type | Full-time |
| Company Size | 11 - 50 |
| Headquarters | Torrance, CA, US |
| Website | https://www.offsoar.com |
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.
Skills
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesResume Builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Resume Builder