Sr. AI Solutions Engineer
Summary
Designs, builds, and operationalizes practical AI solutions across the business — copilots, agentic workflows, RAG, and workflow automation — using Snowflake (with Cortex) as the central data platform, plus Microsoft Copilot Studio, Azure AI, Power Platform, and targeted Claude, integrated with Salesforce, SAP, and Power BI. Hybrid role with mandatory monthly onsite attendance in Chicagoland.
- Practical AI solution design and delivery
- Copilot, agentic AI, workflow automation, and targeted Claude enablement
- Enterprise data, RAG, knowledge grounding, and system integration support
- Responsible AI governance, security, quality assurance, adoption, and operational support
- Identify, prioritize, prototype, and deploy AI use cases across all WFC functional areas
- Translate process pain points into AI solution designs, MVPs, production-ready capabilities, and measurable outcomes.
- Build reusable automations and documentation standards that can scale across departments.
- Design and support copilots, assistants, and agents using Microsoft Copilot Studio, Microsoft 365 Copilot extensibility, Azure AI, Power Automate, and related tools, including Claude when appropriate.
- Automate document review, knowledge retrieval, inquiry routing, response drafting, reporting support, workflow initiation, and task summarization.
- Integrate AI-enabled workflows with Teams, SharePoint, Outlook, Power Platform, Salesforce, SAP, Snowflake, and Power BI while preserving system ownership.
- Develop and maintain prompt patterns, reusable instruction sets, source handling standards, and AI usage patterns for repeatable business use cases.
- Design AI solutions grounded in approved enterprise content and data, including SharePoint, Teams, Salesforce, SAP, Snowflake, Power BI, and governed repositories.
- Support RAG patterns, semantic search, metadata design, source attribution, content freshness, and conflict identification.
- Partner with platform and data owners to ensure AI solutions use appropriate data sources, system-of-record definitions, data contracts, and integration patterns.
- Develop lightweight APIs, connectors, workflow integrations, and controlled data-access patterns where needed to support AI solution delivery.
- Ensure AI designs respect operational system boundaries and enterprise reporting standards, especially around Salesforce, SAP, Snowflake, and Power BI.
- Apply responsible AI, privacy, security, access, auditability, source traceability, and human-approval controls to AI and Claude solutions.
- Classify use cases by data sensitivity, business risk, required approvals, support model, and deployment readiness before production rollout.
- Maintain documentation for use cases, data sources, prompts, assumptions, controls, testing results, owners, risks, and success metrics.
- Create test plans for functional behavior, prompt quality, grounding, security, regression, user acceptance, and post-deployment monitoring.
- Partner with QA and Training resources to produce test scripts, user guides, release notes, support procedures, demos, and adoption materials.
- Measure value through hours saved, cycle-time reduction, improved quality, better customer support, user adoption, and decision-support improvements.
- Use Claude selectively for approved use cases involving long-context reasoning, document analysis, comparison, summarization, structured drafting, and requirements synthesis.
- Apply Claude to policy/procedure review, executive communication, project documentation, training content refinement, technical explanation, and business analysis where appropriate.
- Support controlled Claude Code or comparable code-assist scenarios for code review, test generation, refactoring, documentation, and migration planning under human-review controls.
- 5–8 years in software engineering, automation, analytics engineering, AI solution delivery, enterprise application development, solution architecture, or a related technology role.
- Demonstrated, hands-on Snowflake experience (including working with data models, schemas, and Cortex) required.
- Experience delivering workflow automation, integration, reporting, or AI-enabled business solutions in a business-facing environment.
- Experience with Microsoft 365, Power Platform, Copilot Studio, Azure AI, Azure OpenAI, Claude and comparable AI and automation tools.
- Experience integrating with enterprise platforms such as Salesforce, SAP, Snowflake, Power BI, SharePoint, Teams, or similar systems.
-
Candidates must be authorized to work in the United States without current or future employer sponsorship.
-
Candidates must maintain their primary residence within the Chicagoland area throughout their employment.
- Deep expertise in Snowflake (including Cortex) and Microsoft Copilot Studio.
- Solid proficiency in Python, JavaScript, SQL.
- Strong working knowledge of Power Automate, Azure AI, OpenAI, prompt engineering, AI agents, APIs, connectors, workflow orchestration, and RAG patterns.
- Practical understanding of Claude AI for document analysis, structured writing, long-context summarization, requirements synthesis, technical explanation, and controlled code-assist scenarios.
- Proficiency with SQL and practical experience with Python, scripting, APIs, low-code/no-code tools, or similar development methods.
- Understanding of data quality, metadata, lineage, access controls, retention, source attribution, and information governance.
- Preferred: Microsoft Certified: Azure AI Engineer Associate, Microsoft Power Platform certification, Copilot Studio/Azure OpenAI/AI fundamentals certification, or Snowflake, Power BI, Salesforce, security, or related enterprise platform certification.
- Strong communication skills with the ability to explain AI concepts, risks, limitations, and business value in practical terms.
- Hands-on problem-solving mindset with the ability to move from idea to prototype to controlled production deployment.
- Ability to challenge AI use cases when risks exceed value or when AI is not the right solution.
- Strong analytical thinking, attention to detail, documentation discipline, and cross-functional collaboration.
- Partner with internal and external engineering teams to prepare and leverage enterprise data in Snowflake, making it agent-ready for agentic workflows.
- Build production-ready AI agents on top of Snowflake, leveraging Snowflake Cortex as the AI layer and Microsoft Copilot Studio to design, deploy, and maintain agentic workflows that act on unified data from Salesforce, SAP, and our Fundraising App.
- Partner with internal and external engineering teams to prepare and leverage enterprise data in Snowflake, making it ready for agentic workflows.
- Develop forecasting and predictive capabilities in Snowflake, using Cortex to turn unified enterprise data into forward-looking business insight.
- Develop deep mastery of our data models, schemas, and data — both inside and outside our environment — to ground AI solutions in accurate, well-understood sources.
- Practical AI and Claude-assisted use cases move from concept to controlled production with clear ownership, documented controls, and measurable value.
- AI outputs are grounded in approved enterprise data and content, cite sources where appropriate, identify conflicts, and avoid unsupported conclusions.
- Solutions integrate appropriately with Salesforce, SAP, Snowflake, Power BI, Microsoft 365, Power Platform, and approved AI tools without bypassing platform governance.
- Responsible AI, security, privacy, access, audit, and human-approval requirements are embedded into solution design and release practices.
- Reusable prompt libraries, agent patterns, Claude usage patterns, testing methods, documentation standards, and governance checkpoints are adopted across departments.
- Base salary of $140,000-$155,000 annually
- Annual Bonus: 5% of base salary, based on company and/or individual performance
- Medical insurance
- Dental insurance
- Vision insurance
- Wellness Program
- 401k Matching
- HSA/FSA
- LifeLock Identity Theft Protection
- STD/LTD
- Life Insurance
- Tuition Reimbursement