DIESEL DIRECT INC. 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