Programmer/Analyst II

This is a multi-faceted IT role that supports two organizations within Snap-on Incorporated. Snap-on SecureCorp administers insurance and claims for Snap-on franchisees in the U.S. and Canada, while Accounts Payable (AP) and Treasury support the company’s financial operations.

The position will support the SecureCorp team by providing technical ownership of departmental business applications, serving as the administrator, developer, and technical support resource for these systems. Applications include solutions built on the Salesforce force.com platform, Microsoft Access databases, and Microsoft Power Platform tools.

Support for the AP and Treasury organizations includes developing and maintaining Tableau and Power BI reports, writing SQL queries using Oracle SQL Developer, and acting as the primary technical contact for several web-based applications.

We are seeking a technically skilled, self-motivated individual who can analyze issues and ideas to develop effective solutions. The ideal candidate is eager to learn new tools, grow into a subject matter expert in our processes and technologies, and communicates effectively with management, business users, and IT partners. Responsibilities:

Major Responsibilities

Overall

• Collaborate with stakeholders, peers, and end users to define and write technical specs to enhance and implement business applications and processes
• Provide day-to-day operational support for all supported applications
• Perform cybersecurity and audit reviews for annual regulatory certifications

Salesforce Administration & Development

• Design, build, and maintain low-code/no-code automations and solutions
• Implement Salesforce platform and application releases, including user training and support
• Configure users, roles, profiles, security, page layouts, and reports
• Implement and support third-party Salesforce applications to improve usability and productivity
• Partner with application vendors on issues and projects requiring external support

Application Development & Support

• Develop and support Microsoft Access databases, including VBA code
• Coordinate with remote developers to replace Access databases with Power Platform solutions
• Become technical lead or primary backup to multiple financial applications

Reporting & Analytics

• Maintain and enhance Tableau reports; develop new reports as business needs evolve
• Create and maintain SQL queries to extract data from Access, SQL Server, Oracle, and Snowflake for imports into other tools and/or reporting and analysis
• Recreate Tableau reports in Power BI as part of a platform migration
• Analyze Salesforce data using Microsoft Excel and create VBA macros to streamline user reporting

• This position requires a technically minded self-starter who can drill down into issues and ideas to develop solutions and can also communicate and work well with management, users, and other IT professionals
• Bachelor’s degree with 5 years’ experience, or Associate’s with 10 years’ experience
• Previous experience in an IT support role a plus

Skills

• Salesforce administration, development, setup, and functionality is a plus, but not required
• Advanced analytical and problem-solving skills with a focus on identifying root causes
• Excellent English written and oral communication skills
• Experience with Java, C#/C#.NET, VBA, Visual Basic, VB.NET, and/or Python
• Tableau, Power BI, or other reporting tool
• Microsoft Access (creating tables, SQL queries, macros, and modules) or other relational databases (e.g. SQL Server)
• Microsoft Office, SharePoint, Power Apps, Power Automate, Power BI, Power Query
• HTML, XML, CSS, and JSON knowledge is a plus