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.
Skills Required
- 7+ years of professional engineering experience building complex, high-volume system integrations
- Extensive experience managing multi-layered authentication (OAuth2, OIDC, SAML) within a Microsoft enterprise tenant
- Ownership and implementation experience with Azure Entra ID / Azure Active Directory, Service Principals, and conditional access scopes
- Expert-level proficiency in Python and FastAPI for building high-performance servers
- Ability to deconstruct and understand .NET / C# SDKs and native Microsoft data handling
- Experience designing end-to-end data movement between Microsoft Cloud storage and vector databases, choosing patterns like Webhooks or Delta Queries
- Proven ability to map internal and external data flows balancing high-fidelity retrieval with enterprise security compliance
- Subject matter expertise in Microsoft system design to ensure resilience against throttling and service interruptions
Code and Theory Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Code and Theory and has not been reviewed or approved by Code and Theory.
-
Leave & Time Off Breadth — Time-off policies include an “unlimited”/flexible PTO approach with paid holidays/sick time and seasonal early-close Fridays, offering notable flexibility. These options provide additional downtime beyond standard accrual models.
-
Healthcare Strength — Core medical, dental, and vision coverage is part of the standard package, with employer-verified health plan information cited as current. Life and disability insurance further reinforce foundational coverage.
-
Retirement Support — A 401(k) with employer match is included in the package, supporting long-term savings. Candidates are encouraged to confirm the match formula during the offer stage.
Code and Theory Insights
What We Do
Code and Theory is a strategically driven, digital-first creative agency that lives at the intersection of creativity and technology. We solve consumer and business problems across the entire customer journey that flex to meet the ever-changing needs of consumer expectations. We put the user, their behaviors and needs, at the center of everything we do — from our proprietary research methodologies, to product development processes, to how we create brand, channel and messaging strategies. Our goal is simple: to solve our clients business problems. We bring big ideas to life by looking holistically at brand ecosystems where digital plays a prominent role in driving the consumer from first-touch through to conversion to relationship deepening over time. We identify gaps in the consumer journey and opportunities in culture that require products, services or communications to fill. We work across categories, ranging as far and wide as health care (Pfizer, Sanofi, Reach MD, Bioreference Laboratories) to financial services (JP Morgan Chase, Prudential, Morgan Stanley, First Data) to cpg (Mars, Unilever, Johnson & Johnson) to technology companies (Facebook, Xerox, Samsung, Comcast) to culture brands (adidas, H&M). And because our DNA is in publishing — we’ve embedded in over 135 newsrooms in the past decade — we bring unique expertise in understanding how content is created, distributed and optimized, including our work with CNN, NBC News, NBC Sports, and Bustle Digital Group. At Code and Theory, we strive to only be limited by our own ambition and creativity. We believe in pushing our creativity beyond the easy and obvious answers in order to deliver the solutions that are right for our clients, their businesses, and their consumers.
Gallery
