Custom Reports Programmer II
Job Description:
Programmer II
This position can be 100% remote, however, if you're in the Chicagoland area you're in the office 2 days/week
Position Overview
The programmer will be responsible for using system tools, SQL, and in some cases high level language tools to develop custom solutions for our Payroll and HR system customers. They additionally may be required to interact with clients to gather requirements and will be developing solutions using financial and mathematical concepts.
Primary Responsibilities
The below represents the primary duties of the position, others may be assigned as needed. To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Interface with customer payroll data using SQL and Reporting programs
- Test calculations, reports, and system configurations; troubleshoot problems
- Validate the functionality of the end product according to the requirement specifications
- Partner with internal teams to refine customer requirements or identify alternative solutions
- Set client expectations of dates for different milestones in the process
- Explain rules, interfaces, reports and calculations to customers to ensure that the customizations meet their needs
- Mentors new employees and level I's while efficiently maintaining workload
Experience and Skills:
State the minimum education, experience, skills and certifications/training required to successfully perform the job.
- Bachelor’s degree in computer science/related field or equivalent work experience
- Ability to demonstrate an intermediate knowledge of SQL
- Technical background including competence in SQL Server and SQL Reporting
- Strong knowledge of relational database software
- Prior payroll experience a plus
- Two to three years’ work experience writing reports with SQL Reporting Services or other programming tasks
- Experience creating and modifying SQL Server Stored Procedures
- Experience creating and modifying SQL Server Reporting Services Reports(SSRS)
- Experience developing interface files to external systems
- Experience programming or reporting for accounting or payroll functions is a plus
- Familiarity with XML or XSLT translation is a plus