VBA Programmer with Python (Macro coder)
Irvine, CA
Job Summary
We are seeking a skilled VBA + SQL + Python Developer (Micro coder) to develop, automate, and optimize business processes, reporting solutions, and data-driven applications. The ideal candidate will have strong experience in Excel VBA, SQL databases, and Python programming with the ability to create efficient automation tools, data processing solutions, and reporting frameworks.
Required Skills
Strong experience with Excel VBA/Macros
Proficiency in SQL (SQL Server, Oracle, MySQL, or PostgreSQL)
Hands-on experience with Python development
Experience in data extraction, transformation, and reporting
Knowledge of database design, stored procedures, and query optimization
Experience developing automation scripts and business tools
Strong analytical and problem-solving skills
Ability to work with large datasets and perform data validation
Key Responsibilities
Develop and maintain VBA-based automation tools and Excel applications.
Write and optimize SQL queries, stored procedures, and database scripts.
Build Python scripts for data processing, automation, and reporting.
Automate manual business processes to improve efficiency and accuracy.
Troubleshoot and resolve application and database-related issues.
Create reports, dashboards, and data validation solutions.
Collaborate with business users to gather requirements and deliver technical solutions.
Maintain technical documentation and support existing applications.