Lead Assistant Manager

Description
Basic Function The Finance Systems analyst role requires a highly skilled technical consultant who will be responsible for: Managing and maintaining MD365 ERP suite and associated systems within the finance function Administration, incident and change management, system optimization, and integration support across finance applications Managing TM1 systems for data & other maintenance requests Handle requests for automation using VBA macro in excel Essential Functions Administer and maintain the MD365 Finance and Operations (F&O) environment, TM1 Planning system, and associated finance platforms. Monitor, triage, and resolve incidents, service requests, and change requests from finance users. Manage system security, user access, workflow configurations, and maintain system governance standards across both MD365 and TM1.  Work with finance teams to gather, understand, and implement system change requirements  Support integration activities across MD365, TM1, and external/internal platforms (CRM systems, banks, reporting tools, etc.).  Perform routine TM1 model maintenance, metadata updates, data load management, and basic model troubleshooting.  Collaborate with internal IT teams and external vendors to ensure timely resolution of escalated issues and planned upgrades.  Conduct periodic system health checks, audit reviews, and ensure compliance with IT and finance control frameworks.  Document system changes, workflows, integration maps, and technical procedures.  Assist in testing and validation during upgrades, patches, or deployments for both MD365 and TM1 systems. Identify and suggest automation or optimization opportunities within the finance systems landscape  Develop and maintain excel based macro automation tools across functions  Implement quality checks and validation processes to ensure the integrity and accuracy of financial data reported across TM1, MD365, and other platforms Conduct in-depth analysis of financial data, identify trends, and provide recommendations to improve planning and forecasting processes.  Continuously seek opportunities to optimize existing reporting solutions and introduce new technologies or methodologies to improve reporting accuracy and efficiency. Systems & Data Management Reconcile data between PBI, TM1 and D365, ensuring consistency and accuracy Maintain and enhance customized TM1 reports, including cube structures for people cost and customer-level aggregation Skills Technical Skills Microsoft Dynamics 365 Certifications (e.g., MB-300, MB-310). TM1/IBM Planning Analytics Certifications or badges Experience with Power Platform (Power BI, Power Automate) for reporting and automation initiatives Expertise in developing functional VBA macros in excel Familiarity with integration tools such as Azure Logic Apps, KingswaySoft, or similar. Background in finance operations within the utility, energy, or regulated industries is preferred    Process Specific Skills Working experience in IT Operations preferably in Finance domain Process flows, Documentation and preparation of SOPs Ability to work with clients independently Ability to drive conversation related to financial results with SBU leaders Soft skills (Desired) Excellent oral/written communication skills, presentation skills- MANDATORY Excellent organization and time management skills Excellent analytical skills and competent at logical reasoning Must be a self-starter, detail oriented with the ability to meet deadlines under pressure Able to prioritize multiple activities and projects Self-disciplined and result oriented Demonstrate attention to detail in a fast-paced work environment – especially during processing Ability to multitask Ability to work effectively as part of a team Commitment and drive for results Strong analytical skills  Ability to understand and question established process guidelines to bring about possible process improvements Work Experience & Other Requirements Must be a graduate in IT or Computer science with at least 6-8 years of experience Experience in working in IT support function involving MD365, TM1, VBA, and Power BI

---