Key Responsibilities:
O365 Installation and Configuration:
Install and configure Office 365 applications for users, ensuring proper deployment across various devices and platforms (Windows, Mac, Mobile).
Handle O365 license management, activation, and provisioning of user access.
Set up and configure O365 services like Exchange Online, OneDrive, Teams, SharePoint Online, and other cloud applications.
Ensure Office 365 compatibility with existing IT systems and software tools used within the organization.
Configure O365 security settings and ensure that security policies such as data loss prevention (DLP) and encryption are properly implemented.
O365 Troubleshooting and Support:
Provide technical support for O365 users, addressing issues related to installation, functionality, and performance.
Troubleshoot and resolve installation issues, login problems, and application errors for O365 applications like Word, Excel, Outlook, Teams, and others.
Manage O365 account issues, including password resets, account synchronization problems, and permission issues.
Coordinate with Microsoft support when necessary for advanced troubleshooting and resolution of complex technical issues.
Monitor O365 performance to ensure the environment is running smoothly and make adjustments as necessary.
VBA Script Development and Maintenance:
Develop, debug, and maintain VBA scripts for automating tasks within Excel, Outlook, Access, and other Office 365 applications.
Customize VBA macros to automate repetitive tasks, improve data processing, and integrate Office tools with other business applications.
Create and maintain customized Excel reports, dashboards, and data processing tools using VBA scripting to enhance business operations.
Optimize existing VBA scripts for performance improvements and ensure they meet user requirements.
Troubleshoot and debug VBA scripts to resolve issues and improve functionality.
User Training and Documentation:
Provide training and support to end-users on O365 applications and VBA scripts to ensure they are effectively using the tools for their daily operations.
Create and maintain documentation for O365 deployments, VBA scripts, troubleshooting procedures, and common issues.
Develop and deliver training materials and sessions to educate users on Office 365 features and best practices for using VBA automation tools.
Collaboration and Reporting:
Work closely with other IT teams (security, infrastructure, and support) to ensure that O365 configurations align with organizational policies and security protocols.
Provide regular status updates and reports on ongoing installation, support activities, and troubleshooting efforts to management.
Collaborate with business stakeholders to identify automation needs and develop solutions using VBA scripting.
Continuous Improvement:
Stay up to date with the latest O365 updates and VBA scripting techniques, integrating new features and capabilities into the organization's O365 environment.
Continuously monitor and improve O365 performance, ensuring that all services are being utilized optimally.
Suggest and implement improvements to the O365 configuration and VBA scripts based on feedback from end users and internal teams.
Required Qualifications:
Bachelor's degree in Information Technology, Computer Science, Business Systems, or a related field.
2-5 years of hands-on experience with Office 365 installation, configuration, and troubleshooting in an enterprise environment.
Strong expertise in O365 apps such as Exchange Online, OneDrive, Teams, Outlook, and SharePoint Online.
Proficient in VBA scripting for automating tasks in Microsoft Excel, Outlook, and other Office applications.
Solid understanding of Office 365 security policies and configuration, including data protection, DLP, and encryption.
Experience with PowerShell scripting for Office 365 administration tasks.
Strong problem-solving skills with the ability to troubleshoot and resolve technical issues in O365 and VBA scripts.

O365 installation knowledge / VBA script & troubleshooting

Job Description

Required Skills