Software Developer - VBA/Access

We are seeking an accomplished Software Developer to work on our premier insurance administration and proposal systems. The successful candidate enjoys working in a fast-paced and dynamic environment as a key part of a highly skilled and committed team.

Essential Duties & Responsibilities:

• Work effectively and collaboratively in an agile environment
• Actively participate in the review of business requirements
• Analyze business/technical problems
• Develop estimates for assigned work
• Communicate well and work in partnership with our business partners and IT resources
• Code highly effective and highly usable solutions, completing tasks accurately and in agreed upon timelines
• Follow systems standards, procedures and delivery methodology and provide input for continuous improvement
• Support production problem resolution
• Understand the business processes support by our applications
• Continually develop technical and business knowledge & skills
• Work professionally and effectively with co-workers, clients, vendors and others with whom FullscopeRMS does business
• Document systems and processes as needed
• Remote, onsite, hybrid work locations as required

Critical Skills:

Minimum 4+ years previous Microsoft Access/VBA, SQL Server. Preferred experience in SQL Server Integration/Reporting Services (SSIS & SSRS).

• Strong knowledge of software delivery, processes and tools leveraged in a mature IT environment
• Successful agile/scrum experience
• Solid knowledge of unit testing and overall delivery process
• Creativity, critical, analytical thinking and well-developed problem-solving skills
• Adaptable and committed to excellence

PERFORMANCE DETAILS

1. What s the major objective(s) of the role? Specifically, what does this person need to do to be considered a success? What will they be working on?

The candidate will be working on a long-running proprietary application that involves a deep understanding of legacy tools/technologies. The candidate should be a problem solver and be able to work independently (while having a highly supportive and proficient team they can rely on should they need help).

1. What are the MUST-HAVE technologies for this position? (Please list must-have technologies / technical skills and what the candidate needs to do to be considered great at them)
2. Microsoft Access / VBA
3. SQL Server
4. SQL Server Integration / Reporting Services
5. Powershell

1. What are the MUST HAVE Critical Skills for this position (For critical skills, please also describe what the person needs to do with them to be considered very good at it.)
2. Positive can-do attitude
3. Experience working on legacy, long-running, and business-critical applications
4. The ability to respond to interrupts such production incidents on a routine basis
5. Database architecture expertise
6. Prior participation in application modernization efforts

1. What are the NICE TO HAVE technologies you wouldn t mind seeing on a candidate s resume?
2. Familiarity with containerized applications (Kubernetes, EKS, Docker)
3. Familiarity with Amazon Web Services (AWS)
4. Familiarity with security software tooling (Snyx, Checkmarx, Wiz)
5. Familiarity with Continuous Integration tools (Github Actions, Jenkins)