Technical Services Specialist (Consulting)

Job Title: Technical Services Specialist

Location: Chennai (Hybrid)

Work Timing: 6:30 PM to 3:30 AM IST (US Shift)

Summary

The Technical Services Specialist will report to the Technical Services Supervisor/Manager and be responsible for using various tools to complete software customization projects. Assignments will include developing custom Crystal Reports, SSRS reports and dashboards, implementing database objects (procedures, functions, and triggers), writing complex SQL queries, TSQL scripting 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 is customer-facing and will work closely with the Technical Services Business Analyst to ensure project timelines are met.

Essential Duties Responsibilities

Discovery of requirements and purpose, design of solution, development and delivery per individual customer specifications.

Performs business process analysis to ensure technical and application components meet business requirements.

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 customer and internal stakeholders utilizing effective written and verbal communication skills.

Competencies

• Strong customer success orientation and commitment to ensuring timely, quality solutions to customer issues.

• Gathers and analyzes information skillfully to identify and resolve problems in a timely manner.

• Ability to understand technical concepts and communicate them clearly to individuals with varied backgrounds and skill levels.

• Demonstrates accuracy and thoroughness, monitoring own work to ensure quality.

• Well-organized, self-directed team player. Prioritizes and plans work activities, uses time efficiently via conscientious multitasking and develops realistic action plans.

• Listens effectively, transmits information accurately and understandably, and actively seeks feedback. Remains open to others ideas, and exhibits willingness to try new things.

• Demonstrates professionalism and good judgment in all interactions with colleagues, customers, vendors and others. Responds to management direction and solicit feedback to improve performance.

• Handles confidential and sensitive information and records with a high degree of discretion, diligence and good judgment.

Required Qualifications

• 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.

• Familiarity with Crystal Reports and SSRS reports.

• Familiarity with SQL Server Integration Services (SSIS).

• Familiarity with various types of databases.

• Basic familiarity with business accounting principles (e.g. payroll, accounts payable, accounts receivable, purchase orders).

• Projects often require after-hours or weekend work and remote access.

Preferred Qualifications:

• Experience using construction accounting software and payroll.

• Knowledge of the construction industry and construction accounting.

• Prior consulting experience with billable revenue expectations.

Working Conditions

• Projects often require after-hours or weekend work and remote access.

• High stress levels may occur due to the time-sensitive and critical nature of the technical projects for customers.

• The ability to sit and work at a keyboard for extended periods of time and communicate with team members by phone, computer, and video teleconferencing is required.

Reports to: Technical Services Supervisor/Manager