CASY-MSCCN Jobs

Senior Business Analyst.Remote – IndiaJR010923

DUTIES AND RESPONSIBILITIES

Position Overview:

We are seeking a highly skilled and experienced Expert Excel Developer and Data Integration Specialist to join our team. The ideal candidate will be responsible for creating and maintaining Excel-based tools and applications that support our business processes and data analysis needs. This role requires proficiency in VBA programming, system integration, and project management.

Key Responsibilities:

• Excel Development:

• Design and implement complex Excel formulas, macros, and VBA scripts.

• Develop and maintain advanced Excel-based tools and applications to support various business processes.

• Utilize VBA programming to automate tasks, enhance functionality, and improve efficiency.

• Create complex formulas, pivot tables, and charts to facilitate data analysis and reporting.

• Data Integration:

• Integrate Excel tools with other systems and databases to ensure seamless data flow and accuracy.

• Develop and maintain data connections using APIs, ODBC, and other integration methods.

• Ensure data integrity and consistency across multiple platforms.

• Project Management:

• Lead and manage projects related to Excel tool development and data integration.

• Collaborate with cross-functional teams to gather requirements, define project scope, and deliver solutions on time.

• Provide training and support to end-users on the use of Excel tools and applications.

• Business Analysis:

• Analyze business processes and identify opportunities for improvement through Excel-based solutions.

• Develop and implement data analysis models to support decision-making and strategic planning.

• Generate and present reports to stakeholders, highlighting key insights and recommendations.

• Optimization and Troubleshooting:

• Optimize workbook performance and ensure data integrity.

• Troubleshoot and resolve Excel application bugs.

Qualifications:

• Education:

• Bachelor’s degree in Computer Science, Information Technology, Business Administration, or a related field.

• Experience:

• Minimum of 5 years of experience in Excel development, including advanced VBA programming.

• Proven experience in system integration and data management.

• Strong project management skills with a track record of successfully delivering projects on time and within scope.

• Technical Skills:

• Proficiency in Excel, including advanced functions, formulas, pivot tables, and charting.

• Expertise in VBA programming for automation and custom functionality.

• Experience with data integration tools and techniques (e.g., APIs, ODBC).

• Familiarity with database management systems (e.g., SQL Server, Oracle).

• Soft Skills:

• Excellent analytical and problem-solving skills.

• Strong communication and interpersonal skills.

• Ability to work independently and as part of a team.

• Detail-oriented with a focus on accuracy and quality.

Preferred Qualifications:

• Certification in Microsoft Excel or related technologies.

• Experience with other programming languages (e.g., Python, R) is a plus.

• Knowledge of business intelligence tools (e.g., Power BI, Tableau).

• Good understanding of finance fundamentals

JR010923