VBA/SQL PROGRAMMER

Job Description

Description/Job Summary

Company Values

In the performance of their tasks and duties all employees are expected to conform to the following Superior values:

INTEGRITY Adhering to Our Principles EXCELLENCE Continually Raising the Industry Standard

COMMITMENT Upholding Our Promises" PARTNERSHIP Creating Positive Relationships

Job Summary

This position is responsible for developing and maintaining VBA scripts and applications to automate tasks and enhance efficiency within various departments. They will design, develop, and optimize SQL queries and stored procedures for data extraction, transformation, and reporting purposes.

Responsibilities/Duties

Job Duties

Develop and maintain VBA scripts and applications to automate tasks and enhance efficiency within various departments.

Design, develop, and optimize SQL queries and stored procedures for data extraction, transformation, and reporting purposes.

Collaborate with stakeholders to understand business requirements and translate them into technical solutions.

Troubleshoot and debug existing VBA macros, SQL queries, and applications to ensure smooth functionality.

Create documentation for VBA scripts, SQL code, and application processes to facilitate knowledge sharing and maintenance.

Work closely with IT teams to integrate VBA/SQL solutions with existing systems and databases.

Stay updated on emerging technologies and best practices in VBA, SQL, and related fields to drive continuous improvement.

Creating and maintaining reliable data pipelines.

Data warehousing development.

Other duties as assigned.

Required Skills

Job Requirements

Bachelor's degree in Computer Science, Information Technology, or a related field.

Proven experience in VBA programming for Microsoft Excel and Access, with the ability to develop complex macros and applications.

Strong proficiency in SQL with experience in writing efficient queries, stored procedures, and triggers for Microsoft SQL Server or similar databases.

Experience with database management, normalization, and optimization techniques.

Familiarity with data analysis and reporting tools such as Power BI or Tableau is a plus.

Excellent problem-solving skills and attention to detail.

Strong communication and collaboration skills, with the ability to work effectively in a team environment.

Ability to manage multiple priorities and meet deadlines in a fast-paced environment.

Must possess the ability to maintain a high level of confidentiality.

Ability to read and write in a professional manner.

Ability to successfully pass a background and credit check.

Job Competencies

To perform the job successfully, an individual should demonstrate the following competencies:

Attendance/Punctuality - is consistently at work and on time; ensures work responsibilities are covered when absent; arrives at meetings and appointments on time.

Safety and Security - observes safety and security procedures; reports potentially unsafe conditions; uses equipment and materials properly.

Teamwork - contributes to building a positive team spirit; puts success of team above own interests.

Quality - demonstrates accuracy and thoroughness; monitors own work to ensure quality.

Productivity/Quantity - meets productivity standards; completes work in timely manner; strives to increase productivity; works quickly.

Dependability - follows instructions, responds to management direction; commits to long hours of work when necessary to reach goals; completes tasks on time or notifies appropriate person with an alternate plan.

Communication - listens and gets clarification; responds well to questions.

Details

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Essential functions may require maintaining physical condition necessary for sitting for long periods of time.

Work Environment/Tools and Equipment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

Work environment: While performing the duties of this job, the employee's work is located primarily indoors.

Tools and equipment regularly used; computer, calculator, phone, copier, fax machine, other office equipment and supplies.