SSRS Data Analyst

  • Clearwater, FL, USA
  • Aug 31, 2017

Job Description

POSITION SUMMARY:The Data Analyst is responsible for a variety of tasks linked to Financial Systems and data including system interfaces and data reconciliation. Must be proficient in Microsoft Excel and creating queries and stored procedures utilizing T-SQL. Must have a thorough understanding of Microsoft SQL Server databases. Essential components of this position are working under minimal supervision while gaining a thorough understanding of systems data and interfaces.PRIMARY DUTIES AND RESPONSIBILITIES:Gather and analyze data in support of issues, projects, and systems requirements.Create, enhance, and maintain reports, spreadsheets, queries, and SSRS reports within the Microsoft SQL Server enterprise as assigned.Analyze complex data relationships, issues, determine solutions, and produce the desired outcome.Collaborate and partner with Managers and associates in business areas in researching, documenting, and testing changes to system interfaces.Work independently without constant supervision and direction.Produce accurate technical documentation of all projects/tasks including specifications and testing.Provide end user support as assigned thru the ServiceNow Service Management system.Follow all prescribed standards as defined by Information Technology Team (I.T.T.).Maintain a high service oriented attitude and take ownership of issues/assigned projects.Communicate effectively and professionally, in both oral and written communications, with all levels of technical and non-technical personnel.Perform any other function required by I.T. T. Management for the successful operation of all I.T.T. services provided to our clients.SUPERVISORY RESPONSIBILITIES:No direct supervision of other company associates.EDUCATION AND EXPERIENCE REQUIREMENTS:Minimum of two (2) years experience developing SQL queries and SSRS reports.Minimum of two (2) years experience with advanced Excel spreadsheets/models.Knowledge of Mortgage Loan Processing and/or Servicing is helpful but not required.Familiarity with Power BI is desirable.Crystal Reports experience is also helpful.Skills:Programming experience using T-SQL and SSRS in a Microsoft SQL Server environment.Advanced Microsoft Excel formulas and data connected queries.Must possess strong troubleshooting and problem solving skills.Excellent written and oral communication skills, listening, presentation, and interpersonal skills.Ability to communicate ideas and issues in both technical and user-friendly language.Must possess organizational, time management, and motivational skills.Must be a Team Player with a strong work ethic.Experience Waiver: Management reserves the right to amend, modify or waive any education, experience or skill requirements for this position. Equipment to be used:Personal ComputerPrintersAny other equipment necessary to perform the normal functions of this job.PHYSICAL REQUIREMENTS:Typical Physical Demands:Must maintain a professional appearance.Position requires long periods of work at a desk, utilizing a keyboard and monitor.Typical Mental Demands:Must be open to change and able to deal with stressful situations:DeadlinesShifting PrioritiesWorkloadsClient SatisfactionMust be able to communicate desired objectives in a positive manner to all associates and other business-related professionals.Maintain a professional attitude.Working Conditions:Available to work evenings and/or weekends (as required).Work in an open office environment.Workdays and hours are Monday thru Friday 8:30 am to 5:30 pmADDITIONAL REQUIREMENTS:Ability to:Arrive to work on time.Follow directions from management.Interact well with co-workers.Understand and follow posted work rules and procedures.Accept constructive criticism.Act in a professional manner.This position outlines the basic tasks and requirements for the position noted. It is not a comprehensive listing of all job duties of the associate. FLSA STATUS: Exempt - provided by Dice

Associated topics: data analyst, data analytic, data engineer, data manager, data management, data quality, data warehouse, etl, hbase, sybase


e-Bit Consulting