Title Microsoft Excel, VB Scripting, VBA/ PennyMac/ DN

Role Overview: You will be responsible for designing, developing, and maintaining reports using Advanced Excel (Pivot Tables, Power Query, complex formulas) and VB Scripting/VBA. Your role will involve troubleshooting and resolving issues in existing reporting templates and automation scripts. Additionally, you will collaborate with onshore teams to gather reporting requirements and deliver effective solutions, ensuring data integrity, accuracy, and compliance across all reports and automation. You will be required to provide daily 23 hours evening overlap for coordination with onshore stakeholders, document processes, maintain version control, and update reporting templates/scripts. Participation in regular team meetings and contribution to continuous process improvement will also be part of your responsibilities. Key Responsibilities: - Design, develop, and maintain reports using Advanced Excel (Pivot Tables, Power Query, complex formulas) and VB Scripting/VBA. - Troubleshoot and resolve issues in existing reporting templates and automation scripts. - Collaborate with onshore teams to gather reporting requirements and deliver effective solutions. - Ensure data integrity, accuracy, and compliance across all reports and automation. - Provide daily 23 hours evening overlap for coordination with onshore stakeholders. - Document processes, maintain version control, and update reporting templates/scripts. - Participate in regular team meetings and contribute to continuous process improvement. Qualification Required: - Mandatory Skills: - Advanced Excel (Pivot Tables, Power Query, complex formulas) - VB Scripting / VBA - Desired Skills: - Strong analytical and problem-solving skills - Experience in financial reporting or data analysis Additional Details of the Company: N/A,