SWBC is seeking a talented individual to utilize systems and data to generate and improve reporting of business/accounting/payroll/benefits information in the most effective and productive manner. This individual will maintain current systems and assist in the implementation of new systems. This individual will make recommendations and changes in order to improve and support business activities for SWBC Professional Employer Organization (PEO).
Requirements
- Ability to write and modify VBA code in Excel for macros will be essential.
- Minimum of two (2) years of experience with computer programming in any language that is similar to VBA.
- Ability to work in and learn multiple systems.
- Working knowledge of audit procedures and processes, financial reporting, accounting and variance analysis, and continuous improvements.
- Familiarity with a wide variety of data reporting, retrieval and analysis tools, financial management methodologies, and financial algorithms, such as variance, profit/loss, cost, and financial statement analysis.
- Working knowledge of gathering and analyzing business intelligence in order to make recommendation to improve company results.
- Proficient computer and keyboard skills including Microsoft Office (Outlook, Word, and Excel).
Responsibilities
- Creates custom macros in VBA to help internal staff with increasing productivity.
- Creates custom reports in Informer with JavaScript.
- Produces and submits various reports to executive and senior management.
- Assists clients with the creation of custom reports to meet their business needs.
- Audits the control environment to ensure accurate financial reporting and controls are in place and that all components’ costs/rates/premiums due and payable by PEO clients or worksite employees are accurately calculated and collected/paid.
- Collaborates with the accounting and benefits teams to ensure they have the tools available to efficiently complete their reconciliation of payments to vendors/state tax collectors as well as the reconciliation of income and costs to the General Ledger (GL).
- Assists members of the PEO accounting and payroll teams in the creation of customized financial reports requested by PEO clients.
Other
- Bachelor’s degree in business administration, economics, computer programming, or related field from an accredited four year college or university required.
- Exceptional communication, preparation, and interpersonal skills in order to effectively communicate with a wide range of personnel.
- Strong analytical and problem-solving skills.
- Keen attention to detail and accuracy.
- Able to influence others and build strong rapport with internal customers.
