_0.png)
Easy Apply
Easy Apply
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
Similar Jobs
This role requires analyzing data, documenting business processes, and participating in solution design and change management activities. The individual will collaborate on implementing solutions and track progress while managing status reporting. Strong interpersonal skills and banking domain knowledge are essential.
The Senior People Operations Business Analyst at Atlassian will manage operational analytics for various HR functions, analyze HR data, collaborate with HR teams to improve service delivery, and report findings to leadership. The role requires expertise in data analysis and visualization, problem-solving, and decision-making.
The Business Analyst/Sr. Business Analyst will analyze business requirements related to Oracle EBS Payroll, provide expertise on payroll modules, and collaborate with cross-functional teams to optimize payroll operations. Responsibilities include system configuration, documentation, troubleshooting issues, and suggesting process improvements while ensuring effective communication across different time zones.
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
