About the position
The Technical Services Software Engineer will report to the Technical Services Supervisor and be responsible for using various tools to complete software customization projects and implement Spectrum ADP solutions. Assignments will include developing custom Crystal Reports, SSRS reports and dashboards, implementing database objects (procedures, functions, and triggers), writing complex SQL queries, TSQL scripting, Proiv Screens and analyzing business data relationships. All aspects of the software development lifecycle will be experienced in this position, from requirements gathering to installation. A successful Technical Services Specialist must be action-oriented, capable of independently solving technical problems and able to communicate clearly and effectively to both technical and business audiences. This role entails juggling multiple projects while maintaining a high revenue rate and staying within budget. This position can be customer-facing at times and will work closely with the Technical Services Business Analyst and Manager to ensure project timelines are met.
Responsibilities
- Development and design of the solution, development of the solution and delivery per individual customer specifications.
- Delivers custom reports (Crystal Reports and SSRS), database customization projects, software integrations and data projects, including migrations and corrections (SQL scripts, SQL modification statements and other tools as needed).
- Executes the tests necessary to ensure that customizations meet scope requirements prior to installation.
- Proactively communicates the progress of projects to the Business Analyst and internal stakeholders, utilizing effective written and verbal communication skills.
Requirements
- Bachelor’s degree in computer information systems, computer science and/or accounting and a minimum of two years of custom programming experience or an equivalent combination of education and experience.
- Strong SQL knowledge including queries, triggers and stored procedures.
- Strong ProIV development skills.
- Strong Crystal Reports.
- Familiarity with XML.
- Familiarity with various types of databases.
- Basic familiarity with business accounting principles (e.g. payroll, accounts payable, accounts receivable, purchase orders).
Nice-to-haves
- Experience using construction accounting software and payroll. Spectrum ERP Software is preferred.
- Knowledge of the construction industry and construction accounting.
- Prior consulting experience with billable revenue expectations.
Benefits
- Medical, Dental, Vision, Life, Disability insurance.
- Time off plans and retirement plans.
- Tax savings plans for health, dependent care and commuter expenses.
- Paid Parental Leave.
- Employee Stock Purchase Plan.
