Lead Systems Integration & Automation (Boston)

Stepping Stones Group is seeking a hands-on Lead, Systems Integration & Automation with expertise in Microsoft technologies, including SQL Server, Microsoft Graph API, Power Automate, and Azure services. This role is an even split between hands-on technical work and leadership, making it ideal for someone who enjoys designing and building integrations while also mentoring and guiding a small development team. The successful candidate will deliver database-driven solutions, scalable APIs, and automation workflows, while ensuring best practices and alignment with business needs.

Primary Responsibilities :

Hands-On Development & Integration

• Database Development (SQL Server) : Design, develop, and optimize SQL Server databases, stored procedures, functions, and triggers. Apply indexing, partitioning, and performance tuning to ensure scalability and reliability.
• API Development : Build and maintain RESTful APIs using .NET Core / .NET Framework and integrate with Microsoft Graph API for Microsoft 365 services (Outlook, Teams, SharePoint, OneDrive, Azure AD).
• Automation (Power Automate) : Develop and maintain automation workflows across SQL Server, APIs, Microsoft 365, and Dynamics 365 using Power Automate (Cloud & Desktop). Troubleshoot and optimize existing automations for reliability.
• Cloud & Security : Leverage Azure Functions, Logic Apps, API Management, and Service Bus to deliver secure and scalable integrations. Implement authentication and authorization (OAuth, Azure AD, JWT) and ensure compliance with governance frameworks.
• Perform deep-dive troubleshooting and analysis across SQL, APIs, and automation workflows to ensure stability and performance.

Leadership & Collaboration

Qualifications : Required :

Preferred :

o Azure Database Administrator Associate

o Power Platform Developer Associate

o Azure Developer Associate

Supervision Exercised :

Direct guidance and oversight of development staff and contractors.