This role is responsible for architecting the deep tissue connectivity required for our RAG (Retrieval-Augmented Generation) services to securely and efficiently traverse complex enterprise data landscapes. The scope of work encompasses a multi-layered integration strategy: managing System-level data flows (storage and back-end), Service-level orchestration (logic and APIs), and UI-level integrations (extending the user experience within Microsoft platforms).

WHAT YOU'LL DO

• Design end-to-end data movement strategies between Microsoft Cloud storage and internal vector databases, selecting optimal patterns (Webhooks vs. Delta Queries) based on latency and rate-limiting constraints
• Own the Microsoft identity lifecycle, including the implementation of Azure Entra ID (Active Directory) protocols, Service Principals, and complex conditional access scopes
• Develop high-performance MCP (Model Context Protocol) servers using Python and FastAPI to expose nested Microsoft Graph schemas to AI agents
• Serve as the subject matter expert on Microsoft system design to ensure the platform remains resilient against enterprise-scale throttling and service interruptions

WHAT YOU'LL NEED

• 7+ years of professional engineering experience with a track record of building complex, high-volume system integrations.
• Extensive experience managing multi-layered authentication (OAuth2, OIDC, SAML) within a Microsoft enterprise tenant.
• Proven ability to map internal and external data flows, ensuring a balance between high-fidelity data retrieval and strict enterprise security compliance.
• Expert-level proficiency in Python/FastAPI, complemented by the ability to deconstruct .NET/C# SDKs to understand native Microsoft data handling.

ABOUT US

Born in 2001, Code and Theory is a digital-first creative agency that sits at the center of creativity and technology. We pride ourselves on not only solving consumer and business problems, but also helping to establish new capabilities for our clients. With a global client roster of Fortune 100s and start-ups alike, we crave the hardest problems to solve. We have teams distributed across North America, South America, Europe, and Asia. The Code and Theory global network of agencies is growing and includes Kettle, Instrument, Left Field Labs, Create Group, Current, and TrueLogic.

Striving never to be pigeonholed, we work across every major category: from tech to CPG, financial services to travel & hospitality, government and education to media and publishing. We value the collaboration with our client partners, including but not limited to Adidas, Amazon, Con Edison, Diageo, EY, J.P. Morgan Chase, Lenovo, Marriott, Mars, Microsoft, Thomson Reuters, and TikTok.

The Code and Theory network is comprised of nearly 2,000 people with 50% engineers and 50% creative talent. We’re always on the lookout for smart, driven, and forward-thinking people to join our team.