Match score not available

Senior Business Analyst.

Remote: 
Full Remote
Contract: 
Experience: 
Senior (5-10 years)
Work from: 

Offer summary

Qualifications:

Bachelor's degree in relevant field, Minimum of 5 years experience in Excel development, Proficiency in VBA programming and automation, Experience with data integration tools, Strong project management skills.

Key responsabilities:

  • Design and implement complex Excel tools
  • Integrate Excel with other systems and databases
  • Lead projects for Excel tool development
  • Analyze business processes for improvement
  • Optimize workbook performance and troubleshoot issues
Ensono logo
Ensono Large https://www.ensono.com/
1001 - 5000 Employees
See more Ensono offers

Job description

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

Required profile

Experience

Level of experience: Senior (5-10 years)
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Problem Solving
  • Social Skills
  • Microsoft Excel
  • Analytical Skills
  • Detail Oriented
  • Verbal Communication Skills

Business Analyst Related jobs