VBA Developer automating Excel-based tasks for Benchmark Gensuite. Collaborating with teams to create efficient data processing and reporting workflows in a hybrid environment.
Responsibilities
Develop and implement VBA macros and applications to automate various Excel-based tasks, such as data entry, data extraction, data formatting, and report generation
Design and build custom Excel solutions to streamline data processing, analysis, and reporting workflows
Troubleshoot and debug existing VBA code to ensure optimal performance and reliability
Collaborate with cross-functional teams to understand business requirements and translate them into effective Excel-based solutions
Provide training and support to end-users on the usage and maintenance of the developed VBA applications
Stay up-to-date with the latest trends and best practices in Excel VBA programming and data manipulation techniques
Continuously improve and enhance the existing VBA applications based on user feedback and changing business needs
Requirements
Bachelor's degree in Computer Science, Information Technology, or a related field
Minimum 2-3 years of experience in VBA programming and Excel automation
Proficient in writing and debugging VBA code, including the use of macros, user-defined functions, and custom forms
Strong understanding of Excel's features, formulas, and data manipulation capabilities
Familiarity with data analysis techniques, such as pivot tables, charts, and data visualization
Ability to work collaboratively with cross-functional teams and communicate technical concepts effectively
Hands-on experience in developing user-friendly and intuitive Excel-based applications
Knowledge of software development best practices, including version control, documentation, and testing
Benefits
annual bonus programs
regular team-building events
off-cycle reviews to promptly give excellent performers their due
engaging team activities including happy hours and exciting virtual events
safe and supportive space through Benchmark Gensuite Team Member Networks like the Respect for Diversity Group and the Sustainability Group
Lead Applications Developer managing security systems for UPS. Overseeing development and integration of technology roadmaps with a focus on innovation and compliance standards.
Senior Developer Manager at PwC leading teams to deliver innovative software solutions. Focusing on strategic planning, mentoring staff, and enhancing business performance through technology.
Manager, Engineering responsible for supervising claims team in Ontario. Leading technical aspects for insurance claims related to structural damage and collaborating with various teams.
Workday Sr. Integration / Extend Developer designing and maintaining integrations for Workday. Collaborating with HR, IT, and business stakeholders to ensure seamless data flow.
C# Developer for CBC/Radio - Canada's OTT team enhancing digital platforms. Collaborating to deliver quality product development meeting user needs in a bilingual environment.
Mobile Developer creating mobile solutions for clients at JAKALA in Hamburg with a hybrid work model. Utilizing Kotlin and Swift in agile teams for top - quality user experiences.
Design and implement AI/ML solutions for clients and integrate them into production systems. Mentor team members, define quality objectives, and advise clients on technical trade - offs.
Customs Power BI Developer managing customer analytics and improving data processes at global customs organization. Coordinating with various transportation business units and ensuring data quality.
Founding Engineer developing automation solutions and scalable architecture for a PropTech startup. Collaborating with founders to drive innovation in the real estate industry.