Expert-level VBA programming in Excel with experience designing, developing, and implementing macros and scripts to automate tasks
Strong SQL skills, including writing complex queries and optimizing database performance
Advanced Excel proficiency, including complex formulas, data analysis tools, and pivot tables with large datasets
Familiarity with Git version control and collaboration with team members
Requirements:
Design, develop, and implement VBA macros and scripts to automate repetitive tasks and processes in Excel
Create user-friendly interfaces (user forms) for data input, processing, and reporting; optimize VBA code for performance and maintainability
Import and export data between Excel and external data sources, such as databases or cubes; establish connections to external data sources using VBA and ADO
Document VBA code, macros, and Excel solutions for future reference and knowledge sharing
Job description
Job Title - VBA Developer Location - Redmond, WA (remote) Duration - 10 – 12 months + Rate - DOE U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time. JOB DESCRIPTION
Advanced Excel Skills:
Proficiency in complex formulas, functions, and data analysis tools in Excel.
Ability to work with large datasets and utilize pivot tables for summarizing data.
VBA Programming:
Expert-level knowledge of VBA programming language and its application in Excel.
Experience in writing efficient and error-handling VBA code.
Experience in Design, develop, and implement VBA macros and scripts to automate repetitive tasks and processes in Excel.
Experience in Create user-friendly interfaces (user forms) for data input, processing, and reporting.
Experience in Optimize VBA code for performance and maintainability.
Experience in Import and export data between Excel and other data sources, such as databases or cubes.
Experience in Establish connections to external data sources using VBA and ADO (ActiveX Data Objects).
Good at Documenting VBA code, macros, and Excel solutions for future reference and knowledge sharing.
SQL Knowledge:
Strong SQL skills beyond basic queries, including the ability to write complex SQL queries and optimize database performance.
Git Version Control:
Familiarity with version control systems like Git for managing code changes and collaborating with other team members.
Problem-Solving:
Ability to identify business problems and devise practical Excel-based solutions.
Critical thinking skills to optimize processes and automate tasks.
Communication:
Excellent verbal and written communication skills to collaborate with team members and stakeholders.
The capability to explain technical concepts to non-technical personnel.
Continuous Learning:
Willingness to stay updated with the latest Excel features and VBA best practices.
Openness to explore and adopt new technologies to improve efficiency.
Business Understanding:
Understanding of business processes and data needs in various industries.
Ability to align Excel and VBA solutions with specific business objectives.
