About Zone & Co
Zone & Co is a leading SaaS company committed to freeing finance teams from the limitations of clunky, disparate systems and manual processes. Our rapidly growing portfolio of solutions is built on the Oracle NetSuite platform (the leading cloud-based ERP software platform) and offers advanced automation and integration solutions to a wide spectrum of business-critical functions, including complex billing & revenue recognition, to off-the-shelf advanced reporting, Payroll, AP automation, payments, reconciliations, approvals and more.
Zone helps over 3,000 companies worldwide work smarter, faster, and more securely, whilst maximizing platform value. We do this with a growing innovation-minded team of over two hundred folks, based across North America, Europe, and Asia Pacific.
Our journey has only just begun and we are excited to welcome talented individuals looking to grow alongside us. If this sounds interesting to you, we’d love to hear from you!
Learn more at www.zoneandco.com or follow us on LinkedIn: linkedin.com/company/zoneandco.
About the Role:
Join Zone & Co. as a Spreadsheet Add-In Developer, working remotely to design, develop, and deploy Office 365, desktop Excel, and Google Sheets add-ins. Utilize your advanced expertise in JavaScript, TypeScript, VBA, and the Office Add-ins platform to create efficient and secure integrations. Implement authentication and authorization mechanisms using Azure AD and OAuth to ensure optimal performance and data security.
You will be responsible for crafting intuitive user interfaces and optimizing data interaction within large datasets across different platforms. Collaborate with cross-functional teams, including product managers, designers, and backend engineers, to refine user experiences and document solutions. As part of Zone & Co's powerful tech workforce, your contributions will significantly impact transformative projects in the tech landscape, supporting our mission to innovate across the entertainment, financial, and logistics sectors. Elevate your career journey in our growth-oriented, diverse, and innovative organization.
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
- 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.
At Zone, our benefits are designed to enrich your life beyond the workplace. Recognizing that work is just a fraction of your overall life experience, we are dedicated to providing robust support. As a fully remote company, we prioritize flexibility and balance. Explore our comprehensive list of benefits at Zoneandco.com.
Zone and Co is an Equal Opportunity Employer committed to diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, age, national origin, disability, protected veteran status, gender identity, or any other factor protected by applicable federal, state, or local laws.
We strongly encourage candidates of all different backgrounds and identities to apply. This is an opportunity for us to bring in a different perspective and we’re eager to further diversify our company. Zone & Co is committed to building an equitable, inclusive, and supportive place for you to do some of the greatest work of your career.
#LI-Remote
