Talent.com
Lead Systems Integration & Automation (Boston)

Lead Systems Integration & Automation (Boston)

The Stepping Stones Group, LLCBoston, MA, US
5 hours ago
Job type
  • Part-time
Job description

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

  • Lead and mentor a small team of developers and automation engineers, conducting code reviews, training, and coaching.
  • Partner with business stakeholders and analysts to translate requirements into working technical solutions.
  • Oversee project planning, sprint execution, and delivery, ensuring commitments are met on time.
  • Define and enforce best practices for SQL coding, API development, RPA design, and cloud integration.
  • Serve as the primary technical lead for systems integration and automation, balancing team management with active development.
  • Foster a culture of innovation, knowledge sharing, and continuous improvement.

    • Qualifications : Required :

  • Bachelors degree in Computer Science, Software Engineering, or related field.
  • Strong hands-on expertise with Microsoft SQL Server (database design, T-SQL, performance tuning, stored procedures, triggers).
  • Proven experience with C#, .NET Core / .NET Framework, and ASP.NET Web API development.
  • Hands-on experience with Microsoft Graph API and Microsoft 365 integrations.
  • Practical experience with Microsoft Power Automate (Cloud & Desktop) and RPA best practices.
  • Experience with Azure services (Functions, Logic Apps, API Management, Service Bus).
  • Proficiency with Git and CI / CD pipelines (Azure DevOps or GitHub Actions).
  • Demonstrated leadership experience guiding small technical teams.

    • Preferred :

  • Experience with Power Platform (Power Apps, Dataverse, Power BI).
  • Exposure to containerization technologies (Docker, Kubernetes).
  • Knowledge of messaging systems (RabbitMQ, Kafka, Azure Service Bus).
  • Microsoft certifications such as :

    • 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.

    Create a job alert for this search

    Integration Lead • Boston, MA, US