Job Description
We're actively seeking an expert-level individual highly skilled in VBA, C#, and Excel automation, specializing in transitioning from MS 2013 to 365 without business disruption. This role necessitates an exceptional professional with extensive experience in VBA coding, advanced formula development, and a proven track record in independent expert-level work. Additionally, expertise in analyzing and optimizing XML blob storage in databases, familiarity with project management tools like JIRA, and experience with OCR tools are essential.
Responsibilities
* Expert-Level Transition from MS 2013 to 365: Lead the seamless transition of VBA code modules from MS 2013 to 365 without any business impact. Execute meticulous testing and side-by-side comparison to ensure compatibility and functionality across both environments.
* Independent Expert Work: Perform expert-level work independently, ensuring precision and accuracy throughout the transition process.
* Technical Expertise and Testing: Conduct exhaustive testing and validation of converted code to guarantee functionality parity between MS 2013 and 365 without affecting business operations.
* Analysis of Data Storage Best Practices: Assess and analyze the storage of VBA-generated data in databases as XML blobs. Evaluate the best-fit storage practices, considering XML/JSON formats and their impact on database efficiency.
* Collaboration with Agile Development Tools: Utilize familiarity with tools like JIRA and Confluence for efficient agile development and collaboration with stakeholders.
* Excel Transformation and Publishing -- Programmatically transforming and storing excel as PDFs ensuring data integrity, accuracy and formatting in preserved.
* Problem Resolution and Optimization: Identify potential issues proactively, troubleshoot problems independently, and optimize code modules for MS 365 environment.
Required Skills & Experience
* Extensive and demonstrable expertise in VBA, C#, and Excel automation at an expert level.
* Proven track record in expertly transitioning VBA code modules from MS 2013 to 365 without business impact.
* Intermediate experience in SQL Server, capable of working with databases.
* Good understanding of XML and JSON formats and their storage within a database environment.
* Ability to analyze and determine the best-fit storage practices for VBA-generated data stored as XML blobs.
* Experience with OCR tools, such as Azure Document Intelligence Studio, for optimized data extraction.
* Proficiency in independent work, demonstrating a high level of precision and accuracy.
* Strong problem-solving skills and the capability to optimize code modules for MS 365 environment independently.
Nice to Have Skills & Experience
* Prior experience in Banking operations or a similarly regulated industry is advantageous.
* Familiarity with Atlassian Suite of Products for efficient collaboration and workflow management.
* Strong familiarity with Agile methodologies and practices for efficient project delivery
Benefit packages for this role will start on the 31st 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.