Shire Jobs

Job Description

Assist in taking existing spreadsheets that have embedded VBA code and recoding them completely using a modern dotnet tech stack. This will include dotnet 8 WebApis that interact with existing sql databases, other REST apis, GraphQL Apis, etc

Assist in taking existing spreadsheets that have embedded VBA code and wrapping them with a .net 4.8 framework restful endpoint that utilizes COM to interact with the excel macros directly. The APIs should be written in a layered way that would allow for us replace the spreadsheet with code and port to dotnet 8 in the future.

Assist in taking existing spreadsheets that call external dotnet code (framework currently) to run existing models and wrap them in dotnet (framework or core depending on dependencies) REST apis

The purpose of the Wrapper API is to support existing model functionality, specifically those functions currently handled by Excel VBA and older .NET Framework implementations.

Given the complexity of these functions, and the expected tight MVP timeline, the proposed solution is to create a wrapper API around these functions, thus minimizing exposure to older technology.

The API will be developed using .NET 8 and will have a dependency on Office.Interop.

API Deployment needs to happen on a Windows OS. The choice between using a VM or a Container for the underlying infrastructure will depend on whether Office.Interop is supported. Further research is needed to make this determination.

As this API is a unique / one off requirement, it's important to think more on CI/CD Pipeline support (overall from time / effort perspective).

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

Skills and Requirements

7+ years experience with dotnet WebAPI development (C#) based on industry best practices with REST

Strong experience with Angular front end development

Layered architectures (will be taught & presented)

Adherence to code quality standards (including code scanning, security scanning, unit test coverage, etc)

Understanding of Excel macros and VBA code

Financial Industry Experience null

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 employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to 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 oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.