Job Description
Insight Global is looking for a Solution Architect specializing in Microsoft Power Platform to join one of their investment banking and advisory clients in New York City or Warren, NJ. The individual will be responsible for designing, governing, and delivering enterprise-grade solutions across Power Apps, Power Automate (cloud and desktop), Dataverse, and Power Pages. This role is responsible end-to-end architecture, integration with Azure services, data platform alignment, security design, ALM governance, and performance optimization across mission-critical workloads. The ideal candidate has deep platform expertise, strong azure integration experience, and a track record delivering scalable, secure solutions in regulated environments. This is a hybrid role requiring 3 days a week onsite in Midtown, NYC or Warren, NJ.
Day to day
•Design and build enterprise Power Platform solutions (Power Apps, Power Automate, Dataverse, Power Pages)
•Define architecture and governance (environments, DLP, access, deployment strategy)
•Integrate with Azure services (SQL, Data Factory, Functions, APIs, Service Bus)
•Build and manage ETL/data pipelines (ADF, Databricks, Synapse)
•Design scalable data models in Dataverse and ensure performance optimization
•Implement security, compliance, and access controls (AAD, RBAC, DLP, regulatory standards)
•Establish CI/CD pipelines and manage deployments (Azure DevOps, GitHub)
•Monitor performance, optimize cost, and improve system efficiency
•Partner with stakeholders to translate requirements into technical solutions
•Produce architecture docs and lead technical discussions/workshops
•Evaluate and implement new capabilities (Fabric, Copilot, AI Builder)
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
•6-8 years enterprise application architecture; 5+ years Power Platform
•Financial services experience (IB, M&A, capital markets preferred)
•Strong development in Power Fx, JavaScript/TypeScript, C#, and APIs
•Deep knowledge of Dataverse, Azure integrations, and event-driven design
•Experience with RPA (Power Automate Desktop) and data platforms (Databricks, Spark)
•Understanding of networking (VNET, private endpoints)
•Strong communication and documentation skills
Nice to Have Skills & Experience
•PL-600: Power Platform Solution Architect Certificate
•PL-400: Power Platform Developer Certificate
•PL-200: Power Platform Functional Consultant Certificate
•Power Automate RPA Developer Associate Certificate
•Azure Solutions Architect Expert (AZ-305) Certificate
•Fabric Analytics Engineer Associate Certificate
•Fabric Data Engineer Associate Certificate
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.