IT Application Support and Data Analyst- Stoughton

Application Support and Data Analyst

General description

Provide tier-two application support for the accounting systems. Work closely with the business stakeholders to create reports in Excel, SSRS, and SAP Crystal.  Qualified candidate should have extensive knowledge of T-SQL, and capable of fetching data from SQL server. Candidate will be working a lot in Excel to transform tabular data into pivot reports with charts and graphs.

Responsibilities

• Respond to user issues and requests via IT service desk application
• Establish yourself as the ERP application expert for the business by learning every aspect of the enterprise
• Use SSMS to write SQL queries to fetch data
• Utilize views, functions and procedures to define data sets
• Create tabular and graphical reports for the executive data review board
• Run reports, update tables and perform tasks associated with the ongoing operation of the software environment
• Document software defects and participate in resolution discussions with development team
• Maintain knowledge- based article information of documented processes/fixes and modified systems
• Keep current with trends IT and application industries and advise accordingly
• Train end users on the operation of software applications, develop end user documentation

Skills/Qualifications

• Proficient in Excel, Power Pivot, T-SQL
• Prior experience in Microsoft Query or Power BI is a plus
• Outstanding organizational skills with ability to manage multiple priorities
• Ability to drive work to completion and escalate when necessary
• Strong verbal and written communication skills
• Problem solving/trouble-shooting abilities
• Demonstrated analytic and problem-solving skills