Job summary

Location:
Metro Detroit, United States, North America
Career Level:
Mid Career (2+ years of experience)
Education:
Diploma
Job type:
Full time
Positions:
1
Salary:
$60K - $75K
Apply before:
08 Sep, 2017
Cancel

Systems Analyst

  Bookmark this job About this job

Our client is a privately owned, well established automotive lending company specializing in originating and servicing sub-prime automotive loans. The company is looking for a for a well-rounded IT person who will responsible for maintenance and new development of SQL Server based systems.  This well-versed IT person will meet regularly with departmental staff to determine needs and receive assignment details. Must be able to gather information, formulate requirements, execute technical solutions, present to business, and be familiar with system development life cycle methodology. This position provides support to internal users requiring assistance with information technology issues and problems in a Windows environment; i.e. administrative and support of both hardware and software, maintaining and managing applications and operating systems.

The following are high level requirements for this role:

  • 3+ years of experience with SQL (experience with SQL server 2012)
  • 3+ years of T-SQL (stored procedures, functions, triggers)
  • Strong understanding of the SDLC, OOP, and structural programming

Responsibilities:

  • Supporting the business and the helpdesk on issues as required
  • To provide technical support; answering support queries via phone, email and fax
  • To maintain a high degree of customer service for all support queries and adhere to all service management principles
  • To take ownership of user problems and be proactive when dealing with user issues
  • Respond to inquiries from clients and help resolve hardware and software problems
  • Ensure proper documentation, notification, escalation, tracking, and follow up of all incidents
  • Create, write and update custom reports using SQL Server Reporting Services, and Access VBA from a MS SQL Server 2012 database for the business, as requested
  • Creating and altering SQL stored procedures, functions, views, triggers, T-SQL, cursors and other SQL database objects that assist in the implementation of business logic and data flows through application infrastructure
  • Monitoring and troubleshooting SQL jobs and integration services
  • Assisting with database maintenance tasks
  • On – call support as needed
  • Creates and maintains detailed documentation around technical processes.
  • Effectively manages customer and management expectations.
  • Ability to troubleshoot and resolve system issues and errors
  • Broad technical interest, flexibility, professionalism and initiative
  • Excellent communication skills; works well in a team environment

Experience:

  • 3+ years of SQL (SSRS, SSIS)
  • 3+ years of T-SQL
  • Knowledge of Microsoft operating systems
  • Bachelor’s degree in a technology-related field or equivalent work experience
  • Experience with VB Programming, C#, ASP.NET, OR access (preferred)
  • Experience with Visual Studio or TFS (preferred)

Job keywords/tags:  Systems Analyst , SQL , SSRS , SSIS , T-SQL , Procedures , Functions , Triggers , SDLC , OOP , Structural Programming