Data Engineer (Excel, VBA, SQL)

  • Taguig City, Metro Manila
  • Permanent
  • Full-time
  • 4 days ago
Title of the role: Data Engineer (Excel, VBA, SQL) We are seeking a detail-oriented Excel Database Support Specialist to provide technical support and maintenance for business-critical Excel applications that interface with MS SQL databases and utilize VBA macros. This role will serve as the primary point of contact for troubleshooting, optimizing, and enhancing Excel-based business solutions. Key Responsibilities Excel Application Support: Troubleshoot and resolve issues with complex Excel workbooks and templates used across the organization. Database Connectivity: Maintain and optimize connections between Excel applications and MS SQL databases. VBA Development & Maintenance: Debug, modify, and enhance existing VBA macros; develop new automation solutions as needed. User Support: Provide technical assistance to business users, including training and documentation. Performance Optimization: Identify and resolve performance bottlenecks in Excel applications and database queries. Documentation: Create and maintain technical documentation for Excel solutions and processes. Quality Assurance: Test Excel applications after updates or changes to ensure functionality and data integrity. Required Qualifications Technical Skills: Advanced Excel proficiency (pivot tables, advanced formulas, data analysis tools) Strong VBA programming experience MS SQL Server knowledge (queries, stored procedures, database connections) Understanding of ODBC/OLE DB connections Experience: 2-3 years in Excel development/support or similar technical role. Soft Skills: Strong analytical and problem-solving abilities, excellent communication skills. Preferred Qualifications Knowledge of SQL Server Management Studio Familiarity with data visualization tools Previous experience supporting business users in a corporate environment Show more Show less

foundit

Similar Jobs

  • Data Engineer [Python and SQL]

    Yondu

    • Taguig City, Metro Manila
    Design and build scalable big data infrastructure and solutions, leveraging available cloud resources Design, create and maintain ETL processes and data pipelines for functions su…
    • 1 month ago
  • Data Engineer [ ETL, SQL, Python]

    Yondu

    • Taguig City, Metro Manila
    Design and build scalable big data infrastructure and solutions, leveraging available cloud resources Design, create and maintain ETL processes and data pipelines for functions su…
    • 1 month ago