Spreadsheet Add-In Developer

View full description

Requirements:

• Proven experience in developing Office Add-ins using the Office JavaScript API, Office Add-ins platform, or VBA.
• Experience with FPNA and ERP systems Experience with Google Apps Script and Google Workspace Add-ons for Google Sheets integration.
• Intermediate knowledge and experience with Azure SQL databases, including writing optimized SQL queries.
• Familiarity with authentication and authorization mechanisms such as OAuth and Azure AD at an intermediate level.
• Knowledge of Excel Object Models and Google Sheets API at an intermediate level.
• Experience with REST APIs and web services at an intermediate level.
• Working knowledge of Docker, MySQL/Postgres, Redis, AWS services, and infrastructure management tools such as Terraform and Ansible is beneficial.

Responsibilities:

• Develop an Office 365 Excel add-in with a user-friendly UI (Excel Ribbon).
• Implement secure authentication and authorization using Azure AD.
• Enable connectivity to an Azure SQL data warehouse.
• Allow users to query and load datasets into Excel with filtering capabilities.
• Develop a Refresh Data button to manually trigger the update of data.
• Create modal dialogs to enable users to reference values from fields in the query.
• Adapt Office 365 Excel add-in for desktop installations (Windows & Mac).
• Ensure feature parity with the Office 365 version.
• Optimize performance for large dataset retrieval.
• Develop a Google Sheets add-on with the same functionality as the Excel versions.
• Implement Google OAuth authentication.
• Ensure seamless data querying and retrieval from Azure SQL.
• Develop an intuitive UI consistent with Google Sheets' interface.
• Ensure feature parity with the Office 365 version