Our client, a professional services company located in New York City is currently seeking an Application / Integration Engineer with SQL Server Development, administration and integration skills and expertise in Power Apps to join their Application Development team. The candidate will be responsible for supporting the design, customization, implementation, integration, support and maintenance of enterprise applications. Duties include SQL development , administration (including upgrades and patches of software) and extensive use of Power Apps (mainly Power Automate). You will also be researching and evaluating future applications, performing software upgrades, coordinating projects and creating documentation: The engineer will use:
- SQL Server and Power Apps to develop and modernize legacy applications.
- Power Automate to create and automate workflows and recurring tasks.
- their experience to design, install, monitor, manage and troubleshoot the Firm's enterprise and database applications.
Applications include but are not limited to are the Firm's New Business Intake and Conflicts systems, Marketing systems, third-party vendor web applications, and other Legal applications. Duties
- Design, develop, customize, integrate, implement applications, upgrade systems and apply needed system patches for apps including: Marketing systems (Microsoft Dynamics, Gwabbit), Records, Conflicts (IntApp), HR systems (viDesktop), Legal, and other firm enterprise systems.
- Act as technical lead and provide knowledge transfer to other members of the Enterprise Applications Team..
- Administer, monitor, maintain and troubleshoot applications to ensure minimal downtime.
- Implement, update, and maintain data integrations including data transfer via middleware (IntApp, Boomi, SQL, MS Power Automate), vendor software APIs, and other systems as required.
- Develop and execute SQL queries.
Requirements
- Must be able to write complex MS SQL Server code.
- Have strong working knowledge of Web Service APIs for integration purposes.
- Solid experience with SSIS (SQL Server Integration Services)
- Good familiarity using Azure Power Automate (FLOW), Azure SQL, IntApp Integration Builder, Boomi and/or Biztalk.
- PowerShell or other scripting languages
Hybrid work environment (3 days in/ 2 days remote). Excellent benefits with low contribution. Salary range $150 to $175 based on experience.,