Job Description

About Vivid
Vivid builds modern financial reporting, budgeting and analysis software for finance and operations teams that rely on Excel but need stronger data foundations, governance, and performance than legacy reporting tools can provide. Our platform connects Excel—where finance teams already live—to governed, scalable, financial and operational data warehouse, without the fragility of legacy tools.

Our work sits at the intersection of Excel, SQL Server, secure data access, and cloud-orchestrated services. We focus on pragmatic architecture that delivers value quickly, scales sensibly, and remains understandable to both technical and business stakeholders.
________________________________________
The Role

We’re looking for a senior full-stack developer with architecture experience who can both deliver production code and orchestrate the technical work across a small team.

This is not a “pure architect” role and not a narrow implementation role. You’ll be hands-on while also helping break problems into use cases, define technical approaches, and guide other developers toward clean, maintainable solutions.
________________________________________
What You’ll Be Responsible For

Delivery (Hands-On Development)
•\ Build and maintain an Excel Web Add-in used by finance teams in Excel Online and desktop
•\ Develop cloud APIs that coordinate report execution, parameters, and results
•\ Build and evolve a secure on-prem connector service that accesses customer SQL Server environments or connect to Azure-based cloud infrastructure.
•\ Design and tune SQL queries and schemas for reporting and analytics use cases
•\ Ensure reliability, performance, and security across the full system
Architecture & Technical Leadership
•\ Translate business and reporting needs into clear technical use cases
•\ Define system boundaries, responsibilities, and data flows
•\ Help decompose larger initiatives into well-scoped work items
•\ Review designs and implementations from other developers
•\ Establish pragmatic standards for performance, security, and maintainability
•\ Act as a technical partner to product and business stakeholders
________________________________________
Core Technical Skill Areas

Excel & Office Add-ins (Critical)
•\ Excel Web Add-ins using the Office Add-ins platform
•\ Office.js Excel APIs:
o\ Tables, ranges, formatting
o\ Refresh and recalculation patterns
•\ Add-in manifests and deployment via Microsoft 365 Admin Center
•\ Authentication and SSO patterns within Excel add-ins (Entra ID)
________________________________________
Backend & Orchestration Services
•\ Designing and building REST APIs
•\ Authentication and authorization:
o\ OAuth 2.0 / JWT
o\ Microsoft Entra ID
•\ Async and background job processing:
o\ Status tracking
o\ Retries and failure handling
•\ API performance concerns:
o\ Paging, limits, payload shaping
•\ Strong logging and diagnostics

Preferred stacks
•\ .NET / ASP.NET Core (strong preference)
•\ Node.js / TypeScript acceptable if experience is deep
________________________________________
On-Prem Connector & Secure Data Access
•\ Windows Service or Worker Service development
•\ Secure configuration and credential handling (DPAPI, certificates)
•\ SQL Server connectivity using Microsoft.Data.SqlClient
•\ Outbound-only connectivity patterns:
o\ SignalR / WebSockets
o\ Polling fallback
•\ Reliability patterns:
o\ Auto-reconnect
o\ Timeouts and retries
o\ Running as a service account
•\ Deployment via installer or scripted setup
________________________________________
SQL Server & Reporting Architecture
•\ SQL Server performance fundamentals:
o\ Indexing
o\ Execution plans
o\ Query tuning
•\ Stored procedures and views
•\ Parameterized queries and security
•\ Designing reporting- and analytics-friendly schemas
•\ Safely handling large datasets and long-running queries
________________________________________
Data & Semantic Thinking (Important)
While this is not a BI modeling role, the work requires strong instincts around:
•\ Separating raw data access from business-meaningful representations
•\ Designing data structures that support reuse across many reports
•\ Consistent definitions, filtering, and aggregation logic
•\ Supporting search, parameterization, and metadata-driven reporting
________________________________________
Frontend Skills (Add-in UI)
•\ TypeScript (strongly preferred)
•\ React or equivalent modern UI framework
•\ UX for:
o\ Parameter entry
o\ Validation and error states
o\ Progress and status feedback
•\ Working within Excel task pane UI constraints
________________________________________
DevOps & Operations
•\ Azure fundamentals:
o\ App Services or containers
o\ Storage
o\ Key Vault
•\ CI/CD pipelines (GitHub Actions or Azure DevOps)
•\ Monitoring, logging, and production diagnostics
________________________________________
What We’re Really Looking For
You are:
•\ A senior developer who still enjoys writing code
•\ Comfortable thinking in systems, not just features
•\ Able to turn ambiguity into concrete technical plans
•\ Practical, not academic, about architecture
•\ Confident collaborating with other developers and non-technical stakeholders
You’ve likely played roles such as:
•\ Senior Full-Stack Developer
•\ Technical Lead
•\ Staff Engineer on a small platform team
________________________________________
Engagement Details
•\ Part-time (~20 hours per week)
•\ Fully remote
•\ Long-term collaboration
•\ High trust, high ownership, low process overhead",